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.
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.
-
(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 Adverity Data Storage to send it to BI tools using data shares
-
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:
-
Select the workspace you work with in Adverity and then, in the , click Datastreams.
-
In the , click Settings.
-
In the advanced settings, in the Export type, select
Excel. -
Click Save.
-
In the , click Overview.
-
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 +.