---
title: "Google Drive as a Source"
slug: "google-drive-as-a-source"
description: "Centralize your data. Dataddo's no-code ETL platform connects securely to Google Drive, allowing you to load and manage data directly into any destination."
updated: 2025-10-07T16:51:05Z
published: 2025-10-07T16:51:05Z
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.dataddo.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Google Drive as a Source

**Google Drive** is a cloud-based file storage and synchronization service developed by Google that allows users to save files on their servers, making them accessible from any device. It facilitates real-time collaboration and sharing, and integrates with the Google Docs Editors suite (Docs, Sheets, Slides) for creating and editing documents online.

## Authorize Connection to Google Drive

To authorize this service, use **OAuth 2.0** to share specific data with Dataddo while keeping usernames, passwords, and other information private.

1. On the **Authorizers** page, click on [Authorize New Service](https://app.dataddo.com/service/new) and select your service.
2. Follow the on-screen prompts to grant Dataddo the necessary permissions to **access and retrieve** your data.
3. **[Optional]** Once your ***authorizer*** is created, click on it to **change the label** for easier identification.

Ensure that the account you're granting access to holds at least **admin-level permissions**. If necessary, assign a team member with the required permissions with the [authorizer role](https://docs.dataddo.com/docs/user-roles#authorizer) to authenticate the service for you.

For more information, see our article on [***authorizers***](https://docs.dataddo.com/docs/authorized-services).

## How to Create a Google Drive Data Source

1. On the **Sources** page, click on the [**Create Source**](https://app.dataddo.com/sources/new) button and select the connector from the list.
2. From the drop-down menu, select your ***authorizer***.
          **Didn't find your authorizer?**

          

Click on **Add new Account** at the bottom of the drop-down and follow the on-screen prompts. You can also go to the **Authorizers** tab and click on [**Add New Service**](https://app.dataddo.com/service/new).
3. **Name** your data source and fill in the following **optional** fields:
  1. **Drive ID**: For more information on how to obtain the Google Drive ID, see [Google Drive](/docs/google-drive).
  2. **Path**: Select your directory, folder or input the name manually, e.g. `/Documents/`.

### Configure Your File

In the **File setup** step:

1. **Name** your file. You can apply dynamic file naming using predefined patterns. For more details, see [Dynamic File Naming Patterns](/docs/dynamic-file-naming-patterns).
2. Select your **File Format**. We support the following formats: `JSON`, `CSV`, `XML`, `XLXS`, `PARQUET`.
3. [Optional] You can choose to **compress** your file.
4. If you selected the `CSV` or `XLSX` file format, you can also configure the following additional settings:

| CSV Settings | Description |
| --- | --- |
| CSV Delimiter | Specifies the character used to separate values in the file. You can select from the following delimiters: comma `,`, semicolon `;`, or tab `\t`, or pipe `\|`. |
| Comment | [Optional] Lines starting with this character will be treated as comments and ignored during processing (e.g., `#`). |
| CSV Lazy Quotes | If enabled, allows fields with mismatched or unescaped quote characters to be parsed without error. Useful for handling imperfect CSVs. |
| CSV Header | If enabled, the first row of the file will be treated as the header row (column names). Disable this if your file does not include headers. |

| XLSX Settings | Description |
| --- | --- |
| Sheet | [Optional] Specifies the name of the worksheet within the Excel file where the data should be written. |
| Sheet Range | [Optional] Defines the cell range where data should be placed (e.g., `A1:D100`). Leave blank to use the full sheet automatically. |
| Sheet Header | If enabled, the first row in the sheet will be treated as a header (column names). Disable if the sheet should contain raw data only. |

### Finish Your Source Configuration

1. In the **Transformation** step, if needed, you can:
  1. Set the **Transformation engine** to be **MongoDB** or **JQ**.
  2. Then, manually edit the [transformation pipeline](/docs/transformation-pipeline) to fine-tune how your data is processed before reaching the destination.
2. Configure your [**sync frequency**](https://docs.dataddo.com/docs/extraction#extraction-frequency) or set the exact synchronization time under **Show advanced settings**.
3. Preview your data by clicking on the **Test Data** button in the top right corner. You can **adjust the date range** for a more specific time frame.
4. Click on **Save** and **congratulations, your new data source is ready!**

---

## Troubleshooting

### Data Preview Unavailable

No data preview when you click on **Test Data** might be caused by an issue with your ***source*** configuration. The most common causes are:

- **Date range**: Try a smaller date range. You can load the rest of your data afterward using [manual data load](https://docs.dataddo.com/docs/data-backfilling).
- **Insufficient permissions**: Please make sure your authorized account has at least admin-level permissions.
- **Invalid metrics, attributes, or breakdowns**: You may not have any data for the selected metrics, attributes, or breakdowns.
- **Incompatible combination of metrics, attributes, or breakdowns**: Your selected combination cannot be queried together. Please refer to the service's documentation to view a full list of metrics that can be included in the same ***data source***.

### Can't Find File

**ERROR MESSAGE** `itemNotFound - The resource could not be found.`

This issue might be caused by the following:

- **Empty or improper file path**: Make sure the field with file path is filled in. To find the file path, in your OneDrive, identity your file, click on the three dots and select **Details**. Scroll down to **Path** and copy everything after "My files".
  - E.g. If your path shows "My files > Documents > example.json", provide `/Documents/` as the file path.
- **Partial file name**: Make sure to **include** the file extension in the file name to locate it, e.g. `example.json` and not just `example`.

## Related Articles

Now that you have successfully created a ***data source***, see how you can connect your data to a dashboarding app or a data storage.

**Sending Data to Dashboarding Apps**

- [Simple Data Integration to Dashboards](https://docs.dataddo.com/docs/simple-data-integration-to-dashboards)
- [Data Backfilling to Dashboarding Apps](https://docs.dataddo.com/docs/data-backfilling-to-dashboarding-apps)

**Sending Data to Data Storages**

- [Batch Ingestion to Data Warehouses](https://docs.dataddo.com/docs/ingestion-to-data-warehouses)
- [Data Backfilling to Storages](https://docs.dataddo.com/docs/data-backfilling-to-storages)

**Other Resources**

- [Troubleshooting](https://docs.dataddo.com/docs/troubleshooting)
- [Extraction Logs](https://docs.dataddo.com/docs/extraction-logs)
- [Data Duplication](https://docs.dataddo.com/docs/data-duplication)

Authorizers act as credentials for external services (e.g. Facebook or Google). To enable Dataddo to access and retrieve your data, you need to grant access to accounts that possess admin-level permissions or higher within these services.