Skip to main content
Question

Automating Daily New Subscriber Count in ConvertKit via Zapier


Hello,

I’m trying to automate a workflow to track the daily number of new subscribers in ConvertKit. The idea is to:

  1. Trigger a Zap daily at 8 AM.
  2. Retrieve the count of new subscribers from ConvertKit for the previous day.
  3. Add this count to a new row in Google Sheets.

I’ve managed to set up the scheduling trigger and the Google Sheets integration, but I’m struggling with Step 2. ConvertKit’s Zapier integration doesn’t seem to have an action to provide a daily count of new subscribers.

Has anyone found a way to achieve this? I’m open to workarounds too.

I’d appreciate any guidance or examples of how others have automated similar workflows.

Thank you!

Did this topic help you find an answer to your question?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

2 replies

Troy Tessalone
Forum|alt.badge.img+14

Hi ​@gmaacc22 

You would likely have you use the Kit API: https://developers.kit.com/v4#list-subscribers

Zap action options:

 

To hire help, there is a directory of Certified Zapier Experts: https://zapier.com/experts


SamB
Community Manager
Forum|alt.badge.img+11
  • Community Manager
  • 7457 replies
  • January 8, 2025

Hi ​@gmaacc22! 👋

Troy is correct, to access a list of subscribers added the previous day you’d likely need to use a Custom Action or API Request action for the Kit (formerly ConvertKit) app. Although, I’d also recommend contacting our Support team to have a new feature request opened for a “Find Subscribers” type of action to be added that would be able to pull a list of subscribers added before/after specific dates. 

The only other way I can think of to handle this could be to have another Zap keep a record of each subscriber in a Zapier Table or a similar database/spreadsheet app. For example:

  • Trigger: New Subscriber or New Sequence Subscriber—depending on your needs (Kit) - triggers when a new subscriber is added.
  • Action: Create Record (Zapier Tables) - adds a record to the table of the new subscriber and stores the date they were added.

Then, in your other Zap you’d use a Find Records (Output as Line Items) Zapier Tables action to get all the subscribers from the previous day. It would output the number of matching subscriber records it found in a field called Record Count which you could then pass to the Google Sheets action:

417990628823e388ced340a6298f5257.png

That said, with either approach you’d need a way of getting yesterday’s date. To do that you could use a Date / Time (Formatter by Zapier) action and pass it the date value from the Every Day trigger. You’d want to select the Add/Subtract Time Transform function and set it to remove 1 day from the current date. It also has the ability to reformat the date into a different date format.

For example:

d2ad6388471ed35abd59f801cd3f129b.png

The above settings result in it outputting yesterday’s date in MM/DD/YYYY format:

3a390d747415deacc6786346cc79e1c3.png

You can learn more about how to use that sort of Formatter action here: Add or subtract dates and times in Zaps

Hope that helps. If you run into any issues on that or have any questions just let us know! 🙂