Page tree

Release 9.2


Our documentation site is moving!

For up-to-date documentation of release 9.2 of Self Managed Designer Cloud, please visit us at



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 
  • 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 Enterprise Edition


NOTE: This connection type is not supported for integration with a Hadoop-based running environment.

  • 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 does not support previewing of your data in the source.

  • If you have enabled Google Advanced Protection, this connection type does not work.



To create this connection, select the Google Sheets  card. For more information, see Connections Page.

Modify the following properties as needed:

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 NameDisplay name of the connection.
Connection DescriptionDescription of the connection, which appears in the application.


You can import datasets from Google Sheets through the Import Data page. For more information, see Import Google Sheets Data.



  1. After you create your connection, import datasets from the connected Google Sheets. For more information, see Import Data Page
  2. Perform a few simple transformations to the data. Run the job. For more information, see Transformer Page.
  3. Verify the results.

See Also for Google Sheets Connections:

This page has no comments.