Google Sheet Destination

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

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

Step 1 - How to create Google Sheets Data Destination

   
Number 1

Sign in to your Dataddo account and click on Destinations at the top of the page. Home Page - Destination

Number 2

Click on Create Destination in the top right corner.Data Destination - Create Destination

Number 3 From the list of destinations, choose Google Sheets. You can type the connector's name into the search bar to find it faster.
Google Sheets - step 3
Number 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 si-in page. Once signed in, continue with the steps in the Dataddo.

Step 2 - How to create Google Sheet Data Flow

   
Number 1

Sign in to your Dataddo account and click on Flows at the top of the page. Home Page - Data Flow

Number 2

Click on Create flow in the top right corner.My Flows - Create Flow

Number 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.
My Flows - New Flow
Number 4 Once you selected your data source, click on Add Destination.
Google Sheets- Flow 4
Number 5

 

From the list of destinations, under the tab Data Storages, select Google Sheets. You can also type the name of the source into the search bar.Google Sheets- Flow 5
Number 6 Configure the destination by filling out necessary fields, choose the name of the flow and click on Save flow.
Google Sheets- Flow 6a

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

Number 7

 

You can see what data will be sent to the destination, click on Preview.

NOTE: The preview is limited and not the entire table will be displayed.
Google Sheets- Flow 7

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 or create a ticket and we will help you set up the Data Source.