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

  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!

​
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 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)