Skip to main content
Question

Add new mailchimp subscribers to a Google sheet daily


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

Did this topic help you find an answer to your question?

2 replies

Troy Tessalone
Forum|alt.badge.img+14

Hi ​@parker2023 

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.


SamB
Community Manager
Forum|alt.badge.img+11
  • Community Manager
  • 7274 replies
  • February 7, 2025

Hi there, ​@parker2023! 🙂

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!