Best answer

How to update MailChimp List based on State

  • 4 February 2022
  • 2 replies
  • 25 views

Badge

Hello Zappers-

 

Here’s my scneario and I’d be interested in how you would approach.

-I will need to create 51 Zaps representing states

-Salesfroce > Zap Filer Looking for state > to MailChimp

-Each updating a MailChimp list based upon the state

 

My concerns:

-Will each of the 51 zaps pull fetch the full salesForce database with each run? There are over 100,000 records comprising the various state
-Is there a better way to do this?

 

Many thanks for your thoughts.


 

icon

Best answer by Troy Tessalone 4 February 2022, 23:03

View original

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

2 replies

Badge

Many Thanks @Troy Tessalone 

Userlevel 7
Badge +14

Hi @justSeth 

Consider using Lookup Tables to make 1 dynamic Zap:

https://zapier.com/help/create/format/create-lookup-tables-in-zaps

 

TIP: May be better to use GSheets or an Airtable Base as the lookup  table rather than the Formatter > Utilities > Lookup Table.

 

-Will each of the 51 zaps pull fetch the full salesForce database with each run? There are over 100,000 records comprising the various state

No.

Most Zap app triggers/actions work on a per record basis.

NOTE: Zaps only work when turned ON for new data going forward.

Check out the available Zap triggers for Salesforce: https://zapier.com/apps/salesforce/integrations#triggers-and-actions