Google Analytics & Google Sheets

[jayoliverwright]

Hi guys,

I'm looking to use google analytics google sheets extension to pull data into a google sheet with metrics from other tools e.g. semrush, moz, etc.

From my understanding with google analytics google sheet extension its designed to run reports and doesn't really allow you to add other metrics.

Basically what i'm trying to do is this:

https://www.useloom.com/share/c1e42bfa60bd46fca2b1120018969ce8

Any suggestions/advice on how to do this would be great.

Cheers.

[OddDog]

Hi Jay,

We implemented a similar feature using GA and Google Search Console to combine data into a single sheet.  To accomplish this we had to write custom javascripts that accessed the Search Console API and inserted the data into the proper columns.  It was successful, however we grew the dashboard so much that we are now building this as a standalone app to make it a bit less cumbersome.

If you're going to pull the data from providers other than already integrated systems (like Google Analytics), then you're looking at some custom code that you'll have to implement in the Script Editor (Tools > Script Editor).

Good luck!