Feeding data from Google Data Studio to Google Sheets[ Edited ]
May 2017 - last edited May 2017
I'm exploring if Google Data Studio is right for us, and one of the features we would love to have is the ability to use Google Data Studio to feed data back into Google Sheet spreadsheets. Google Sheets already has similar functionality between Sheets and Slides/Docs, and this is exactly what we're looking for between Data Studio and Sheets.
To be clear, I don't mean using a google sheet as my data source or connector, but taking a data table in Google Data Studio and linking it to a Google Sheet so that when the data is refreshed, it also refreshes in the Google Sheet.
Feeding data from Google Data Studio to Google Sheets
Unfortunately, you can't export a data source from Data Studio into a Google Spreadsheet.
You can find some addons in Google Spreadsheets for import or export data with Google Analytics but not with Google Studio.