Best answer

Google sheet export to update contacts

  • 1 April 2020
  • 1 reply
  • 103 views

I’ve think i have a similar problem. My question: I have a google sheet export with our customer information from our custom made CRM (kinda oldskool)  Its got 260 columns and about a 1500 rows.  I want to update my contacts in Active campaign if anything changes in our CRM. 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! 

Cheers,

Milko

Amsterdam

 

icon

Best answer by Danvers 23 April 2020, 14:56

Hi @MFR! I’m sorry for the delay in getting back to you on this one!

 

If you don’t need the Zap to trigger on those 1500 rows, then yes the best thing to do is to turn the Zap off and then on again.  If you don’t want to have to open Zapier to do that, there is an app called ‘Zapier Manager’ and one of the actions for that is Turn Zap On/Off’. So you could set a Zap using a simple trigger (like Push by Zapier) that will let you turn the Zap off while you make that big change to sheet and then back on again when you’re done. 

 

​I hope that helps, please let me know if you have any questions!

View original

This topic has been closed for comments

1 reply

Userlevel 7
Badge +11

Hi @MFR! I’m sorry for the delay in getting back to you on this one!

 

If you don’t need the Zap to trigger on those 1500 rows, then yes the best thing to do is to turn the Zap off and then on again.  If you don’t want to have to open Zapier to do that, there is an app called ‘Zapier Manager’ and one of the actions for that is Turn Zap On/Off’. So you could set a Zap using a simple trigger (like Push by Zapier) that will let you turn the Zap off while you make that big change to sheet and then back on again when you’re done. 

 

​I hope that helps, please let me know if you have any questions!