Manage 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. In addition, you can add other data sources. All data sources in your account are available when you create or add tables to your AppSheet app.

Manage data sources as described in the following sections.

• Summary of data source types
• View data sources
• Add a data source
• Use a data source in your app
• Copy an app table to a new data source
• Delete a data source

Summary of data source types

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

Native	Spreadsheets	Databases	Other data or provider services	Connections using Integration Connectors (preview)
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* Gmail** Looker Studio OData Salesforce Smartsheet	Google BigQuery Jira Cloud Salesforce ServiceNow For details, see Use Google Cloud Integration Connectors with AppSheet.

View data sources

To view data sources, go to the My account > Sources.

The data sources that are currently available for your use are shown, including:

• Account data sources added by you. See Add data sources (below).
• Team data sources added by team members. See Share data sources with your team.

Add a data source

To add a data source, do the following:

1. Do one of the following:
   • To add a data source to your account, go to the My account > Sources and click + New Data Source.
   • To add a data source when creating an app, go to the My Apps page, select + Create > App > Start with existing data, and select + New source when choosing your data.
     Note: This method is not applicable to Gmail data sources.
   • To add a data source to an existing app, open the app in the editor, go to Data, click +, and click + New source.
   The Add data source wizard displays.
2. Choose one of the following options:
   • Use AppSheet - To add a data source using AppSheet. Proceed to step 3.
   • Use Integration Connectors - To add an Integration Connector as a data source. Go to Set up Integration Connectors and Add and use connections as data sources.
     Note: The Use Integration Connectors option is only available to AppSheet team admins.
3. Click the type of data source that you want to add.
4. Follow the prompts to name and authenticate your new data source. 
5. Optionally, you can share the data source with your team.

Use a data source in your app

Use a data source in your app when you create an app from existing data or add a table to an existing app. The same app can add tables from multiple data sources.

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  .
3. Select the table in the list.
4. Click Table settings  in the table header.
5. Expand the Storage section.
6. Click Copy Data to New Source adjacent to the Data Source field.
7. 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.
8. Enable the Include file data option, if required.
9. Click Copy data.
   A message displays indicating whether or not the data was copied successfully.
10. Click Close.

Delete a data source 

You can delete a data source that you own.

To delete a data source: 

1. Go to the My account > Sources.
   You can view all of the data sources that are currently available for your use.
2. Locate the data source you want to delete.
3. Select  More > Delete.