Import KuCoin Data to Google Sheets
In this guide, we’ll walk through how to pull data from the KuCoin API directly into Google Sheets, using the API Connector add-on for Sheets.
For this guide, we'll be using their open market endpoints so we don't need any API keys or other authorization. Let's jump right in!
- Before You Begin
- Part 1: Pull Data from KuCoin to Sheets
- Part 2: Create a Custom Request
- Part 3: Get Private KuCoin Account Data
- Part 4: Handle Pagination
- Part 5: API Documentation
Before You Begin
Click here to install the API Connector add-on from the Google Marketplace.
Part 1: Pull Data from KuCoin to Sheets
The easiest way to get started with the Kucoin API is through API Connector’s built-in integration.
- In Sheets, open API Connector and create a new request (Extensions > API Connector > Open > Create request)
- Select Kucoin from the drop-down list of applications
- Select an endpoint. These endpoints are all open so you don’t need an API key. For this example we’ll choose the
- Choose a destination sheet, name your request, and hit Run.
Part 2: Create a Custom Request
Alternatively, you can run a custom request instead of using API Connector’s built-in integration, using any of the endpoints and parameters shown in the API documentation. Here is an example setup:
- Request method:
- Request URL:
To easily convert your preset request to a custom request, click Output Options > More Options > Add Request URL before you run your request. This will print your request URL into your sheet so you can copy and paste it.
Part 3: Get Private KuCoin Account Data
The above endpoints deal with public market data from the KuCoin API.
If you are instead a KuCoin customer looking to get API data from your own account, they require a more complex authentication process that includes generating a “signature”.
To access your private account data, please copy this sheet and follow the instructions within.
Part 4: Handle Pagination
Note that the Kucoin API limits the number of records returned in each request. By default, only 100 records will be returned unless you use the
currentPage parameter as shown in their documentation.
With API Connector, you can set up pagination handling to cycle through pages automatically, like this:
- Pagination: page parameter
- Page parameter: currentPage
- Run until: choose when to stop fetching data
Part 5: API Documentation
Official API documentation: https://docs.kucoin.com/#market-data