Import BscScan Data To Google Sheets

How to import BscScan data to Google Sheets
Reading Time: 5 minutes

Quick guide
Steps to import BscScan data to Google Sheets:
1. Generate BscScan API key token
2. Get the BscScan API endpoint
3. Enter the endpoint URL in Amigo
4. Preview the data to import
5. Import the data to Google Sheets

BscScan is the leading blockchain explorer for the BNB Smart Chain, developed by the team behind Etherscan. A blockchain explorer is a search engine that allows users to quickly look up, confirm and validate transactions that have taken place on the BSC blockchain.

BscScan is an analytics platform developed for the Binance Smart Chain (BSC) network and has many useful features. BscScan has data to track cryptocurrency and other decentralised finance (DeFi) projects on the BNB Smart Chain. An overwhelming amount of data can be extracted from the BSC using BSCScan.

BscScan has many useful features and applications such as the following:

  • searching for transactions and checking their status;
  • viewing the latest blocks added to the chain;
  • checking the balance of wallets and any completed transactions;
  • searching, reading and interacting with smart contracts deployed on the blockchain;
  • studying the offer of tokens and other cryptocurrencies.

All this information is available publicly and can be accessed for free–but it does require a bit of digging.

In this tutorial, we’ll learn how to import BscScan data to Google Sheets in a few steps without hassle and without coding. We’ll also learn how to automatically update the imported data in Google Sheets.

How to import BscScan data to Google Sheets

Step 1: Install the Amigo add-on in Google Sheets

Install Amigo Data in your Google Sheets to import BscScan data to Google Sheets. You can get it from the Google Workspace Marketplace by clicking the link below.

Get Amigo

Install Amigo Data to import BscScan data to Google Sheets

Step 2: Create a BscScan API key

Head over to and create an account, if you don’t already have one.

Create an account to import BscScan data to Google Sheets

Fill in the details and confirm the email address. Upon logging in, you’ll be taken to the overview of your profile.

Account section in BscScan API

From the My Profile page, click API-KEYS.

Generating BscScan API key

Then click the Add button beside My API Keys. Give it a name and click Continue to create your BscScan API key.

Naming the app to create a BscScan API key

The BscScan API key has been created and you’ll see it shown under API-Key Token.

The generated API key

Note the API key and keep it confidential. This will be used later on to import BscScan to Google Sheets.

Step 3: Choose a BscScan API endpoint

Go to the BscScan API documentation. On the left side of the API documentation, you’ll find a list of API endpoints.

BscScan API endpoints

Click the endpoint category in which the data of interest falls and scroll to the relevant section. For example, to get a list of blocks validated by address, we’ll select Accounts.

A sample endpoint URL is given under the endpoint heading. We’ll use this endpoint URL but modify it with our own values to pull data from BscScan to Google Sheets.

Sample BscScan API endpoint URL

The sample endpoint URL will return a list of the first ten results (page=1, offset=10) of canonical blocks (blocktype=blocks) validated by the address specified (address=0x78f3adfc719c99674c072166708589033e2d9afe)

We can customise these parameters with our own values. A brief description of the parameters is given in the Request section.

BscScan query parameters

To retrieve a list of blocks validated by another address, we just need to replace the address parameter.

To find a validator’s address, we can go to the validators page and choose any of the validators, say Neptune.

Validator's page

Click on the name of the validator. Then copy the address.

Copying the validator's address

And let’s change the offset parameter to 50. The modified URL becomes:

I’ve added a sample BscScan API key. Replace the key with your own.

Step 4: Import the BscScan data to Google Sheets

Launch Amigo Data to import the data from BscScan to Google Sheets.

Launch Amigo to import BscScan data to Google Sheets

Select Custom API from the list of sources.

Select Custom API from the list of sources

Enter the BscScan API endpoint URL in the API URL field.

Entering BscScan API endpoint URL

Click PREVIEW to retrieve and preview the BscScan data to import to Google Sheets.

Preview the BscScan data to import to Google Sheets

Then flatten and expand the nested datasets. Then click the IMPORT button.

Preview of the BscScan data to import to Google Sheets

The data will be from BscScan will be imported into Google Sheets in a moment.

Shown below is a snippet of the imported data.

The imported data

Automatically update the data

To get the BscScan data in Google Sheets updated automatically at regular intervals, set a refresh schedule.

To set a refresh schedule, specify the update timing and the frequency. Then click “Yes, set the refresh timing”.

Setting refresh schedule to auto-update the BscScan data

You can also set the refresh schedule later. Click View Reports in the Amigo sidebar, select the report, toggle on the refresh schedule button and set the schedule period–hourly, daily, weekly. Then click Save & Run.

Alerts via email or Slack

You can get the report sent to your email or a Slack channel if you want to.

To set up an alert, click Get Alerts→Add alert data+. Edit the details and click Set Alert.


Using Amigo Data you can easily import BscScan data to Google Sheets. And not just import them but get them updated automatically without having to repeat the process and get alerted periodically so that you can stay up to date with any changes.

There are also several sources from which you can use Amigo Data to import data into Google Sheets. A few examples are, data from open government data platforms of the US, UK, and India; Google Search Console, Google Trends, Snowflake, Spotify; etc.

For these and many more, visit our blog.

Here are some similar articles that you may like:

Import Data from Binance to Google Sheets

Import Yahoo Finance to Google Sheets

Import CoinMarketCap Data to Google Sheets

Leave a Reply