Use multiple data sources

Your AppSheet apps can access data from multiple data sources. Your AppSheet account always has a primary data source used for account authentication (commonly Google Drive) and spreadsheets from that account can be used in your apps. However, you can add other data sources.

All data sources in your account are available when you add tables to your AppSheet app. In fact, the same app can combine tables from multiple data sources.

Summary of data source types

The following table summarizes the data source types that can be used with AppSheet in three categories: spreadsheets, databases, and other data or provider services

Spreadsheets Databases Other data or provider services

Add data sources

Add data sources to your account using one of the following methods:

You can also add a data source when creating an app using a Google Workspace add-on, such as Google Sheets AppSheet add-on or  Google Forms AppSheet add-on.

Add a data source from the My Account page

To add a new data source from the My Account page:

  1. Go to the My account > Sources.
    You can view all of the data sources that are currently available for your use.
  2. Click + New Data Source.

    Sources tab on My Account page current data sources and New Data Source buton
  3. Enter the data source name and click the type of data source that you want to add.
  4. Follow the prompts to authenticate your new data source. 

Add a new data source when creating a new app

To add a new data source when creating a new app:

  1. Go the the My Apps page.
  2. Click + Make a new app.
  3. Click Start with your own data.
  4. Enter the App name and select a Category.
  5. Click Choose your data.
  6. Click + Add data source
  7. Enter the data source name and click the type of data source that you want to add.
  8. Follow the prompts to authenticate your new data source. 
Was this helpful?
How can we improve it?
Search
Clear search
Close search
Google apps
Main menu
Search Help Center
false
false