Transferring data to Google Sheets

This guide explains how to transfer data to Google Sheets to store and further process information.

Concept

Google Sheets is an Active Destination. After you set Google Sheets as the Destination of a Datastream, data is transferred to Google Sheets each time data is fetched for the Datastream. For more information, see Destination types.

You can assign multiple Destinations to a Datastream. For more information on possible limitations, see Assigning multiple Destinations to a Datastream.

Prerequisites

Before you complete the procedure in this guide, perform all of the following actions:

  • Create a Datastream whose data you want to transfer to Google Sheets. For more information on creating a Datastream, see Introduction to collecting data.

Procedure

To transfer data from a Datastream to Google Sheets, follow these steps:

  1. Add Google Sheets as a Destination to the Workspace which contains the Datastream or to one of its parent Workspaces.

  2. Assign the Google Sheets Destination to the Datastream.

  3. Configure transfer settings.

Adding Google Sheets as a Destination

To add Google Sheets as a Destination to a Workspace, follow these steps:

  1. Click the Transfer element and select the Workspace you work with in Connect, Enrich & Transfer.

  1. Click + Add.

  2. Click Google Sheets.

  1. Click Setup a new Authorization.

  2. Click Next.

  1. Log in to your Google Sheets account.

  1. In the Configuration page, fill in the following fields:

    Name

    (Optional) Rename the Destination.

    For more information on advanced configuration settings, see Google Sheets Destination reference.

  1. Click Create.

Assigning Google Sheets as a Destination

To assign the Google Sheets Destination to a Datastream, follow these steps:

  1. Click the Connect element and select the Workspace you work with in Connect, Enrich & Transfer.

  1. Select the chosen Datastream.

  1. In the Destinations section, click + Add Destination.

  2. Click Assign Existing Destinations.

  1. Select the Google Sheets checkbox in the list.

  2. Click Save.

Configuring transfer settings

To configure transfer settings, follow these steps:

  1. Click the Connect element and select the Workspace you work with in Connect, Enrich & Transfer.

  1. Select the chosen Datastream.

  1. In the Destinations section, find the Google Sheets Destination in the list, and click on the right.

  2. Click Destination Settings.

  1. Fill in the following fields:

    Filename

    Specify the target Google Sheets spreadsheet in the Destination where to transfer data from the Datastream. The name can contain alphanumeric characters and underscores. For example, target_spreadsheet.

    To transfer data to an existing Google Sheets spreadsheet, paste the link of the spreadsheet in Filename.

    By default, Adverity saves data from each Datastream in a different Google Sheets spreadsheet named {datastream_type}_{datastream_id}.

    You can specify the same target Google Sheets spreadsheet for several Datastreams. If a column is shared between Datastreams, Adverity performs a full outer join and concatenates values. If a column is not shared between Datastreams, Adverity writes null values in the relevant cells.

    Use placeholders to create unique, dynamic spreadsheet names in the Destination. Use the following placeholders:

    Placeholder

    Description

    {datastream_id}

    The Datastream ID.

    {datastream_type}

    The Datastream Type.

    Sheet

    Specify the sheet within the Google Sheets spreadsheet where to transfer data. If the list of sheets is grayed out, click Save, and then click Destination Settings again.

  2. Click Save.