In this article, we will learn how to import Etherscan data to Google Sheets with Etherscan API. Etherscan allows its users to access details on any Ethereum blockchain transactions that are pending or confirmed. If you’re looking for an easy and simple Etherscan tutorial, you’ve come to the right place.
In the snippet below, we have the current, proposed and fast gas prices imported with Etherscan API.
To import Etherscan data to Google Sheets using Etherscan API we will follow the steps mentioned below:
- Get the Etherscan API Key
- Obtain the Etherscan API endpoint URL
- Install the Amigo Data add-on
- Import the Etherscan data
How to import Etherscan data to Google Sheets
Follow the steps given below to learn how to import Etherscan data to Google Sheets with Etherscan API.
Step 1: Get the Etherscan API key
The first thing we need is the Etherscan API key. Follow the steps below to generate an Etherscan API key.
Register for an Etherscan account. An account is needed to create an Etherscan API key and subsequently to import Etherscan data to Google Sheets.
Fill in the necessary fields to set up your account with Etherscan.
Once you have filled in the credentials, you will be asked to verify the e-mail address inputted in the previous step. Verify the email address by clicking on the confirmation link sent to the ID and proceed further.
Upon clicking the confirmation link, your account will be verified and you will be asked to log in again. Log in to your account to create your Etherscan API key.
On your account dashboard, click API Keys under the OTHERS section.
Click on Add and give the app a name and click the Create New API Key button to create your Etherscan API key.
The key will be generated and displayed under the Your API Keys section.
Note the key and keep it confidential. It will be used to retrieve data from Etherscan.
Step 2: Get the Etherscan API endpoint URL
Go to the Etherscan API documentation and select any of the API endpoints. In this tutorial, we will be importing data from the API endpoint titled Gas Tracker.
Scroll down to find the Gas Oracle section and copy the Etherscan gas tracker endpoint URL. We will be using this endpoint URL to import Etherscan data to Google Sheets.
The Ethereum network uses the gas paid in Ether to complete the transaction. The lower the gas paid, the more beneficial it is for the users. Through this data, users can determine and estimate the gas fee that they will be required to pay. Hence, allowing them to decide the right time to send a transaction.
The following link will be copied to your clipboard.
https://api.etherscan.io/api?module=gastracker&action=gasoracle&apikey=YourApiKeyTokenAdd your API key token at the end after the “=” sign replacing the highlighted text. This will result in the final API endpoint URL which will be used to import Etherscan data to Google Sheets using the Amigo Data Add-on.
Step 3: Get Amigo Data Google Sheets extension
The Amigo Data Add-on is an extension in Google Sheets that allows you to import data from various sources without coding.
You can install the extension directly from the Google Workspace Marketplace by clicking the link below.
You also follow the steps below to get Amigo Data from Google Sheets.
- Open a new google sheet
- Click on Extension→ Add-ons→ Get Add-on
- Search for “Amigo Data” and install it.
Step 4: Import the data to Google Sheets
Go to the Google Sheet into which you want to import the Etherscan data. Click on Extennsions→Amigo Data→Connect
Select Custom API from the list of sources.
Paste the API endpoint URL copied earlier and click on Preview to retrieve and preview the Etherscan data to import to Google Sheets.
This API endpoint URL requires no additional parameters and hence there’s no query that we can add to filter the imported data. However, for data that has parameters mentioned, we can filter them under the Details section as shown below.
Flatten the data until it is sorted under relevant column headings and then click Import.
The imported data will be displayed on your Google Sheets as shown below.
And so that’s how we import Etherscan data to Google Sheets with the Etherscan API.
The Gas Oracle API endpoint referred to in the article is just one of the plethora of Etherscan data that can be imported to your Google Sheet using the Amigo Data Add-on.
Auto-update the imported data
Amigo Data allows users to set a refresh schedule that automatically updates the data imported to ensure that the user is provided with the latest data without any manual input. To learn how to automatically update your data at regular intervals and receive alerts for the same on your email or Slack channel, click here.
In this article, we have successfully learned how to import Etherscan Data to Google Sheets. To learn more about related articles on how to use Amigo to automate data imports to Google Sheets, check out our blog.
See Also
Below you will find some related articles on how to import data from a variety of sources.
Import data from Binance to Google Sheets