Search API Connector Documentation


Import ConvertKit Data to Google Sheets

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


Before You Begin

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

Part 1: Get Your ConvertKit API Key

  1. Log in to ConvertKit and click your profile icon > Settings > Advanced (or just navigate to directly).
  2. You should now see your API Key and API Secret. Some less sensitive endpoints use the API Key, but the API Secret is required for working with subscriber and purchase data.

  3. Keep these handy as you’ll need them shortly. Congrats! You’re now ready to use the ConvertKit API.

Part 2: Create Your API Request

For our first request, we’ll get a list of your subscribers.

  • Base URL:
  • Endpoint: /subscribers
  • Query parameters: api_secret=your_api_secret

Putting it all together, we get our request URL:

Part 3: Pull ConvertKit API Data into Sheets

We can now enter this into API Connector.

  1. Open up Google Sheets and click Extensions > API Connector > Open.
  2. Copy the request URL we created into the URL field.
  3. We don’t need extra authentication so just leave OAuth as None. We don’t need any Headers either, so just skip that section.
  4. Create a new tab and click Set current to use that tab as your data destination.
  5. Name your request and click Run. A moment later you’ll see your subscriber data populate your Google Sheet.

Part 4: More Example API Requests

You can view the full set of endpoints in the API documentation, but if you just want to get started, try out the following example requests. Substitute in your own values where you see italic text.

  • List all the forms for your account
  • Get subscriptions and subscriber data for a form
  • List all the broadcasts for your account
  • Get the stats (recipient count, open rate, click rate, unsubscribe count, total clicks, status, send progress) from a specific broadcast.
  • Show purchases for your account

Part 5: Handle Pagination

By default, the ConvertKit API will only return 50 records unless you use the ‘page’ parameter:

In API Connector, you can loop through these automatically using pagination handling, like this:

  • Pagination type: page parameter
  • Page parameter: page
  • Run until: choose when to stop fetching data

Part 6: API Documentation

Official API documentation:

Previous Import Constant Contact Data to Google Sheets
Next Import Copper CRM Data to Google Sheets

Leave a Comment

Table of Contents