Google Data StudioGetting Started with Google Data StudioPrerequisites:
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 Studio1. Create your scenario. You must run the scenario before you connect to the Integromat data source in Google Data Studio. Show 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. Use the New Request module to generate a webhook URL. Copy the Webhook URL to use it in step 6. 2. Save the scenario and Run the scenario by clicking theRun Once button 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. 5. Sign-in using your Google account credentials and grant access rights by clicking on theALLOW button. 6. Paste the Integromat webhook URL - use thewebhook URL from step 1. 7. Click on the CONNECT button in the top-right corner. 8. Rename the Data Source if needed: 9. Add the data source to your report. AggregatorsNew responseThis 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.SchemaSet 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". 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.ValuesYou can set a more user-friendly name in the Label field under theShow advanced settings option. 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 theValues section. Data Set Configuration ErrorIf you get this error message, make sure that:
Sample scenarioThe following scenario will collect data from theWeather > Get Daily Weather Forecast module and will create a chart in the Google Data Studio. Google Data Studio > New Request moduleWeather > Get Daily Weather Forecast moduleGoogle Data Studio > New Response moduleResult in Google Data StudioDo you like this article? YesNoDon't forget to share it! |