--- title: "How to Connect Google Sheets as a Destination" slug: "google-sheets-destination" description: "Connect your data to Google Sheets with Dataddo in minutes and easily transfer data with no limitations. Learn how to securely create a Google Sheets data flow." updated: 2025-08-06T20:14:17Z published: 2025-08-06T20:14:17Z --- > ## 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 Destination **Google Sheets** is a cloud-based spreadsheet software offered as part of Google Workspace (formerly G Suite). It allows users to create, edit, and collaborate on spreadsheets in real-time, offering a wide range of features for data organization, analysis, and visualization. | Use Case | Solution | | --- | --- | | More than 10M cells (384,615 rows with 26 columns labeled A-Z) | 10M cells is Google Sheets' cell limit. If your data volume reaches 10M cells or more, consider using a data warehouse like [Google BigQuery](/docs/google-bigquery). For more information, see [Troubleshooting](/docs/google-sheets-destination#failed-to-write-userentered-data-error). | ## Authorize Connection to Google Sheets 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. ## Create a New Google Sheets Data Destination 1. On the **Destinations** page, click on the [**Create Destination**](https://app.dataddo.com/destinations) button and select the destination from the list. 2. Select your ***authorizer*** from the drop-down menu. 3. Name your ***destination*** and click on **Save**. Need to authorize another connection? Click on **Add new Account** in drop-down menu during ***authorizer*** selection 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). ## Create a Flow to Google Sheets 1. Navigate to **Flows** and click on [**Create Flow**](https://app.dataddo.com/flow/new). 2. Click on **Connect Your Data** to add your ***source(s)***. 3. Click on **Connect Your Data Destination** to add the ***destination***. 4. Choose the [write mode](https://docs.dataddo.com/docs/data-storages#write-modes) and fill in the other required information. 5. Check the **Data Preview** to see if your configuration is correct. 6. **Name** your flow and click on **Create Flow** to finish the setup. --- ## Limitations ### Number of cells When sending your data to Google Sheets, be aware that Google Sheets have **a limit of approximately 10 million cells**. ### Columns Changes If you do one of the following actions after you already saved your flow, it can **break your flow**: - Change the columns order - Change the column names - Add columns - Delete columns All actions can be executed by copying the source with [JSON connector](/docs/json-universal-connector), and then editting the labels using advanced settings of the source. ## Troubleshooting ### Extra Apostrophe in Data Data in Google Sheets may show an apostrophe in the beginning (e.g., `'012345`), which indicates that the value should be treated as a **string** and not a number. The apostrophe is mainly a Google Sheets UI feature and** your data has been written correctly without the apostrophe**. This feature in Google Sheets is useful for e.g., IDs which start with one or more 0s as when they are in the beginning, they get (for example, `'0092848` is saved as `'92848`). ### Can’t Find the Location of Specific Google Sheet To navigate to your newly created Google Sheets, go to the [Flows](https://app.dataddo.com/flows) tab and click on the electric plug icon next to your flow for configuration details. Click on the blue button on the pop-up to get redirected to your Google Sheets. ### Large Numbers Are Cut or Rounded This issue arises because Google Sheets has a limitation on storing extremely large numbers. In most cases, it's improbable that you genuinely require the value to be stored as a numerical entity (unless you're calculating, for example, the number of atoms in the solar system). More often than not, the number you are trying to store serves as an identifier (e.g., a Facebook Post ID). Therefore, you can safely convert it to a string to prevent rounding. To address this, you can [adjust the schema](/docs/schema#changing-data-types) of the connected source, changing the data type of the specific column from integer to string. ### Failed to Write USER_ENTERED Data Error ``` Stream transfer: write data from stream: writing to sheet: Failed to write data to sheet by columns: Failed to write "USER_ENTERED" data batch to sheet: googleapi: Error 400: Invalid data[0]: This action would increase the number of cells in the workbook above the limit of 10000000 cells., badRequest ``` This issue is caused by **reaching Google Sheets limit**, which is 10M cells. Please use one of the following solutions: - Reduce the amount of extracted data. You can do this by adjusting the shortening the timeframe of the [extraction](/docs/extraction). - If you are using SmartCache with **append** configuration, consider using **replace** configuration instead. For more information, see article on [snapshot keeping policy](https://docs.dataddo.com/docs/extraction#snapshot-keeping-policy). - Consider using a cloud data warehouse as destination (e.g. [BigQuery](/docs/google-bigquery), [Snowflake](/docs/snowflake) or [Redshift](/docs/redshift)) instead of Google Sheets. ## Related Articles - [Data Backfilling to Storages](https://docs.dataddo.com/docs/data-backfilling-to-storages) - [Write Modes](https://docs.dataddo.com/docs/data-storages#write-modes) - [Implementation of Batch Ingestion to Data Warehouses](https://docs.dataddo.com/docs/ingestion-to-data-warehouses) - [Network Access Control List (ACL) Configuration](https://docs.dataddo.com/docs/network-acl) - [SSH Tunnelling](https://docs.dataddo.com/docs/ssh-tunnelling) - [Data Transformations](https://docs.dataddo.com/docs/data-transformations) - [Data Quality Firewall](https://docs.dataddo.com/docs/data-quality-firewall)