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 also…

将查询结果下载至 Google 电子表格

社区数据与报告

rishabh 2020 年9 月 30 日 06:49 11

我们现在有一份专门介绍 Data Explorer API 的指南：

话题		回复	浏览量
Automate the syncing of Discourse queries to Google Sheets Integrations data-explorer , how-to , google	0	65	2026 年1 月 27 日
Discourse Data Explorer Plugin official , data-explorer , included-in-core	31	82510	2025 年10 月 22 日
Run Data Explorer queries with the Discourse API Integrations data-explorer , how-to , rest-api	14	13509	2025 年5 月 6 日
Is it possible to automate a query to export to a google sheet? Data & reporting sql-query	5	472	2022 年9 月 22 日
Data-explorer plugin for generic websites Site feedback	1	531	2021 年11 月 1 日

将查询结果下载至 Google 电子表格

相关话题