API Connector Documentation

Print

Import OpenSea Data to Google Sheets

Last Updated On
byAna
< Knowledge Base

In this guide, we’ll walk through how to pull data from the OpenSea API directly into Google Sheets, using the API Connector add-on for Sheets.

Contents

Before You Begin

Click here to install the API Connector add-on from the Google Marketplace.

Part 1: Get an OpenSea API Key

  1. On opensea.io, hover over your Profile icon and select Settings.
  2. On the left side of the page, click Developer
  3. Fill out your Organization Name, Website, and Intended use of the OpenSea API, and click Submit.
  4. Back in the Developer section of your Account settings, click Create API key.
  5. Name your key and click Create new key.
  6. You should now see your OpenSea API key.

Part 2: Pull Data from OpenSea to Sheets

The easiest way to get started with the OpenSea API is through API Connector’s built-in integration.

  1. Select OpenSea from the drop-down list of applications
    opensea-application
  2. If you have an API key, enter it into the Authorization section
    opensea-authorization
  3. Choose an endpoint. We’ll start with the /collections endpoint, which produces a list of recent collections.
    opensea-collections
  4. Select a destination sheet, name your request, and click Run.
    opensea-response

Part 3: Create a Custom API Request

Alternatively, you can run your own custom requests instead of using API Connector’s pre-built integration, using any of the endpoints and parameters shown in the API documentation. Here's an example request setup. Enter your API key where it says your_API_key, and your collection name where it says your_collection_slug.

  • Application: Custom
  • Method: GET
  • Request URL: https://api.opensea.io/api/v2/collections/your_collection_slug/stats
  • Headers: 
    • X-API-Key: your_API_key
    • Accept: application/json

Part 4: API Documentation

Official API documentation: https://docs.opensea.io/reference/api-overview

Leave a Comment

Jump To