Overview of Integration Connectors with AppSheet

This is a preview release of Integration Connectors with AppSheet. See Track and manage feature releases. Preview offerings are intended for use in test environments only. This feature is not recommended for use in production apps. For questions or assistance with this feature, contact AppSheet Support.

Integration Connectors with AppSheet (preview) requires an AppSheet Enterprise Plus account.

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 other applications
Connectors for Google Services
AlloyDB	BigQuery	Cloud Spanner
Cloud SQL - MySQL	Cloud SQL - PostgreSQL	Cloud SQL - SQL Server
Asana	Azure Synapse	CockroachDB
EnterpriseDB	HubSpot	IBM Db2
Jira Cloud	Jira Server (Data Center)	Jira Service Management
MariaDB	Monday	MySQL
Oracle DB v2	Oracle Sales Cloud	PostgreSQL
Redshift	Salesforce	SAP ASE (Sybase)
SAP Hybris C4C	ServiceNow	SingleStore
Snowflake	SQL Server	Streak
Trello	Zendesk	Custom connectors

You will need an Application Integration plan to create connections in Google Cloud. Connection and data processing charges may apply. See Application Integration pricing and the Google Cloud Integration Connectors with AppSheet FAQ.

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.

Was this helpful?

How can we improve it?