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, see https://www.google.com/sheets/about/.
You can create multiple Google Sheets connections.
During connection creation, you must provide access to Google Drive.
You can create connections to your Google Sheets instance from Designer Cloud Powered by Trifacta Enterprise Edition.
Limitations
Note
This connection type does not work when running jobs on a Hadoop-based cluster.
This is a read-only connection.
Single Sign-On (SSO) is not supported.
Custom domains are not supported.
This connection does not support previewing of your data in the source.
Enable
General relational connectivity must be enabled. For more information, see Relational Access.
This connection type utilizes OAuth 2.0 for authentication.
Note
NOTE: OAuth 2.0 authentication requires additional configuration specific to the connection type.
For more information, see Enable OAuth 2.0 Authentication.
Configure
To create this connection, select the Google Sheets card. For more information, see Connections Page.
Modify the following properties as needed:
Property | Description |
|---|---|
OAuth 2.0 Client | The OAuth 2.0 Client is displayed. Note When you create the connection in this window, you must click Authenticate, which authenticates to the app. This step is required. |
Connection Name | Display name of the connection. |
Connection Description | Description of the connection, which appears in the application. |
Use
You can import datasets from Google Sheets through the Import Data page. For more information, see Import Google Sheets Data.
Testing
Steps:
After you create your connection, import datasets from the connected Google Sheets. For more information, see Import Data Page.
Perform a few simple transformations to the data. Run the job. For more information, see Transformer Page.
Verify the results.