Dune
Pulling data programmatically from Dune into Excel / GSheets
Last updated
Was this helpful?
Pulling data programmatically from Dune into Excel / GSheets
Last updated
Was this helpful?
Artemis Sheets allow you to pull individual charts or queries programmatically from directly into your Excel / GSheets.
Click "Create new API key":
Copy the new API key:
Click "Insert Dune API Key":
Past the Dune API key into the text box and click "Ok":
Done!
Locate a chart from the dashboard you'd like to pull.
=ARTDUNE(queryId)
In the example above, we use:
=ARTDUNE(1443379)
Get your Dune API key by navigating to the .
Go to your Google Sheet with Artemis Sheets installed (installation instructions ) and open the side bar. Click on the settings menu:
Get your Dune API key by navigating to the .
Go to your Excel application with Artemis Sheets installed (installation instructions ) and click on the "Artemis Sheets" menu bar item. Then click on the "External providers API keys" button:
Locate a dashboard from Dune you're interested in pulling. In the example above, we use this .
Click on the chart title - this should take you to the .
The queryId
is the first number in the URL. For example, the GMX Platform Volume URL is: . Therefore, its queryId
is 1443379