Using Google Sheets with Looker Studio

[@DavidCulbertson64]

This is great, thanks for making this video. I'm a digital marketer who dabbles in the tech side of analytics as needed to help my clients with their reporting needs. After a great deal of research, I've settled in downloading my clients' GA3 data in Sheets using the Sheets addon. Now, I'm hitting a wall at bringing into Looker as a data source. Connecting goes fine. Doing some exploring is where I run into trouble. I can create a table and a time series chart but Looker isn't giving me an option to apply a data range. Also, I can't make a scorecard. Is there a good tutorial for doing these things? I really want to make a sheet function like a direct connection to GA. Well, as much as possible.

[@iammobenal]

love your content as always

[@MeasurementMarketing]

Glad you enjoy it!

[@TimRehak]

how do you get the dashbord out of looker studio and into sheets?

[@MeasurementMarketing]

Hey Tim! You can export individual charts from Looker Studio into Google Sheets. It is kinda tedious and likely an easier way to get the data directly into sheets.