--- title: "Data Destination - Google Sheets" slug: "data-destination-google-spreadsheets" updated: 2024-09-19T08:13:07Z published: 2024-09-19T08:13:07Z canonical: "documents.trocco.io/data-destination-google-spreadsheets" --- > ## Documentation Index > Fetch the complete documentation index at: https://documents.trocco.io/llms.txt > Use this file to discover all available pages before exploring further. # Data Destination - Google Sheets ## 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](/docs/connection-configuration-google-spreadsheets), 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. ![image.png](https://cdn.document360.io/3a3bae1e-f157-487f-8798-01e9d820e760/Images/Documentation/data-destination-google-spreadsheets-2024-08-29-3-45-0.png) | | 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](/docs/data-destination-google-spreadsheets#%E3%82%BB%E3%83%AB%E3%81%AE%E6%9B%B8%E5%BC%8F%E8%A8%AD%E5%AE%9A%E3%81%AB%E3%81%A4%E3%81%84%E3%81%A6) below. | | transfer mode | Yes | All cases washed out (sheet redone) | Select the transfer mode. For more information, see [About Transfer Mode](/docs/data-destination-google-spreadsheets#%E8%BB%A2%E9%80%81%E3%83%A2%E3%83%BC%E3%83%89%E3%81%AB%E3%81%A4%E3%81%84%E3%81%A6) 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"](/docs/data-destination-google-spreadsheets#%E8%A4%87%E5%90%88%E3%82%BD%E3%83%BC%E3%83%88%E3%81%AB%E3%81%A4%E3%81%84%E3%81%A6) below. | ## Specification details of setting items ### About Cell Formatting For more information, please refer to [the Sheets API documentation](https://developers.google.com/sheets/api/reference/rest/v4/ValueInputOption). | 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. - If **APPEND** is selected: the formatting of the existing sheet is applied. - If you choose " **All sheets are rewritten"** or " **Existing sheets are inherited"**: The default formatting of the spreadsheet will be applied. - Example 1) `0123` is output `as 123`. - Example 2) `2022-01-1` is output `as 2022-01-01`. | | `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. - Example 1) `0123` is output `as '0123'`. - Example 2) `2022-01-1` is output `as '2022-01-1`. | ### 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 |