Google Sheet Destination
  • 2 Minutes to read
  • Dark
    Light

Google Sheet Destination

  • Dark
    Light

Getting your data to a Google Sheet is an easy task with Dataddo. If you already have your Sheets account connected to Dataddo, and you only need instructions on how to connect it to a Data Flow, you can skip Step 1 and start from Step 2 right away.

Limitation

Number of cells

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

Change of order or names of columns

If you reorder the columns, change their names, add or delete some, it will lead to flow breakage. You can change the order or names by copying the source with JSON connector and then edit the labels using advanced settings of the source.

Read more about JSON connector here.

Step 1 - How to Create Google Sheets Data Destination

  1. Sign in to your Dataddo account and click on Destinations at the top of the page.

  2. Click on Create Destination in the top right corner.

  3. From the list of destinations, choose XX. You can type the name of the connector into the search bar to find it faster.
    Data destinations - selection

  4. Select the Google Sheets account and the name of 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. Once signed in, continue with the steps in the Dataddo.

Step 2 - How to Create Google Sheet Data Flow

  1. Click on Flows at the top of the page.

  2. Click on Create Flow in the top right corner.

  3. Click on Add Source to connect it to the destination. You can type the connector's name into the search bar to find it faster.

  4. Once you select your data source, click on Add Destination.

  5. From the list of destinations, select the destination. You can also type the name into the search bar.
    Google Sheets- Flow 5

  6. Configure the destination by filling out necessary fields.
    Google Sheets- Flow 6a

    NOTE: Remember to set the synchronization time for the flow with a little delay after the synchronization of your source to let the data load.

  7. You can Name your flow by typing the name into the top.

  8. You can see a Data Preview to make sure of your configuration.
    Flow - preview

  9. Click on Save flow.

How to Configure Google Sheets Data Flow

All set, no further action is needed to configure the flow. The data will be regularly outputted to Google Sheets.

Where to Find the New Google Sheets Data Flow

If you want to see the location of the sheet, click on the three dots next to the flow, go to Configure and you will find the sheet's link there.


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?