Copy all new data added to a google sheets from the previous day
Upload that data into Mailchimp subscriber list
I had steps 2 and 3 working before but we are now getting too may people sign up and we want to limit the uploads to our mailchimp daily vs every time a new row is added in google sheets.
Any help would be much appreciated!
Best answer by Troy Tessalone
Hi @Alex B
Good question.
It will actually use more Zap Tasks trying to schedule vs triggering once per row.
ZAP
Trigger: GSheet - New Row
Action: Mailchimp - Add/Update Subscriber
This uses 1 Task.
So 100 rows = 100 Tasks.
ZAP
Trigger: Scheduler - Daily
Action: GSheets - Find Row(s)
Action: Looping - Create Loop from Line Items
Action: Mailchimp - Add/Update Subscriber
This will use 1 Task + 2 Tasks per found GSheet Row.
So 100 rows = 201 Tasks.
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
Thanks @Troy Tessalone but I’m still struggling (my fault).
I want to add all new e-mails under the column headed Email each day but for some reason the test fails. I have attached a screenshot of the way in which I’m filling it out. I don’t have a day or date for the spreadsheet so maybe this is causing an issue?
No, you’d need another column on the GSheet that has the date the row was added.
e.g. Run Today, find Yesterday’s Date
ZapConnect 2026 is coming
Join us September 23rd, 2026 for a free, one-day virtual event with 30+ sessions on AI automation. Get live build-alongs, playbooks, and strategies to lead AI transformation at your organization.