--- 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." tags: ["Database as a source", "Data source", "How-to guide"] updated: 2025-10-07T16:51:05Z published: 2025-10-07T16:51:05Z canonical: "docs.dataddo.com/google-drive-as-a-source" --- > ## 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.