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 Integrations bookmark This guide explains how to use the Discourse API to create, run, and ma…

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

社区数据与报告

rishabh 2020年九月30日 06:49 11

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

話題		回覆	觀看
Automate the syncing of Discourse queries to Google Sheets Integrations data-explorer , how-to , google	0	132	2026年一月27日
Discourse Data Explorer Plugin official , data-explorer , included-in-core	30	85434	2025年十月22日
Run Data Explorer queries with the Discourse API Integrations data-explorer , rest-api , how-to	14	14139	2025年五月6日
Is it possible to automate a query to export to a google sheet? Data & reporting sql-query	4	536	2022年九月22日
Data-explorer plugin for generic websites Site feedback	1	574	2021年十一月1日

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

相關主題