Data Source - Google Sheets

constraints

Restrictions on cell display format

In Data Source Google Sheets, values are transferred with Display Format > Number applied.
Therefore, the display format > numbers for the values in each column should all be aligned.
Preview and transfer may fail if a row exists with a different Display Format > Number.

Setting items

STEP1 Basic settings

item name	indispensable	default value	Contents
Google Sheets Connection Configuration	Yes	-	From the previously registered Connection Configuration of Google Sheets, select the one that has the necessary permissions for this ETL Configuration.
Sheet URL	Yes	-	Enter the URL of the spreadsheet you wish to retrieve in the following format (include `/edit#gid=0 at` the end) `https://docs.google.com/spreadsheets/d/xxxxxx/edit#gid=0`
Sheet name	Yes	-	Enter the name of the sheet you wish to retrieve. For example, when creating a spreadsheet, the default sheet name is "Sheet 1".
start-of-retrieval line number	Yes	2	Enter the first line number of the data to be imported. If there is a header row, enter the line number of the first data line, excluding the header row.
start-of-retrieval column number	Yes	`A`	Enter the first column number of the data to be imported. Please enter in uppercase alphabetical characters.
Default time zone	Yes	-	Enter which time zone is to be interpreted with respect to the timestamps on the sheet. Since the `timestamp` type data on the spreadsheet does not include the time zone, it is necessary to select which time zone to retrieve at the time of transfer. e.g.) For Tokyo: `Asia/Tokyo`, For UTC: `UTC`
null string	No	-	Enter a string that you want to be recognized as `NULL`. If not entered, an empty character is recognized as `NULL`.
Column Setting	Yes	-	Specify the column name, data type, and date/time format of the column to be retrieved. By clicking on Extract Column Information, you can also extract column names, data types, and date/time formats in a batch. The data type is selected from the following. `string` `long` `timestamp` `double` `boolean` `json` If `timestamp` type is selected as the data type, specify the date and time format.

item name

indispensable

default value

Contents

Google Sheets Connection Configuration

Yes

From the previously registered Connection Configuration of Google Sheets, select the one that has the necessary permissions for this ETL Configuration.

Sheet URL

Yes

Enter the URL of the spreadsheet you wish to retrieve in the following format (include /edit#gid=0 at the end)
https://docs.google.com/spreadsheets/d/xxxxxx/edit#gid=0

Sheet name

Yes

Enter the name of the sheet you wish to retrieve.
For example, when creating a spreadsheet, the default sheet name is "Sheet 1".

start-of-retrieval line number

Yes

Enter the first line number of the data to be imported.
If there is a header row, enter the line number of the first data line, excluding the header row.

start-of-retrieval column number

Yes

A

Enter the first column number of the data to be imported. Please enter in uppercase alphabetical characters.

Default time zone

Yes

Enter which time zone is to be interpreted with respect to the timestamps on the sheet.
Since the timestamp type data on the spreadsheet does not include the time zone, it is necessary to select which time zone to retrieve at the time of transfer.
e.g.) For Tokyo: Asia/Tokyo, For UTC: UTC

null string

Enter a string that you want to be recognized as NULL.
If not entered, an empty character is recognized as NULL.

Column Setting

Yes

Specify the column name, data type, and date/time format of the column to be retrieved.
By clicking on Extract Column Information, you can also extract column names, data types, and date/time formats in a batch.
The data type is selected from the following.

string

long

timestamp

double

boolean

json
If timestamp type is selected as the data type, specify the date and time format.

Data Source - Google Sheets

summary

constraints

Setting items

STEP1 Basic settings

What's Next