< All Topics
Print

Importing BscScan Data

PostedFebruary 1, 2025
UpdatedFebruary 1, 2025
ByAnas Kakuwala
This guide will walk through how to pull data from the BscScan API and put it directly into Google Sheets.
Begin by acquiring an API key from BscScan. Then you can set up a request using Phlorin’s built-in integration in Google Sheets.

Getting Started

Install the API solution add-on from Google Marketplace.

Begin by getting your BscScan API Key

To request data from BscScan you must first have an account with them at bscscan.com. After this you can obtain an API key.

1. Begin by logging into your BscScan account.
2. Once logged in, go to the account dropdown menu and click API Keys.

3.In the API Keys menu you will then click Add.

4. Next, name the API Key and click Continue.

5. After which, your API will be created. Copy this to use in Sheets with Phlorin.

Pull BscScan data into Sheets

To get the most out of BscScan, use Phlorin to pull data seamlessly into Google Sheets.

1. In your desired Sheets document, open Phlorin and create a new request:
Extensions > Phlorin > Open > Create a request

2. In the Application dropdown select or search for BscScan.

3. From here we will need to select an endpoint, enter your API Key, and the required parameters.

This example uses the get gas prices endpoint.

This is a very simple endpoint, others will have to fetch other information to fill the parameters. Reach out to support or scan the BscScan documentation for any detailed understandings.

4. Make sure your desired sheet is selected and click Run.

Creating Custom Request

With Phlorin and BscScan’s API documentation you can create URLs to run custom requests. Search their documentation for the desired request and adapt the URL to suit your needs.

Application: Custom
Method: GET
Request URL: https://api.bscscan.com/api?module=transaction&action=gettxreceiptstatus&txhash=0xe9975702518c79caf81d5da65dea689dcac701fcdd063f848d4f03c85392fd00&apikey=API-KEY-HERE

Documentation

BscScan’s official API documentation: https://docs.bscscan.com/

Phlorin