Hi, could anyone help me create a zap where every morning the total number of new people who have subscribed to our mailchimp newsletter in the last 24 hours are added to a column on google sheet with the date the data was added?
And also the total number of active subscribers in the audience to another column?
For example, there might have been 5 new subscribers in the last 24 hours but the total active subscribers on the list might be 18,000
Thanks
Hi
That type of automation logic would likely involve using the Mailchimp API: https://mailchimp.com/developer/marketing/api/
Options:
A different approach would be to log each new subscriber, then run analysis in the GSheet or Airtable Base.
Hi there, 
Just checking in—did you manage to get it sorted by using a Custom Action or API Request as Troy suggested?
Let us know if you need any help at all!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.