I have a table in SQL Server that has 2500 records. Each record represents a person. I need to load these records into a Mailchimp list. If the person already exist, then update otherwise insert.
Seems simple, but I can’t seem to get this figured out. I can setup a SQL task to retrieve all records. But, I don’t see a way to loop through each record and use each record in a Mailchimp task. I do see the loop task but that seems to just setup a loop and does not retain a specific record to be used downstream.
Please let me know how to accomplish this in zapier.