summary
Help Page for ETL Configuration of Data Setting from 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. stringlongtimestampdoublebooleanjsonIf timestamp type is selected as the data type, specify the date and time format. |