Get ConvertKit Broadcast List, Data, and Stats into 1 Google Sheet

Getting Started
,
1

Hello all!

I am wanting to automate getting all of my broadcast data from ConvertKit into a Google Sheet.

Here’s ConvertKit API Documentation.

I was able to List Broadcasts into a Google sheet. However, I’m struggling with

  • Retreiving a specific Broadcast
  • Get Stats

I’m assuming I need to create two additional scenarios for each api request. I just don’t know how I will pull in the Broadcast ID into the new scenarios. And how to repeat the request if there are multiple broadcasts sent.

Here’s my attempt in having it all in one scenario, which I think is totally wrong, but would love any help/guidance.

Thanks for all of your help! Def a newbie.

SCR-20230828-oqfu
SCR-20230828-oqfu1768×781 64.5 KB

This is my setup for the second ConvertKit API Module

SCR-20230828-oqbs
SCR-20230828-oqbs407×962 36.9 KB

2

Hi @yazzi

Please note that Authorization Headers are already added by default in Make’s Make an API Call modules. Hence, you don’t have to add secret keys.

Regarding your main query, we need to see the endpoint used and output to decide whether two scenarios are required.

If you need any further help, let us know.

MSquare Support
Visit us here
Youtube Channel

2 Likes
3

Welcome to the Make community!

This seems like a complex scenario you’re trying to make, perhaps exporting the blueprint might help others investigate further and answer your question.

At the bottom of the scenario editor, you can click on the three dots to find the Export Blueprint menu item.

Screenshot_2023-08-24_230826

Uploading it here will look like this:

blueprint.json (119.3 KB)

2 Likes