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. |