Collecting data from Google Sheets

Follow this guide to collect data from Google Sheets and preview the data.

Understanding datastreams and authorizations

When you connect to Google Sheets through Adverity, you authorize Adverity to access your account. Adverity stores this authorization information in an authorization, and stores the data collection configuration in a datastream.

You can create several datastreams using the same authorization. The datastreams collect information from the same source, with the same login credentials, with different configurations.

Creating a datastream using Google Sheets

Connecting to Google Sheets

To connect to Google Sheets, follow these steps:

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

  2. In the top right corner, click + Create datastream.

  3. Search for and click Google Sheets.

  4. Choose one of the following options:

    • Click Setup a new authorization and set up the new authorization with your own login credentials.

    • Click Send an access request to ask someone else to set up the new authorization. In the Email field, enter the email address of the person you want to ask to authorize the new authorization.

    • If you already have an authorization to Google Sheets, choose an existing authorization.

  1. Click Next.

Choosing what data to collect

To choose what data to collect and customize the Google Sheets datastream configuration, follow these steps:

  1. Click Custom configuration.

  1. Click Next.

  1. (Optional) Rename your datastream.

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

  2. (Optional) To name the data extract the same as the Google Sheets spreadsheet, select the Keep filename checkbox.

  3. In File id, enter the ID of the Google Sheets spreadsheet. To find the spreadsheet ID, copy the URL of the spreadsheet and remove the part https://docs.google.com/spreadsheets/d/ from the beginning and the part /edit#gid=0 from the end. For example, if the URL of the document is https://docs.google.com/spreadsheets/d/123_ABC-789/edit#gid=0, the ID is 123_ABC-789. For more information on finding the spreadsheet ID, see the Google documentation.

  1. Click Next.

Choosing where to transfer your data

To choose where to transfer your data, follow these steps:

  1. To assign destinations to your datastream, select their checkboxes. For more information on destinations and their configuration settings, see Introduction to transferring data.

  1. Click Next.

Collecting initial data

To collect the initial data, follow these steps:

  1. Choose the time period for which data is collected.

  1. Click Run fetch.

Previewing data collected from Google Sheets

The fetch collects data from Google Sheets which takes some time. The Overview page of the newly created datastream is now displayed. To preview the collected data, follow these steps:

  1. In the All tasks tab, find the task at the top of the list, and click Show extracts.

  2. Click the top hyperlink.

  3. The data extract is displayed in a table containing the data that you have fetched.

What’s next?

After collecting data from Google Sheets, harmonize your data so that it conforms with Adverity's unified naming and formatting conventions.