Comment on page

Dune

Pulling data programmatically from Dune into Excel / GSheets

Artemis Sheets allow you to pull individual charts or queries programmatically from Dune directly into your Excel / GSheets.
Example Dune Chart - GMX Volume
GMX Volume pulled in Excel
​
1. Setup
Google Sheet
Excel (Windows)
1.Get your Dune API key by navigating to the Dune API settings page.
2.Click "Create new API key":

3.Copy the new API key:

4.Go to your Google Sheet with Artemis Sheets installed (installation instructions here) and open the side bar. Click on the settings menu:

5.Click "Insert Dune API Key":

​
6.Past the Dune API key into the text box and click "Ok":

7.Done!
​
1.Get your Dune API key by navigating to the Dune API settings page.
2.Click "Create new API key":


3.Copy the new API key:

4.Go to your Excel application with Artemis Sheets installed (installation instructions here) and click on the "Artemis Sheets" menu bar item. Then click on the "External providers API keys" button:

​
5.Past the Dune API key into the Dune text box and click "Save":

​
6.Done! You should see your masked Dune API key displayed at the top right:

2. Usage
1. Find your Dune query ID: 
1.Locate a dashboard from Dune you're interested in pulling. In the example above, we use this GMX Everything Dashboard. 
2.Locate a chart from the dashboard you'd like to pull.
3.Click on the chart title - this should take you to the chart's query.
4.The queryId is the first number in the URL. For example, the GMX Platform Volume URL is: https://dune.com/queries/1443379/2445683. Therefore, its queryId is 1443379
2. Syntax
=ARTDUNE(queryId)
In the example above, we use:
=ARTDUNE(1443379)