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.

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

Télécharger le résultat des requêtes dans Google Spreadsheet

Communauté Données et rapports

rishabh Septembre 30, 2020, 6:49 11

Nous avons désormais un guide dédié à l’API Data Explorer :

Sujet		Réponses	Vues
Automate the syncing of Discourse queries to Google Sheets Integrations data-explorer , how-to , google	0	65	Janvier 27, 2026
Discourse Data Explorer Plugin official , data-explorer , included-in-core	31	82492	Octobre 22, 2025
Run Data Explorer queries with the Discourse API Integrations data-explorer , how-to , rest-api	14	13508	Mai 6, 2025
Is it possible to automate a query to export to a google sheet? Data & reporting sql-query	5	472	Septembre 22, 2022
Data-explorer plugin for generic websites Site feedback	1	531	Novembre 1, 2021

Télécharger le résultat des requêtes dans Google Spreadsheet

Sujets connexes