# Download result of queries into Google Spreadsheet
**URL:** https://meta.discourse.org/t/download-result-of-queries-into-google-spreadsheet/90612
**Category:** Data & reporting
**Tags:** sql-query
**Created:** [4월 20, 2018, 5:40오후 UTC](https://meta.discourse.org/t/download-result-of-queries-into-google-spreadsheet/90612 "2018-04-20T17:40:52Z")
**Posts on this page:** 11
**Page:** 1
### Author:  [@Jp\_Robotshop](https://meta.discourse.org/u/Jp_Robotshop)
#### Post date: [4월 20, 2018, 5:40오후 UTC](https://meta.discourse.org/t/download-result-of-queries-into-google-spreadsheet/90612/1 "2018-04-20T17:40:52Z")
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.
Thanks!
---
### Author:  [@pfaffman](https://meta.discourse.org/u/pfaffman)
#### Post date: [4월 20, 2018, 6:04오후 UTC](https://meta.discourse.org/t/download-result-of-queries-into-google-spreadsheet/90612/2 "2018-04-20T18:04:48Z")
When you do a query, you see this:
The button that says “CSV” will let you download a CSV file, which you can use with any spreadsheet.
---
### Author:  [@Jp\_Robotshop](https://meta.discourse.org/u/Jp_Robotshop)
#### Post date: [4월 20, 2018, 6:19오후 UTC](https://meta.discourse.org/t/download-result-of-queries-into-google-spreadsheet/90612/3 "2018-04-20T18:19:44Z")
Oh I know 🙂 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,…)
---
### Author:  [@mikechristopher](https://meta.discourse.org/u/mikechristopher)
#### Post date: [4월 20, 2018, 6:27오후 UTC](https://meta.discourse.org/t/download-result-of-queries-into-google-spreadsheet/90612/4 "2018-04-20T18:27:55Z")
Not something I have tried yet but you could technically use zapier making an api call to the [data explorer](https://meta.discourse.org/t/32566?silent=true) plugin and have the data feed into Google sheets
---
### Author:  [@Jp\_Robotshop](https://meta.discourse.org/u/Jp_Robotshop)
#### Post date: [4월 20, 2018, 6:38오후 UTC](https://meta.discourse.org/t/download-result-of-queries-into-google-spreadsheet/90612/5 "2018-04-20T18:38:27Z")
How would I do that API call? I didn’t see anything here or on [Discourse API Docs](https://docs.discourse.org/#tag/Plugins) ?
Thanks a lot!
---
### Author:  [@mikechristopher](https://meta.discourse.org/u/mikechristopher)
#### Post date: [4월 20, 2018, 6:40오후 UTC](https://meta.discourse.org/t/download-result-of-queries-into-google-spreadsheet/90612/6 "2018-04-20T18:40:59Z")
[https://meta.discourse.org/t/data-explorer-plugin/32566/28?u=mikechristopher](https://meta.discourse.org/t/data-explorer-plugin/32566/28)
Read the next few posts more info in there
---
### Author:  [@Jp\_Robotshop](https://meta.discourse.org/u/Jp_Robotshop)
#### Post date: [4월 20, 2018, 7:03오후 UTC](https://meta.discourse.org/t/download-result-of-queries-into-google-spreadsheet/90612/7 "2018-04-20T19:03:37Z")
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 🙂
---
### Author:  [@cpradio](https://meta.discourse.org/u/cpradio)
#### Post date: [4월 20, 2018, 11:10오후 UTC](https://meta.discourse.org/t/download-result-of-queries-into-google-spreadsheet/90612/8 "2018-04-20T23:10:36Z")
Are you also providing the user credentials through an API key?
---
### Author:  [@mikechristopher](https://meta.discourse.org/u/mikechristopher)
#### Post date: [4월 23, 2018, 8:52오전 UTC](https://meta.discourse.org/t/download-result-of-queries-into-google-spreadsheet/90612/9 "2018-04-23T08:52:27Z")
@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.
---
### Author:  [@system](https://meta.discourse.org/u/system)
#### Post date: [9월 30, 2020, 5:37오전 UTC](https://meta.discourse.org/t/download-result-of-queries-into-google-spreadsheet/90612/10 "2020-09-30T05:37:55Z")
---
### Author:  [@rishabh](https://meta.discourse.org/u/rishabh)
#### Post date: [9월 30, 2020, 6:49오전 UTC](https://meta.discourse.org/t/download-result-of-queries-into-google-spreadsheet/90612/11 "2020-09-30T06:49:43Z")
> [@Jp\_Robotshop](#):
>
> 이 API 호출을 어떻게 수행하나요?
현재 [Data Explorer](https://meta.discourse.org/t/32566?silent=true) API를 위한 전용 가이드가 있습니다:
> [@Run Data Explorer queries with the Discourse API](https://meta.discourse.org/t/how-to-run-data-explorer-queries-with-the-discourse-api/120063/):
>
> bookmark This guide explains how to use the Discourse API to create, run, and manage queries with the [Data Explorer](https://meta.discourse.org/t/32566?silent=true) plugin. person_raising_hand Required user level: Administrator Virtually any action that can be performed through the Discourse user interface can also be triggered with the Discourse API. This document provides a comprehensive overview for utilizing the API specifically in conjunction with the [Data Explorer](https://meta.discourse.org/t/32566?silent=true) plugin. For a general overview of how to find the correct API …