My question: I have a google sheet export with our customer information from our custom made CRM (kinda oldskool) Its got 260 colomns and about a 1500 rows. I want to update my contacts in Active campaign, on a weekly basis. So I’ve copied alle the fields to AC, set up an export and connected through a zap. My plan is to;
-weekly export all this data.
-delete the data inside, add the fresh export
-when a certain cel changed, it triggers
I dont want Zapier, thinking ive added 1500 rows (on a weekly basis)
Do I just turn of the zap, do my thing, and turn it back on?
(and does every change in a cel counts as a task?)
Hope to hear from you!
Best answer by Danvers
If any new customers will be added as a new row at the BOTTOM of the list (ie if you’re ordering by the ID) then you’ll be able to use the Google Sheets New or Updated Row trigger here.
With that trigger, the Zap will only fire if the information in a row is different, or if you add a new row to the bottom of the sheet.
In terms of tasks, that will depend on how many steps there are in your Zap. Each new or update row will trigger the Zap, you can see how many tasks a Zap uses each time it’s triggered in the task history. You can learn more about what counts as a task in this help guide.