Import OpenSea Data To Google Sheets

Import OpenSea data to Google Sheets
Reading Time: 4 minutes

In this article, we’ll learn how to import OpenSea data to Google Sheets. We can import OpenSea data such as assets, collections, contracts, listings and offers for an asset, and list of events that occur on assets that OpenSea tracks amongst other types of data. 

We’ll use an extension in Google Sheets–Amigo Data–to pull the data into Google Sheets. With it we can integrate OpenSea to Google Sheets and retrieve data from OpenSea and pull the data automatically by setting an automatic refresh schedule.

Read on to know how to import OpenSea data to Google Sheets. Following are the steps to import OpenSea data to Google Sheets.

  1. Install the Amigo Data extension
  2. Get the endpoint URL
  3. Import the data to Google Sheets

How to import OpenSea data to Google Sheets

Install the Amigo Data extension in Google Sheets

Install the Amigo Data Google Sheets add-on from the Google Workspace Marketplace.

Amigo Data in Google Workspace Marketplace

Click here to install.

Alternatively, you can get it from Google Sheets.

  • Open a new sheet
  • Go to Extensions→Add-ons→Get add-ons
  • Search for Amigo Data and install

Get the endpoint URL

Sign up or log in to RapidAPI.

Once you’re logged in, go to the OpenSea API documentation page in RapidAPI.

Click on the Subscribe to Test button and subscribe to a plan of your choice.

Subscribe to test and choose a plan

On subscribing to a plan, an API key will be generated, which is used to authenticate API calls to RapidAPI.

Click Endpoints to go back to the API Playground. On the left is the list of the available endpoints. Select any one, for example Assets.

List of available  data

Click the Test Endpoint button to verify if the parameters are valid. If they are, a success message will appear under the Results section on the right side of the screen.

Under the Code Snippets section, we’ll find the URL along with the parameters and the headers. Change the language to Shell→cURL. The query parameters are appended in the URL so that we do not have to enter the parameters manually. Copy the URL and also note the headers. These will be used in the next step.

The API endpoint URL and the headers

Import the data to Google Sheets

Open Google Sheets and launch Amigo Data from the sheet into which you want to fill the data. To connect to Amigo Data, click Extensions→Amigo Data→Connect.

Launch Amigo Data

You’ll be presented with a list of sources to connect to. Choose Custom API.

Select Custom API as the source to connect

Paste the endpoint URL in the API URL field. Do not include the apostrophes. (Likewise for the headers.)

Pasting the API URL

Then expand the Details tab and enter the header. For the endpoint we’ve selected, the headers are:

Name: X-RapidAPI-Key, Value: YOUR_API_KEY

Name: X-RapidAPI-Host, Value: opensea13.p.rapidapi.com

The header keys and values in Amigo Data

The data will be imported into Google Sheets in a moment. Below is a snippet of the imported data.

Snippet of the imported data

You can likewise import the rest of the data types from OpenSea. Once the data have been imported into Google Sheets, they can be updated automatically at regular intervals–hourly, daily, weekly or on custom days–should you so wish, and get these data sent to your inbox. Click here to learn how set a refresh schedule and set up alerts in Amigo Data.

Visit our blog for to find out about the kinds of data that you can import to Google Sheets and how you can track stock and other financial data from Google Sheets.

Some recommended articles:

Automate Importing Financial Market Data To Google Sheets Using Polygon.io API

Get Real-Time Crypto Prices In Google Sheets With Live Coin Watch API

Import Data From Fidelity Investments To Google Sheets