The integration for Google Sheets enables you to import the data from Google sheets.
Basic knowledge of Treasure Data
A Google account (for Google Drive).
Authorized Treasure Data account access
When you configure a data connection, you provide authentication to access the integration. In Treasure Data, you configure the authentication and then specify the source information.
Open TD Console.
Navigate to Integrations Hub > Catalog.
Search for and select Google Sheets.
The following dialog opens.
Authenticate the connection by selecting an existing OAuth connection or creating a new one.
Name your new Google Sheets connection.
Access to Treasure Data Google Sheets integration requires OAuth2 authentication. The authentication requires that users manually connect their Treasure Data account to their respective Google account.
If you don’t have an existing connection, create a new authentication.
After opening the authentication dialog, select the link under "OAuth connection" to create a new connection
Log into your Google Sheets account in the popup window and grant access to the Treasure Data app.
You are redirected back to integration dialog pane. Select Google Sheets and select the new connection from the drop down menu.
After creating the authenticated connection, you are automatically taken to Authentications.
Search for the connection you created.
Select New Source.
Type a name for your Source in the Data Transfer field.
Edit the following parameters
Specify the Google Spreadsheet key
Title of worksheet after importing to TD
Range to fetch
Range of fetch data from Google Spreadsheet
Use A1 notation without worksheet title (eg. A1:C100). If empty, ingest the whole sheet and number of columns is defined by the first row/column.
Use first row/column as header
Select if you want to keep the first row or column as a header.
Skip first rows/columns
Skip n top rows when using Rows dimension or n left columns when using Column dimension
Choose Rows or Columns
Value Render Option
Formatted value or Unformatted value
Date Time Render Option
Formatted String or Serial Number
Ignored if using Formatted Value in Value Render
The Data Settings page opens.
Optionally, edit the data settings or skip this page of the dialog.