Import Clickbank Data to Google Sheets

In this guide, we’ll walk through how to pull affiliate marketing data from the Clickbank API directly into Google Sheets, using the API Connector add-on for Sheets. We'll first get our API keys from Clickbank, and then set up a request to pull in information from Clickbank to your spreadsheet.

• Before You Begin
• Part 1: Get your Clickbank Clerk API Key
• Part 2: Get your Clickbank Developer API Key
• Part 3: Pull Clickbank API Data into Sheets
• Part 4: More Example API URLs
• Part 5: Handle Pagination
• Part 6: API Documentation

Before You Begin

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

Part 1: Get Your Clickbank Clerk API Key

1. While logged into your Clickbank master account (https://accounts.clickbank.com/), click the Users icon on the left-hand menu, and then the Create New User button.
   
2. After creating the user, click the Manage Permissions link
   
   
3. Set permissions and copy your Clerk API key. We'll need this soon.
   
   
4. Scroll down and select the APIs this user should have access to
   
5. Click Save

Part 2: Get Your Clickbank Developer API Key

1. Still in the Master Account, click the Account icon on the left-hand menu, and then on the name of your linked account.
   
2. Click on Account Settings
   
3. Scroll down the page to the Developer API Keys section and click Edit
   
4. Click Create New Developer Key.
   
5. Give your key a simple description and click Save.
   
6. You'll now see your developer API key. Copy this down as we'll need it in a moment.
   

Part 3: Pull Clickbank API Data into Sheets

For this example, we'll get a list of orders. Clickbank authorizes by combining the developer API key with the clerk API key, so replace your_developer_api_key and your_clerk_api_key with the developer and clerk API keys you created above (make sure to separate them with a colon).

1. Open up Google Sheets and click Extensions > API Connector > Open > Create request.
2. In the request form enter the following:
   • Application: Custom
   • Method: GET
   • Request URL: https://api.clickbank.com/rest/1.3/orders2/list
   • Headers:
     1. Key = Accept, Value = application/json
     2. Key = Authorization, Value = your_developer_api_key:your_clerk_api_key
3. Create a new tab and click Set current to use that tab as your data destination.
4. Name your request and click Run. A moment later you’ll see order statistics printed into your sheet.
   

Part 4: More Example API URLs

1. Check the documentation for the full list of available API requests. For example:
   • get summary stats (account nickname, date, sales, refunds, chargebacks)

     https://api.clickbank.com/rest/1.3/quickstats/list

   • retrieve information from the analytics API (substitute in your account nickname)

     https://api.clickbank.com/rest/1.3/analytics/affiliate/vendor_product_sku?account=ACCOUNT_NICKNAME

   • filter the analytics API for specific fields (again, substitute in your account nickname)

     https://api.clickbank.com/rest/1.3/analytics/affiliate/vendor?select=net_sale_amount&select=hop_count&select=net_sale_count&account=ACCOUNT_NICKNAME

2. By default, some of the Clickbank API endpoints will return data that gets parsed into separate columns. You can select API Connector's compact or grid report styles for a more compact output with fewer columns.

Part 5: Handle Pagination

Clickbank's API returns just 100 rows at a time, as described here.

Clickbank uses an unusual form of pagination that increments pages through the header. This is currently not supported by API Connector's automatic pagination handling feature. Therefore, to fetch additional pages of data, manually set the page number in the header, like this:

Part 6: API Documentation

Official API documentation: https://support.clickbank.com/hc/en-us/articles/220376527-ClickBank-APIs

Interactive request builder for the Analytics API: https://api.clickbank.com/rest/1.3/webjars/swagger-ui/index.html