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
• Add data sources
• Copy an app table to a new data source

Summary of data source types

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

Native	Spreadsheets	Databases	Other data or provider services
AppSheet databases	Google Sheets Microsoft Excel (Office 365 and SharePoint)	AWS DynamoDB Google BigQuery MariaDB MySQL On-premises database Oracle PostgreSQL SQL Server	Airtable Apigee Box Dropbox Google Calendar Google Drive Google Forms Looker Studio OData Salesforce Smartsheet

Add data sources

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

• Add a data source from the My Account page
• Add a data source when creating a new app

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

Note: You don't need to add AppSheet databases to your account. They are native to AppSheet and available by default.

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.
   
   
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 + Create > App > Start with existing data.
3. Enter the App name and select a Category.
4. Click Choose your data.
5. Click + New source. 
6. Enter the data source name in the text field and click the type of data source that you want to add.
7. Follow the prompts to authenticate your new data source. 

Copy an app table to a new data source

To copy an app table  to a new data source:

1. Open in the app editor the app containing the table that you want to copy.
2. Go to Data > Tables.
3. Expand the table that you want to copy. 
4. Click Copy Data to New Source adjacent to the Data Source field.
5. Select a data source from the list of available data sources.
   The data source type must be compatible with the data being saved; otherwise, an error is returned.
6. Enable the Include file data option, if required.
7. Click Copy data.
   A message displays indicating whether or not the data was copied successfully.
8. Click Close.