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.

    Access token

    Specify the access token to authenticate Google Sheets.

    Refresh token

    Specify the refresh token to authenticate Google Sheets.

    Obtain access token

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

    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

  5. Click Create connection.