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.
1. Setup
Get your Dune API key by navigating to the Dune API settings page.
Click "Create new API key":
Copy the new API key:
Go to your Google Sheet with Artemis Sheets installed (installation instructions here) and open the side bar. Click on the settings menu:
Click "Insert Dune API Key":
Past the Dune API key into the text box and click "Ok":
Done!
2. Usage
1. Find your Dune query ID:
Locate a dashboard from Dune you're interested in pulling. In the example above, we use this GMX Everything Dashboard.
Locate a chart from the dashboard you'd like to pull.
Click on the chart title - this should take you to the chart's query.
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
2. Syntax
=ARTDUNE(queryId)
In the example above, we use:
=ARTDUNE(1443379)
Last updated