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.
  12. 12.
    Refresh your page to ensure the data is reflected in web preview or via the Thunkable Live app.
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.

.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.

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:

Reset Your Google Sheets Connection

Hard Refresh Your Browser

As a first step, we recommend refreshing your browser. This can fix minor issues caused by old data being stored in the browser cache.
A "hard refresh," "force reload," or "force refresh" ensures that you are seeing and using the latest version of Thunkable and that any cached data that could be causing a connection issue is wiped clean and freshly retrieved.

Windows

On a Windows computer, the keyboard shortcut to hard refresh your browser is Ctrl + F5.

Mac

On a Mac computer, you can use the Option + Cmd + R shortcut to force your browser to refresh. If this does not work for you, try clearing your browser cache.

Reset Thunkable - Google Connection

If hard-refreshing doesn't work, you'll need to reset the connection. Start with the Reset from Thunkable instructions and then proceed to the Reset from Google instructions.

Reset from Thunkable

  1. 1.
    Login to your Thunkable account.
  2. 2.
    On your Projects Page, click Data Sources in the left sidebar.
  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.