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. In addition, you can add other data sources.
All data sources in your account are available when you add tables to your AppSheet app. The same app can combine tables from multiple data sources.
Manage data sources as described in the following sections.
- Summary of data source types
- View data sources
- Add a data source
- 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, and other data or provider services.
| Native | Spreadsheets | Databases | Other data or provider services |
| AppSheet databases |
|
- When using a Google Forms data source in your app, a read-only table is added.
- At this time, a Gmail data source can only be used within the context of an automation. Gmail events are tableless. When you connect a Gmail account to your AppSheet app when adding a Gmail event to an automation, it is added as a data source but no table is added to your app. For more information, see Build an automation using Gmail.
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
You don't need to add AppSheet databases to your account. They are native to AppSheet and once created, they are available to your apps by default.
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.
To add a data source, do the following:
- 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.
- Enter the data source name in the text field and click the type of data source that you want to add.
- Follow the prompts to authenticate your new data source.
- Optionally, you can share the data source with your team.
Copy an app table to a new data source
To copy an app table to a new data source:
- Open in the app editor the app containing the table that you want to copy.
- Go to Data
.
- Select the table in the list.
- Click Table settings
in the table header.
- Expand the Storage section.
- Click Copy Data to New Source adjacent to the Data Source field.
- 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. - Enable the Include file data option, if required.
- Click Copy data.
A message displays indicating whether or not the data was copied successfully. - Click Close.
Delete a data source
You can delete a data source that you own.
- Before you delete a data source, be sure to remove any related tables from existing apps. Otherwise, the apps may no longer execute as expected.
- If the data source is shared with your team, it will no longer be accessible to other members of your team after you delete it.
To delete a data source:
- Go to the My account > Sources.
You can view all of the data sources that are currently available for your use. - Locate the data source you want to delete.
- Select
More > Delete.