Collecting data from Google Sheets
This guide explains how to collect data from Google Sheets. To learn how to collect data from a different data source, go back to the Available data sources in Adverity overview.
Limitations
Collecting data from Google Sheets comes with the following limitations:
-
You can only collect data from one sheet in your spreadsheet. The sheet is defined by the URL you enter in the configuration step.
Creating a datastream to collect data from Google Sheets
The basics of creating a datastream to collect data from any data source are explained in our guide to Creating a datastream. This guide contains information about the specific steps to create a datastream to fetch data from Google Sheets.
Configuration: Choose the data you want to collect from Google Sheets
To choose what data to collect and customize the Google Sheets datastream configuration, follow these steps:
-
(Optional) Rename your datastream.
-
In Spreadsheet link, enter the URL of the Google Sheets spreadsheet. This URL includes the gid of the sheet that will be collected from the spreadsheet.
-
(Optional) In Export type, select the data format you want Adverity to use in the data extract.
-
(Optional) To name the data extract the same as the Google Sheets spreadsheet, select the Keep filename checkbox.
What's next?
-
Apply Data Mapping to your collected data to harmonize data collected from different sources in Adverity.
-
Transform your data to meet your needs by creating and applying enrichments to your datastream.
-
Load your data into Explore & Present to visualize your data in Adverity
-
Load your data into an external destination of your choice
Advanced Google Sheets tips
Fetching multiple sheets
To fetch multiple sheets from your Google Sheets data source, follow these steps:
-
Go to the Datastreams page.
-
In the Settings.
, click -
In the advanced settings, in the Export type, select
Excel
. -
Click Save.
-
In the Overview.
, click
-
In the Enrichments section, click + Assign enrichment.
-
Click Create new enrichment.
-
Click Custom Script.
-
Select the xlsx enrichment. For more information on the enrichment configuration, see xlsx.
-
Click Next and then click Create +.