Skip to main content

Google Sheets Connections

Google Sheets provides a spreadsheet interface for cloud-based data stored in Google Drive. It allows multiple users to edit and format files in real-time. For more information, go to https://www.google.com/sheets/about/.

You can create connections to your Google Sheets instance from the Alteryx Analytics Cloud. Use this connection to search for your Google Sheets by keyword on the Library for Data Page.

Limitations

  • This is a read-only connection.

  • Single Sign-On (SSO) is not supported.

  • Custom domains are not supported.

  • Since data must be converted to a native file format, this connection doesn't support previewing of your data in the source.

  • If you have enabled Google Advanced Protection, this connection doesn't work.

Configure

To create this connection, go to the Connections page and then select Create a Connection. Search for and then select the Google Sheets card. For more information, go to Connections Page.

Modify these properties as needed:

Property

Description

Connection Name

Display name of the connection.

Connection Description

Description of the connection, which appears in the application.

OAuth 2.0 Client

The OAuth 2.0 Client automatically displays. To authenticate your connection, select Sign in with Google and follow the on-screen instructions.

In this section: