Google Sheets as a Destination
  • 2 Minutes to read
  • Dark
    Light

Google Sheets as a Destination

  • Dark
    Light

Article Summary

Getting your data to a Google Sheets is an easy task with Dataddo. If you already have your Google account connected to Dataddo, start from Step 2 - How to Create Google Sheet Data Flow right away.

Limitations

Number of cells

When sending your data to Google Sheets, be aware that Google Sheets have a limit of approximately 10 million cells.

Changing Columns or Their Order

The following actions after your flow has been created, may lead to your flow breaking:

  • Reordering columns
  • Changing column names
  • Add columns
  • Delete columns

Changing column names may be done by going to your source and clicking on the three dots. Next, navigate to the Data Types tab to rename your columns.

All actions can be executed by copying the source with JSON connector, and then editting the labels using advanced settings of the source.

Step 1 - How to Create Google Sheets Data Destination

  1. After you sign in to your Dataddo account, go to the Destinations page and click on Create Destination in the top right corner.

  2. From the list of destinations, choose Google Sheets.
    Data destinations - selection

  3. Select the account associated with your Sheets, and name the destination. Click on Save.
    Google Sheets- step 4

NOTE:

If you have not authorized your Google Account, click on Authorize. You will be redirected to the sign-in page.

Step 2 - How to Create Google Sheet Data Flow

  1. Go to the Flows page and click on Create Flow in the top right corner.

  2. Click on Connect Your Data to add your data source.

  3. Click on Connect Your Data Destination and select your Google Sheets destination.
    Google Sheets- Flow 5

  4. Configure the destination by filling out necessary fields and rename if necessary.
    Google Sheets- Flow 6a

NOTE

Do not forget to set the synchronization time of your flow with a little delay after the synchronization of your source to allow the data to properly load.

  1. Check if your configuration is correct by taking a look at the Data Preview tab and click on Create Flow to save.
    Flow - preview

Troubleshooting

How to Configure Google Sheets Data Flow

All set, no further action is needed in order to configure the flow. The data will be regularly loaded into your Google Sheets.

Where to Find the New Google Sheets Data

To navigate to your newly created Google Sheets, go to flows 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.

Flow Action Logs Error Messages

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

  • Your Google Sheets limit has been reached. Please select another Sheet as a destination.

Need assistance?

Feel free to contact us and we will help you with the setup. To speed the process of resolving your issue, make sure you provide us with sufficient information.


Was this article helpful?

What's Next