Import Etherscan Data To Google Sheets 

Reading Time: 4 minutes

In this article, we will learn how to import Etherscan data to Google Sheets. Etherscan allows its users to access details on any Ethereum blockchain transactions that are pending or confirmed.

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

  1. Get the API Key
  2. Obtain the API endpoint URL
  3. Install the Amigo Data Add-on extension
  4. Import the data

How to import Etherscan data to Google Sheets

Follow the steps given below to learn how to import Etherscan data to Google Sheets.

Step 1: Get the API key

Register for an account here which will be used to get the API key and subsequently, import Etherscan data to Google Sheets.

Fill in the necessary fields to set up your account with Etherscan.

Create an account in Etherscan website

Once, you have filled in the preliminary 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 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 obtain your API key.

On your account dashboard, scroll down to find the section titled API Keys and click on it.

Access the API key section

Click on Add and enter the name of the project you are working on and create the API key as shown below. 

Enter the name of your API key

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

Step 2: Get the API endpoint URL

Navigate to the site here and click on the API endpoint, the data you wish to import to Google Sheets. In this tutorial, we will be importing data from the API endpoint titled Gas Tracker.

API endpoint options available

Scroll down to find the Gas Oracle section and copy the hyperlink associated with the word, browser. 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. 

Insight into the Gas Oracle 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 either install the extension directly from the Google Workspace Marketplace or follow the steps below:

  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 in which you want the data to be pasted. Click on Extennsions→Amigo Data→Connect

Access Amigo Data Add-on

Select Custom API from the list of sources

List of sources to connect

Paste the API endpoint URL copied earlier and click on Preview.

This API endpoint URL requires no additional parameters hence there’s no query that we can add to filter the imported data. However, for data that has parameters mentioned, we can filter it under the Details section as shown below.

Enter the API endpoint URL

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.

Import Etherscan data to Google Sheets

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. 

Note that the users can only generate three API keys with one free account on the Etherscan website.

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, 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