How do I schedule daily Google Sheets data uploads to Mailchimp subscriber list?
Hi all,
I want the flow to be the following:
Every day (zapier schedule)
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!
Page 1 / 1
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.
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?
Thanks again,
Alex
@Alex B
Make sure to review my previous comments showing how many more Tasks this approach will use.
You are trying to use the Lookup Column (Email) and search for a Lookup Value (Submitted At).
I’m guessing the Email column in the GSheet has email addresses and not values of “Submitted At”, which is why no results would be returned.
Thanks @Troy Tessalone so I just need to put in any random e-mail address under look up value here for it to work?
@Alex B
No, you’d need another column on the GSheet that has the date the row was added.