Syncing with Google Sheets

This tutorial will walk through how to sync a data source with Google Sheet.


Syncing to the latest batch

Step 1: Obtain your data source unique ID

The DATA SOURCE UNIQUE ID is the unique identifier of the data source on the platform. It could be found on the Settings Tab of your data source page (see illustration below).

Step 2: Insert Formula

Proceed to your Google Drive account and open a Google sheet document. Insert the formula of the following format into a cell

=importdata("https://cache.getdata.io/{{DATA_SOURCE_UNIQUE_ID}}}/latest_all.csv")

Step 3: Complete

Once the formula is insert into the cell you should see the latest batch of data being displayed within the cells. (see illustration below)

Your data in your Google Sheet gets automatically refreshed everytime a new batch of data becomes available.


Syncing to a specific batch

Step 1: Retrieve data batch

You can indicate the batch of data you want on the Data Set Preview Tab

Step 2: Fetch data batch URL

Obtain the URL to the data in the format you want

Step 3: Insert Formula

Proceed to your Google Drive account and open a Google sheet document. Insert the formula of the following format into a cell

=importdata("https://cache.getdata.io/{{DATA_SOURCE_UNIQUE_ID}}}/{{BATCH_TIME_STAMP}}_all.csv")'

Step 4: Complete

Once the formula is insert into the cell you should see the latest batch of data being displayed within the cells. (see illustration below)


More resources

To find out more about how GetData.IO works