Search API Connector Documentation

Print

Import CryptingUp Data to Google Sheets

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

This is a free and open API so we don’t need any API keys or other authorization. Let’s jump right in!

Contents

Before You Begin

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

Part 1: Fetch Data from CryptingUp

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

  1. Select CryptingUp from the drop-down list of applications
    cryptingup-application
  2. Select an endpoint.  These endpoints are all open so you don’t need an API key. For this example we’ll choose the /assets endpoint, which gets the current market data for all supported cryptocurrencies.
  3. Choose a destination sheet, name your request, and hit Run. A moment later you’ll see the response data in your sheet.
    cryptingup-response

Part 2: Handle Pagination

Note that the CryptingUp API limits the number of records returned in each request. By default, only 100 records will be returned unless you use the size and start parameters as shown in their documentation:
cryptingup-pagination

With API Connector, you can set up pagination handling to cycle through pages automatically, like this:

  • Pagination: cursor
  • Next token parameter: start
  • Next token path: next
  • Run until: choose when the request should stop running
    cryptingup-pagination-cursor

Part 3: API Documentation

Official API documentation: https://www.cryptingup.com/apidoc/

Previous Import Crunchbase Data to Google Sheets
Next Import CryptoCompare Data to Google Sheets

2 thoughts on “Import CryptingUp Data to Google Sheets”

Leave a Reply to CryptingUp Cancel reply

Table of Contents