Links

Google Sheets Data Source

Overview

When a data source powers your app, you can continuously update your app contents without having to republish it. It allows you to build a dynamic app that can create, read, update, and delete data. This doc covers connecting your app to Google Sheets as the data source.
In Google Sheets, the entire document is considered to be the data source. To use a Google Sheet as a data source, the following must be true:
  • The first row in your sheet must be a header row, and every column must have a header.
  • Your Google Sheet must be sharable so that Thunkable can access the data.

Video Tutorial

How to Connect Your Thunkable App to a Google Sheets Data Source

In this tutorial, we’ll connect a Thunkable app to Google Sheets as a data source and display the data in our app.

Connect Your App to Google Sheets

  1. 1.
    Click the data icon in the left side panel to access your data source library.
  2. 2.
    Click the plus sign at the top of the panel.
  3. 3.
    You can select from previously added data sources or add a new data source. Click Create New.
  4. 4.
    Select Google Sheets.
  5. 5.
    Sign in to your Google account and grant permission for your Thunkable accoumt to access your Google Drive.
  6. 6.
    Click Select a Sheet.
  7. 7.
    Select your spreadsheet.
  8. 8.
    Click Select.
  9. 9.
    Rename the data source, if you’d like.
  10. 10.
    Indicate which row your column headers are in and which row is the first to contain data.
  11. 11.
    Click Create.
If you are using a G Suite for Education account and experience issues connecting to Google Sheets, contact your G Suite administrator to review your security settings.

Display the Data in Your App

Once you've connected a data source, you can display the data in your app with a data viewer component. Learn more about data viewer components here:

.xlsx Files

Connecting to .xlsx files that are hosted on Google Sheets is not supported, but you can convert your .xlsx file to a Google Sheet before connecting it to your Thunkable app project. To do so:
  1. 1.
    Open the .xlsx file on Google Sheets
  2. 2.
    Click File.
  3. 3.
    Select Save as Google Sheets.

Reset Your Google Sheets Connection

Reset from Thunkable

  1. 1.
    Login to your Thunkable account.
  2. 2.
    Click the My Data Sources tab on your Projects Page.
  3. 3.
    Click the trash can icon to delete the Google Sheets data source.

Reset from Google

If you are having difficulties connecting your Google Sheets from Thunkable, you may need to reset your Google Sheets connection.
  1. 2.
    Scroll to the Your connections to third-party apps & services section.
  2. 3.
    Click the Thunkable connection.
  3. 4.
    In the Thunkable has some access to your Google Account section, click See details.
  4. 5.
    Click Remove Access.
  5. 6.
    Return to Thunkable and re-connect to your Google Sheets account.
Have feedback on this doc? Please take a moment to share your feedback here: Thunkable Docs Feedback. Your valuable insights will help us improve and better serve you in the future.