How to get data from Rarible into Google Sheets

Rarible is a community-owned NFT space that lets you easily create, collect, and discover NFTs from thousands of talented creatives. We can use the Rarible API to import data from Rarible into Google Sheets. In this tutorial, we’ll show you how to connect the Rarible REST API to Google Sheets in 4 steps:

  1. Install the Apipheny add-on
  2. Choose a Rarible endpoint
  3. Enter your Rarible API request into Apipheny
  4. Run the Rarible API request in your Google Sheet

Step 1.) Install and open the Apipheny add-on for Google Sheets

Apipheny is a free API connector for Google Sheets. You can use Apipheny to connect your Google Sheets to API data sources, easily.

1.) Install Apipheny by opening the following link on desktop and then clicking the Install button in the Google Marketplace:

2.) After you’ve installed Apipheny, open a Google Sheet and then click on the Extensions dropdown in the menu at the top.

In the dropdown list you should see Apipheny. Click Apipheny then click Import API to open the Apipheny sidebar in your Google Sheet.

open apipheny

Tip: you can open a new Google Sheet by entering this URL in your browser:

Step 2.) Choose a Rarible endpoint

In this section, we’ll show you how to browse the Rarible API documentation to find the endpoint that retrieves the information you need from your account. If you already know your API URL, or you want to use the same example URL as us, just skip to Step 3.

First, open the RaribleAPI documentation page:

The menu on the left contains general information about the Rarible API and a list of categorized endpoints.

The Rarible API can be accessed through different networks. Depending on which network you choose to access the API, you’ll have a different base URL. In the main section of this page, you can see a table containing these base URLs and the corresponding network. For this tutorial, we chose the Production (Mainnet) network. Its base URL is:

Rarible API documentation page
Rarible API documentation page

After you click on the Mainnet link underneath the links table, a page with a list of its categorized endpoints will be displayed:

The Mainnet documentation
The Mainnet documentation

If we click the activity-controller category, a list of its endpoints will be displayed:

The Activity-Controller category
The Activity-Controller category

An example endpoint is getAllActivities, which returns all the activities:

The endpoint’s documentation contains a short description of the endpoint’s purpose, its HTTP method (GET), the URI, a list of accepted parameters, and example responses:

The getAllActivities endpoint documentation
The getAllActivities endpoint documentation

Step 3.) Enter your Rarible API request into Apipheny

Now go back to your Google Sheet and make sure that the Apipheny add-on is open on the Import tab. With the Import tab open, enter these details into the add-on:

Method: At the top of the Apipheny sidebar, select the HTTP method (GET or POST) required by your API endpoint. For this example, we are using the GET method.

API URL: In Step 2, we explained how you can find the Rarible REST API endpoint that you need. Now copy and paste your complete Rarible API URL into the Apipheny add-on, where it says API URL Path, followed by any parameters required for your query (if applicable).

For this example, we are using the Item Controller – Get All Items endpoint, which returns all the items. This is what the whole URL looks like:

Headers: The Headers section will remain blank in Apipheny. There are no headers.

Rarible API request entered into Apipheny
Rarible API request entered into Apipheny

Step 4.) Run the Rarible API request in your Google Sheet

Finally, the last step is to click the Run button at the bottom of the Apipheny add-on and then wait for the Rarible API data to be imported into your Google Sheet.

That’s it! You’ve successfully connected your Rarible account to Google Sheets using the Rarible API, Google Sheets API, and the Apipheny add-on.

After making a successful request to the Rarible API, try querying a different Rarible API endpoint, or try using one of the more advanced features in the Apipheny add-on.

Popular API Tutorials

API Knowledge

What is an API?

What is an API URL?

What are parameters?

What is an endpoint?

What is an API key/token?

What is basic authentication?

What are headers?

What is a GET request?

What is a POST request?

Import JSON to Google Sheets

SEO by SearchCyrus