Overview of Integration Connectors with AppSheet

Google Cloud Integration Connectors let you expose your enterprise data in different applications and integrations, including AppSheet. The connections you create in Google Cloud can be used as data sources in AppSheet. 

Learn how to use Integration Connectors with AppSheet as described in the following sections:

• Supported Integration Connectors
• Get started
• Use Integration Connectors with AppSheet
• Limitations when using Integration Connectors with AppSheet

Supported Integration Connectors

You can add connections as data sources in AppSheet using the following Integration Connectors.

Connectors for Google Services
AlloyDB	BigQuery	Bigtable
Cloud Spanner	Cloud SQL - MySQL	Cloud SQL - PostgreSQL
Cloud SQL - SQL Server
Connectors for other applications
Acumatica	Airtable	Amazon S3
Asana	Azure DevOps	Azure Synapse
CockroachDB	Dynamic 365	EnterpriseDB
Freshbooks	HubSpot	IBM Db2
Jira Cloud	Jira Server (Data Center)	Jira Service Management
MariaDB	Monday	MySQL
Neo4j	NetSuite	Oracle DB v2
Oracle Sales Cloud	PostgreSQL	Redshift
Sage Intacct	Salesforce	SAP ERP
SAP ASE (Sybase)	SAP Hybris C4C	ServiceNow
SingleStore	Snowflake	SQL Server
Streak	Trello	Workday
Xero	Zendesk	Custom connectors

Get started

Watch a quick tour of using Integration Connectors with AppSheet.

Quick tour: Integration Connectors with AppSheet

Use Integration Connectors with AppSheet

To use Integration Connectors with AppSheet, do the following steps:

Step	Description	Completed by
1	Set up Integration Connectors with AppSheet	AppSheet team admin & Google Cloud admin
2	Add a connection as a data source	AppSheet team admin
3	Use the connection as a data source in an app	AppSheet team member

Limitations when using Integration Connectors with AppSheet 

Consider the following limitations when using Integration Connectors with AppSheet:

• Review the known limitations for Integration Connectors.
• Connections with authentication override enabled are not supported at this time. 
• If a column in a connected data source isn't explicitly set to be editable, AppSheet considers the column to be read-only.
• There are complex types in Google BigQuery that aren't supported by AppSheet, including Array, Bytes, Geography, and Struct. These types are displayed as String.