How to connect Marketo to Google Data Studio

[Charlotte_Berth]

Hi,

We would like to connect Marketo to Google Data Studio in order to automate our reporting. I know there is already some discussion but they are quite old. 

As anyone done this connection recently? What are the technical requirements?

Many thanks

[Nitish]

Hi @Charlotte_Berth 
Try integration using Zapier as many people have a good success.

Check out below Link for reference

Solved:Google data Studio  

[ajay_mamgain]

Hi @Charlotte_Berth ,

Using rest APIs and Google Sheets (App script) you can automatically extract data in Google Sheets and connect Google Data Studio with it. For example, I get the last 15 days' data in google Sheets on a running basis, connecting to a tableau dashboard for monitoring purposes. If you are using Google Data studio connects with Google Sheets very easily. 

[Mkhanna0510]

Hi @ajay_mamgain 

Can you share the complete process for this approach? I am looking to connect my Marketo data with Looker data or maybe initially to Google sheets then I can decide how to visualise the data.

Thanks

Mohit