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,…)

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

Download result of queries into Google Spreadsheet

Community Building Data & reporting

mikechristopher April 20, 2018, 6:27pm 4

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

Topic		Replies	Views
Automate the syncing of Discourse queries to Google Sheets Integrations data-explorer , how-to , google	0	151	January 27, 2026
Discourse Data Explorer Plugin official , data-explorer , included-in-core	30	86769	October 22, 2025
Run Data Explorer queries with the Discourse API Integrations data-explorer , rest-api , how-to	14	14305	May 6, 2025
Is it possible to automate a query to export to a google sheet? Data & reporting sql-query	4	577	September 22, 2022
Data-explorer plugin for generic websites Site feedback	1	611	November 1, 2021

Download result of queries into Google Spreadsheet

Related topics