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
- Part 1: Get ConvertKit API Key
- Part 2: Create your API Request URL
- Part 3: Pull ConvertKit API Data into Sheets
- Part 4: More Example API Requests
- 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 ConvertKit API Key
- Log in to ConvertKit and click your profile icon > Settings > Advanced (or just navigate to https://app.convertkit.com/account_settings/advanced_settings directly).
- 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.
- 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:
Part 3: Pull ConvertKit API Data into Sheets
We can now enter this into API Connector.
- Open up Google Sheets and click Extensions > API Connector > Open.
- Copy the request URL we created into the URL field.
- We don’t need extra authentication so just leave OAuth as None. We don’t need any Headers either, so just skip that section.
- Create a new tab and click Set current to use that tab as your data destination.
- 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: https://developers.convertkit.com/#api-basics