---
title: "Data Source - Google Sheets"
slug: "data-source-google-spreadsheets"
updated: 2024-08-15T09:37:19Z
published: 2024-08-15T09:37:19Z
canonical: "documents.trocco.io/data-source-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 Source - Google Sheets

## summary

Help Page for ETL Configuration of Data Setting from Google Sheets.

## constraints

              Restrictions on cell display format

              

In [Data](https://support.google.com/docs/answer/56470) Source Google Sheets, values are transferred with [Display Format > Number](https://support.google.com/docs/answer/56470) applied. Therefore, the [display format > numbers for](https://support.google.com/docs/answer/56470) the values in each column should all be aligned. Preview and transfer may fail if a row exists with a different [Display Format > Number](https://support.google.com/docs/answer/56470).

## 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. |
| 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. |