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:
Trigger a Zap daily at 8 AM.
Retrieve the count of new subscribers from ConvertKit for the previous day.
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.
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:
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:
The above settings result in it outputting yesterday’s date in MM/DD/YYYY format:
