---
title: "Data Source - Google Drive"
slug: "data-source-googledrive"
updated: 2024-08-15T09:37:21Z
published: 2024-08-15T09:37:21Z
canonical: "documents.trocco.io/data-source-googledrive"
---

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

## summary

- Help Page for ETL Configuration of Data Setting [from Google Drive](https://drive.google.com/).
- Various files in a folder can be transferred.

## Target file format

- CSV/TSV
- JSON Lines
- JSONPath
- LTSV
- Microsoft Excel (xlsx or xls file)

## Setting items

### STEP1 Basic settings

| item name | indispensable | Custom Variable Use | Contents |
| --- | --- | --- | --- |
| Google Drive Connection Configuration | Yes | not allowed | Select your Google Drive Connection Configuration. Google Drive Connection Configuration can authenticate using OAuth authentication or a service account (JSON key). |
| folder ID | Yes | not allowed | Specify the ID of the folder. Files directly under the folder specified here will be transferred. Files in subfolders are not transferred. **How to get the folder ID:.** If the URL of the Google Drive folder is as follows, **0B68XXXXXXXX** is the folder ID. https://drive.google.com/drive/u/0/folders/**0B68XXXXXX** |
| filename regular expression | No | available | Files to be transferred can be specified by regular expressions. Example: The `^report_` (transfers a file whose filename starts with `report_` ) |
| Input file format | Yes | CSV/TSV | Specify the format of the input file. For more information, see [About input file format settings](/docs/configuration-of-input-files). |

## Restrictions

- Files that exist in the top hierarchy (no folders) cannot be transferred. Be sure to place the files you wish to transfer under the folder.
- **Incremental Data Transfer, which** transfers files excluding those already transferred, **is not supported**.