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:

1. (Optional) Rename your datastream.

2. 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.

3. (Optional) In Export type, select the data format you want Adverity to use in the data extract.

4. (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 transformations 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:

1. Go to the Datastreams page.

2. Open the Google Sheets datastream by clicking on its name.

3. In the top navigation panel, click Settings.

4. In the advanced settings, in the Export type, select Excel.

5. Click Save.

6. In the top navigation panel, click Overview.

7. In the Transformations section, click + Assign transformation.

8. Click Create new transformation.

9. Click Custom Script.

10. Select the xlsx transformation. For more information on the transformation configuration, see xlsx.

11. Click Next and then click Create +.

12. Fetch data for the datastream.