Integration of Looker dashboard with google sheets

How can I integrate Looker dashboard to google sheets so that I can retrieve data from looker dashboard to google sheets automatically as and when data is updated on looker dashboard ?

I don't want to manually export data (to csv) from the looker dashboard pages every time it is updated. Instead the updated data should be automatically reflected on one fixed google sheet. 

I also tried to explore the connected sheets feature to connect with Looker but it gives an error stating - "Connected Sheets does not support connecting to Looker Studio." since I am using the free version of looker studios.

Can anyone please help me out with this. 

0 1 2,818
1 REPLY 1

@Vrushbh Hi!
At the moment there is no way to atomatically integrate underlaying data set feeding the chart on your looker studio dashbaord with google sheets.
Consider connecting google sheets programatically with your data source instead. EG when working with GA 4 data. Ingest it from GA 4 API in a desired format.

Regards
Arkady Zagdan