Search
⌃K

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. 1.
    Get your Dune API key by navigating to the Dune API settings page.
  2. 2.
    Click "Create new API key":
  3. 3.
    Copy the new API key:
  4. 4.
    Go to your Google Sheet with Artemis Sheets installed (installation instructions here) and open the side bar. Click on the settings menu:
  5. 5.
    Click "Insert Dune API Key":
    ​
  6. 6.
    Past the Dune API key into the text box and click "Ok":
  7. 7.
    Done!
​
  1. 1.
    Get your Dune API key by navigating to the Dune API settings page.
  2. 2.
    Click "Create new API key":
  3. 3.
    Copy the new API key:
  4. 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. 5.
    Past the Dune API key into the Dune text box and click "Save":
    ​
  6. 6.
    Done! You should see your masked Dune API key displayed at the top right:

2. Usage

1. Find your Dune query ID:

  1. 1.
    Locate a dashboard from Dune you're interested in pulling. In the example above, we use this GMX Everything Dashboard.
  2. 2.
    Locate a chart from the dashboard you'd like to pull.
  3. 3.
    Click on the chart title - this should take you to the chart's query.
  4. 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)