Jp_Robotshop is seeking a way to automatically download the result of queries into a Google Spreadsheet using the Data Explorer plugin. pfaffman suggests downloading a CSV file, but Jp_Robotshop wants a more automated process.
mikechristopher recommends using Zapier to make an API call to the Data Explorer plugin, which can feed the data into Google Sheets. However, Jp_Robotshop is unsure how to make this API call. cpradio mentions the need to provide user credentials through an API key.
mikechristopher shares a successful test using a POST request to DOMAIN/admin/plugins/explorer/queries/18/run with api_key and api_username in the form data. rishabh provides a link to a dedicated guide for the Data Explorer API: https://meta.discourse.org/t/how-to-run-data-explorer-queries-with-the-discourse-api/120063/.
Hey there,
This plugin is pretty amazing.
I was wondering if there was a way to download the result of the queries in a Google Spreadsheet?
We use primarly Data Studio for our reporting/dashboards and having a way to automatically update our Google Spreadsheet would be particularly useful.
Thanks!
When you do a query, you see this:
The button that says “CSV” will let you download a CSV file, which you can use with any spreadsheet.
Oh I know 
But what I’m looking for would be for the data to be automatically put in a Google Spreadsheet (instead of me downloading the CSV, opening it, copying the data over,…)
Not something I have tried yet but you could technically use zapier making an api call to the data explorer plugin and have the data feed into Google sheets
How would I do that API call? I didn’t see anything here or on Discourse API Docs ?
Thanks a lot!
https://meta.discourse.org/t/data-explorer-plugin/32566/28?u=mikechristopher
Read the next few posts more info in there
Tried that but I get a “Oops! That page doesn’t exist or is private.”.
Will try to find more with the Network tab, but if anybody has more details (or easier how-to) feel free to share
Are you also providing the user credentials through an API key?
@Jp_Robotshop Did you manage to get it to work
I have just tested it and was able to send through a POST request to DOMAIN/admin/plugins/explorer/queries/18/run
Make sure you are sending your api_key and api_username through the form data and it should return your data ok.
We now have a dedicated guide for the Data Explorer API: