summary
Help page for ETL Configuration to Google Sheets.
Connection Configuration can be done through OAuth authentication or by using the Connection Configuration registered in your service account.
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. |
| Spreadsheet ID | Yes | - | Enter the ID of the Data Destination spreadsheet. The ID can be found in the URL when the spreadsheet is opened.  |
| Sheet name | Yes | - | Enter the sheet name for Data Destination. If the sheet does not exist, a new sheet is created. |
| time zone | Yes | Asia/Tokyo |
Selects in which time zone the timestamp type data will be output. * Since the timestamp type data on the spreadsheet does not include the time zone, it is necessary to select which time zone to output at the time of transfer. |
| cell formatting | Yes | USER_ENTERED(Apply cell formatting) |
Select whether to apply formatting to output cells. For more information, please refer to the section on cell formatting below. |
| transfer mode | Yes | All cases washed out (sheet redone) |
Select the transfer mode. For more information, see About Transfer Mode below. |
STEP1 detailed settings
Click on Advanced Settings to display the configuration items.
| item name | indispensable | default value | Contents |
|---|---|---|---|
| data sequence | No | - | Records can be sorted by sort key name and sort order. The sort key name must match the column name in the ETL Configuration STEP 2 Column Setting. For the behavior when multiple sort keys are specified, see "Compound Sorting" below. |
Specification details of setting items
About Cell Formatting
For more information, please refer to the Sheets API documentation.
| mode (musical mode, mode of probability distribution, state of physical system) | Details |
|---|---|
USER_ENTERED |
Spreadsheet formatting is automatically applied. The behavior depends on which transfer mode is selected.
|
RAW |
Values entered by the user are not parsed and are stored as is. At this time, an apostrophe may be added to the head of the data in the cell.
|
About transfer mode
| mode (musical mode, mode of probability distribution, state of physical system) | Details |
|---|---|
| All cases are rewritten (sheets are reworked) | Change the sheet ID (gid) and wash the data. At this time, the formatting (cell color and display format) on the existing sheet will be cleared. If an error occurs during transfer, the data on the existing sheet remains unchanged. |
| Postscript (APPEND) | Data is written in the form of additional data after the last row on the existing sheet. In this case, the formatting (cell color and display format) on the existing sheet is maintained. |
| All cases are rewritten (existing sheets are taken over) | The sheet ID (gid) is not changed and the data is washed out. At this time, the formatting (cell color and display format) on the existing sheet will be cleared. If an error occurs during transfer, the data on the existing sheet is deleted and the data up to the time of the error is transferred. |
About Compound Sort
If multiple sort keys are specified, the first sort key specified first takes precedence.
The following is an example of setting " foo (ascending order) as the first sort key and bar (ascending order) as the second sort key.
Data Source
foo |
bar |
|---|---|
| 10 | hoge |
| 10 | fuga |
| 1 | piyo |
Data Destination
foo |
bar |
|---|---|
| 1 | piyo |
| 10 | fuga |
| 10 | hoge |