Import Etherscan Data To Google Sheets 

Reading Time: 5 minutes

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.

Etherscan data imported into Google Sheets

To import Etherscan data to Google Sheets using Etherscan API we will follow the steps mentioned below:

  1. Get the Etherscan API Key
  2. Obtain the Etherscan API endpoint URL
  3. Install the Amigo Data add-on
  4. 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.

Create Etherscan account to generate an Etherscan API

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.

Verify your email address to create an Etherscan account

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.

Access the API key section

Click on Add and give the app a name and click the Create New API Key button to create your Etherscan API key.

Creating an Etherscan API key

The key will be generated and displayed under the Your API Keys section.

Etherscan API key

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.

Etherscan API endpoint options available

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. 

Etherscan gas tracker endpoint

The following link will be copied to your clipboard.

https://api.etherscan.io/api?module=gastracker&action=gasoracle&apikey=YourApiKeyToken

Add 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.

Get Amigo

Install Amigo Data to import Etherscan data to Google Sheets

You also follow the steps below to get Amigo Data from Google Sheets.

  1. Open a new google sheet
  2. Click on Extension→ Add-ons→ Get Add-on
  3. 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

Launch Amigo to import Etherscan data to Google Sheets

Select Custom API from the list of sources.

List of sources to connect

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.

Enter the Etherscan API details in Amigo

Flatten the data until it is sorted under relevant column headings and then click Import.

Preview of the Etherscan data to import to Google Sheets

The imported data will be displayed on your Google Sheets as shown below.

Import Etherscan data to Google Sheets

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

How to import CoinGecko data to Google Sheets

Import Coinbase data to Google Sheets

Leave a Reply