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. Thank…

When you do a query, you see this: [image] The button that says “CSV” will let you download a CSV file, which you can use with any spreadsheet.

Oh I know :slight_smile: 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 :slight_smile:

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.

[immagine] Jp_Robotshop: How would I do that API call? We now have a dedicated guide for the Data Explorer API: [immagine] Run Data Explorer queries with the Discourse API Developer Guides Virtually any action that can be performed through the Discourse user interf…

Scarica il risultato delle query in Google Spreadsheet

Comunità Dati e reportistica

rishabh 30 Settembre 2020, 6:49am 11

Abbiamo ora una guida dedicata per l’API Data Explorer:

Argomento		Risposte	Visualizzazioni
Automate the syncing of Discourse queries to Google Sheets Integrations data-explorer , how-to , google	0	65	Gennaio 27, 2026
Discourse Data Explorer Plugin official , data-explorer , included-in-core	31	82537	Ottobre 22, 2025
Run Data Explorer queries with the Discourse API Integrations data-explorer , how-to , rest-api	14	13510	Maggio 6, 2025
Is it possible to automate a query to export to a google sheet? Data & reporting sql-query	5	472	Settembre 22, 2022
Data-explorer plugin for generic websites Site feedback	1	531	Novembre 1, 2021

Scarica il risultato delle query in Google Spreadsheet

Argomenti correlati