Your guide to Google Sheets

This guide contains detailed information about collecting data from Google Sheets.

Introduction

This guide contains detailed information about using Google Sheets in Adverity.

To create a datastream to collect data from Google Sheets, follow the steps in our guide to Collecting data in Adverity. If these steps are not detailed enough, refer back to this Google Sheets guide for detailed configuration instructions.

Creating a datastream to collect data from Google Sheets

This section of the Google Sheets guide contains information specific to Google Sheets. Not all steps in the datastream creation process will be described here. If a step is not described here, follow the process in our guide to Collecting data in Adverity.

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.

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.

• Store your data in Adverity Data Storage for further analysis in Adverity.

• Transform your data to meet your needs by creating and applying enrichments to your datastream.

Advanced Google Sheets tips

Fetching multiple sheets

To fetch multiple sheets from your Google Sheets data source, follow these steps:

1. Select the workspace you work with in Adverity and then, in the platform navigation menu, click Datastreams.

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 Enrichments section, click + Assign enrichment.

8. Click Create new enrichment.

9. Click Custom Script.

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

11. Click Next and then click Create +.

12. Fetch data for the datastream.