Automatically export Looker studio report to google sheet

[PintaMarketing]

"I'm new to using LookerStudio and looking to automate the export of reports to Google Sheets. what are the process? Also, what costs should I expect when implementing this solution?"

[sam8]

Hi there! A few points of clarification:

• You can export an individual chart from Looker Studio to Google sheets, but not a full report.
  • This functionality is free.
  • There is no way to automate this as far as I know.
• You can also schedule a report, but the format is PDF and the destinations are email are email or Google chat.
  • This functionality is also free.

Now, if you're using Looker and not Looker Studio, you can schedule individual charts to Google Sheets. But this would require you to buy a subscription to Looker.

[Alison2]

Hi @PintaMarketing , You can export a chart or a full report into Sheets with a 3rd-party tool like Slideform. Slideform connects to Looker Studio and pulls the data, charts, metrics, etc into Google Slides, Sheets, Docs, and the MS Office suite too. You can use this to automatically populate charts and metrics in your recurring reports and presentations.