The idea is basically what bigquery have.
There’s the known issue with large results, but I guess it would already be helpful for small/medium results.
This site is in read only mode. Please continue to browse, but replying, likes,
and other actions are disabled for now.
jesse
2
You can do this right now with the Redash API and Google Sheets’ IMPORTDATA function.
- From the query editor, click the elipsis menu and then
Show API Key. - Then copy out the link that provides results in CSV format
- Paste this into the
IMPORTDATAfunction with Google Sheets.
Here is a related question from earlier this year.
Thank you for the quick reply! 
Although I was actually thinking about the convenient experience that BigQuery offers (like in the screenshots attached), that’s definitely an option.
skeggse
4
@jesse that’s a great solution if you’re using the hosted redash solution; what if you’ve got it deployed internally, and aren’t exposing it to the public internet? Clearly, you could open up limited access to the API (possibly allowlisting Google IP ranges), but it’d also be nice if redash were able to push query results to Google Sheets when it refreshes!
1 Like
Ralph
5
Hi @jesse, I tried the IMPORTDATA funcion, it only works for certain report only.
In my case, I wanted to pull a report (which required parameters such as date from, date to, country) from my redash to my Google sheet, it doesn’t works.
I think it I need to understand how to use the Redash API instead. Does anyone know how to achieve this? Thanks