--- title: "Google Sheets" slug: "google-sheets" description: "Automate data integration with Dataddo's Google Sheets Connector. Reliable and secure data sync. Learn how to create a Google Sheets as a data source." tags: ["Custom-schema connector", "How-to guide", "Data source"] updated: 2026-02-18T18:55:01Z published: 2026-02-18T18:55:01Z --- > ## 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 Sheets as a Source **Google Sheets** is a cloud-based spreadsheet software developed by Google. It provides a platform for creating, editing, and collaborating on spreadsheets in real-time, offering features for data analysis, visualization, and organization, and it can be accessed through a web browser or mobile app. ## Prerequisites: API Call Limitations Make sure your tables are formatted correctly to ensure proper **Attributes** selection in Dataddo. The first row of the table should contain the names of the values in each column in the following way: ![Google Sheets - first row example](https://cdn.document360.io/084ed225-3f99-4644-a2da-39ca0cd5ef45/Images/Documentation/Google%20Sheets%20-%20first%20row%20example.png) All limitations for API calls are described in [Google's official documentation](https://developers.google.com/sheets/api/limits). ## Authorize Connection to Google Sheets You can authorize your Google account using: - [OAuth 2.0](/docs/google-sheets#oauth-20): Use the Google Sheets authorizer. - [Using a service account](/docs/google-sheets#service-account-authorization): Use the a certificate with the Google Platform Service Account authorizer. ### OAuth 2.0 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). ### Service Account Authorization #### In Google Cloud Console To create **service account**, follow these steps: 1. In your Google Cloud Console, select your project. 2. Look up **Google Sheets API** using the search bar and **enable the API**. 3. In the top-left of the screen, open the **Navigation Menu**, hover over **IAM & Admin** to select **Service accounts**. 4. Click on three dots next service account and select **Manage keys**. 5. Click on **Add key** and select **Create new key**. 6. Choose **JSON** as key type. This will download the JSON file to your computer which you will later **need to upload to Dataddo**. #### In Your Google Sheet 1. First, open the downloaded JSON file in a text editor and copy the **client email value**. 2. In your Google Sheet, share the file with the copied email address. 3. Set the newly added email address as **Editor**. #### In Dataddo To authorize your service account, make sure you also have your **JSON** key. 1. On the [**Security**](https://app.dataddo.com/settings/security) page, navigate to the **Certificates** tab and click on **Add Certificate**. 2. Name your certificate, select **Google Service Account Key** as certificate type and upload the file you have obtained when **creating a Service Account for authorization**. 3. On the **Authorizers** tab, click on [**Authorize New Service**](https://app.dataddo.com/service/new) and select **Google BigQuery (Service account)**. 4. Select the newly added certificate. 5. Click on **Save**. ## How to Create a Google Sheets 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, choose your **account**. **Didn't find your account?** 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 **select your spreadsheet and sheet**. 4. Select your **metrics and attributes** 5. Configure your **snapshotting preferences**. Choose your [**sync frequency**](https://docs.dataddo.com/docs/extraction#extraction-frequency) or the exact synchronization time under **Show advanced settings**. 6. 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. 7. 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***. ## 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.