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
Google Sheet
Excel (Windows)
- 1.
- 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.
- 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:
- 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.
- 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, itsqueryId
is1443379
=ARTDUNE(queryId)
In the example above, we use:
=ARTDUNE(1443379)
Last modified 3mo ago