Search API Connector Documentation

Print

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.

Contents

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 https://app.convertkit.com/account_settings/advanced_settings directly).
    convertkit-menu
  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.
    convertkit-apikey

  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: https://api.convertkit.com/v3
  • Endpoint: /subscribers
  • Query parameters: api_secret=your_api_secret

Putting it all together, we get our request URL:

https://api.convertkit.com/v3/subscribers?api_secret=11111111

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.
    convertkit-url
  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.
    convertkit-results

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
    https://api.convertkit.com/v3/forms?api_key=your_api_key
  • Get subscriptions and subscriber data for a form
    https://api.convertkit.com/v3/forms/your_form_id/subscriptions?api_secret=your_api_secret
  • List all the broadcasts for your account
    https://api.convertkit.com/v3/broadcasts?api_secret=your_api_secret
  • Get the stats (recipient count, open rate, click rate, unsubscribe count, total clicks, status, send progress) from a specific broadcast.
    https://api.convertkit.com/v3/broadcasts/your_broadcast_id/stats?api_secret=your_api_secret
  • Show purchases for your account
    https://api.convertkit.com/v3/purchases?api_secret=your_api_secret

Part 5: Handle Pagination

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

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
    pagination-page-parameter

Part 6: API Documentation

Official API documentation: https://developers.convertkit.com/#api-basics

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

Leave a Comment

Table of Contents