Add a Google Sheets database connection

You can add a connection to Google Sheets and use it as a database in ThoughtSpot DataFlow.

Follow these steps:

  1. Click Connections in the top navigation bar.

  2. In the Connections interface, click Add connection in the top right corner.

  3. In the Create Connection interface, select the Connection type.

  4. After you select the Google Sheets Connection type, the rest of the connection properties appear.

    See Connection properties for details, defaults, and examples.

    Connection name

    Name your connection.

    Connection type

    Choose the Google Sheets connection type.

    Obtain access token

    Select this option to use access key/token to connect to the Google Sheets web-service.

    Access token

    Specify the access token to authenticate Google Sheets.

    Refresh token

    Specify the refresh token to authenticate Google Sheets.

    OAuth client ID

    Specify the OAuth client ID.

    OAuth client secret

    Specify the OAuth client secret.

    Callback URL

    Secured domain URL of the repo used to register in Google Sheets.

    Scope

    Specify the number of users to access the account.

    JDBC options

    Specify the options associated with the JDBC URL.

  5. Click Create connection.