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.

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

تحميل نتائج الاستعلامات إلى Google Spreadsheet

مجتمع البيانات والتقارير

rishabh 30 سبتمبر 2020، 6:49ص 11

لدينا الآن دليل مخصص لواجهة برمجة تطبيقات مستكشف البيانات:

الموضوع		الردود	مرات العرض
Automate the syncing of Discourse queries to Google Sheets Integrations data-explorer , how-to , google	0	65	27 يناير 2026
Discourse Data Explorer Plugin official , data-explorer , included-in-core	31	82500	22 أكتوبر 2025
Run Data Explorer queries with the Discourse API Integrations data-explorer , how-to , rest-api	14	13508	6 مايو 2025
Is it possible to automate a query to export to a google sheet? Data & reporting sql-query	5	472	22 سبتمبر 2022
Data-explorer plugin for generic websites Site feedback	1	531	1 نوفمبر 2021

تحميل نتائج الاستعلامات إلى Google Spreadsheet

الموضوعات ذات الصلة