Google Data Studio

Getting Started with Google Data Studio

Prerequisites:

    • To access Google Data Studio, a Google account is needed. You can log into Google Data Studio or create an account on the Google Data Studio page.
    • An Integromat Data Source created and authorized in Google Data Studio
    • A created (and executed) scenario
To establish a connection to Google Data Studio you must create and run your scenario beforehand! See the instructions below.

Creating an Integromat Data Source in Google Data Studio

1. Create your scenario. You must run the scenario before you connect to the Integromat data source in Google Data Studio.

Each Google Data Studio scenario in Integromat must have at least two modules: the webhook, New Request (the first module in the scenario) and the responder/aggregator, New Response (the last module in the scenario in which you must specify a structure for your data). Between these two modules, you should place other modules.

You can use this template for it:  https://www.integromat.com/en/integration/3129-send-daily-weather-forecast-data-to-google-data-studio

2019-01-17_10_53_23-Microsoft_Edge.png

Use the New Request module to generate a webhook URL.

2019-01-16_16_44_18-Window.png

Copy the Webhook URL to use it in step 6.

2. Save the scenario and Run the scenario by clicking the Run Once button 

Screen_Shot_2019-08-27_at_10.46.59__1_.png

You have to see the scenario waiting for the webhook data:

3. Click the following link to add the Integromat data source to Google Data Studio:

https://datastudio.google.com/datasources/create?connectorId=AKfycbwUsUqXSVNBmjwrv90WcFjLR41NMIyEus4xuwl9DvQ_wCESH4IKxxrge8eoOF012AvD

4. To confirm the action click on the AUTHORIZE button.

2019-01-30_18_26_43-Window.png

5. Sign-in using your Google account credentials and grant access rights by clicking on the ALLOW button.

2019-01-16_16_37_38-Window.png

6. Paste the Integromat webhook URL - use the webhook URL from step 1.

2019-01-30_18_35_49-Window.png

7. Click on the CONNECT button in the top-right corner. 

2019-01-16_16_54_53-Window.png

8. Rename the Data Source if needed:

CleanShot_2019-12-18_at_12.25.11_2x.png

9. Add the data source to your report.

 

Aggregators

CleanShot_2019-12-18_at_12.25.49_2x.png

 

New response

This module must be the last module in your scenario. It sends collected data to Google Data Studio.

Source moduleSelect the source module you want to collect the data from.
Schema

Set Name and Data type.

The Name field will be used as a unique identifier. Only alphanumeric characters and underscores are allowed. E.g. instead of "Campaign ID" enter "Campaign_ID".
You can set a more user-friendly name in the Label field under the Show advanced settings option.
Group byHere you can define an expression containing one or more mapped items. The aggregated data will be then separated under Groups with the same expression's value. Each Group outputs as a separate bundle and contains a Key with the evaluated expression and the aggregated text. By doing this, you can use the Key as a filter in subsequent modules.
Stop processing after an empty aggregationEnable this option to stop the scenario when no data is received.
Values

Enter Name and Value.

The name of the Name field in the Schema section must be the same as the name of the Name field in the Values section.

2019-01-17_15_05_36-Window.png

Data Set Configuration Error

2019-01-17_15_38_56-Window.png

If you get this error message, make sure that:

  • You run your Integromat scenario before performing an action in Google Data Studio.
  • The webhook in your active New Request module matches the webhook URL used in the Integromat Google Data Studio data source.

Sample scenario

The following scenario will collect data from the Weather > Get Daily Weather Forecast module and will create a chart in the Google Data Studio.

2019-01-17_15_12_33-Window.png

Google Data Studio > New Request module

2019-01-17_15_18_01-Window.png

Weather > Get Daily Weather Forecast module

2019-01-17_15_16_40-Window.png

Google Data Studio > New Response module

2019-01-17_15_25_04-Window.png

Result in Google Data Studio

2019-01-17_15_27_27-Window.png

 

Popular use cases from our blog

automated-data-collection-crm-illustration

How to Automate Data Collection - Part 5: CRM Systems

automated-data-collection-chatbot-marketing-illustration

How to Automate Data Collection - Part 4: Chatbot Marketing

automated-data-collection-paid-ads-illustration

How to Automate Data Collection - Part 3: Paid Ads

automated-data-collection-email-illustration

How to Automate Data Collection - Part 2: Email Marketing Segmentation

personalized-customer-experience-illustration-integromat

5 Automated Solutions to Personalize Customer Experience

data-collection-automation-forms-pt-1

How to Automate Data Collection - Part 1: Online Forms

Didn’t find what you were looking for?

Ticket

Create a ticket

Contact our world-class support team and tell us what’s happening.

Create a ticket
Expert

Find an expert

We feature a network of 450+ certified partners across the globe who are ready to help

Find an expert

Automate any workflow in your business

Sign up for a free account today. No credit card required, no time limits on free plan.