When new client information is collected (via form submission/email) into Airtable, I want Mailchimp to trigger an email to a very specific audience segment, including detailed information that was pulled in from the airtable form. Is this possible? Here is more context:
There’s a talent agency that works with both famous people (like Beyonce) as well as Brands (like Pepsi). Their day to day typically involves collecting personal information from their famous clients (like how Beyonce drinks Pepsi, or the food she gives her dog, favorite shoes, etc.) and then making an email pitch out to those respective brands with the end goal of getting their famous clients sponsorship deals with brands they actually like.
Currently, they send an email/form out to their famous clients collecting all of this information, where it is then stored in a lengthy airtable spreadsheet. They manually comb through that information looking for any crossover with brands, to then reach out and make a pitch via mailchimp email. All of the contact details for the brands they have relationships with are stored in a 2nd tab within airtable.
My initial thought is, with or without a Zapier integration they could create several micro segments within mailchimp to represent the various contacts at the Brands they work with. However, would they also be able to generate an automatic email trigger with custom populated fields to make a pitch out to those segments?
i.e. Hi (insert contact at pepsi), we represent (insert famous person who filled out form) and wanted to reach out because she (loves to drink pepsi- detail pulled from form). etc etc.
Please let me know!! This organization loves how easy airtable is and they do not want to implement a more robust CRM like Salesforce, etc. Could Zapier possible solve all of their problems with a bit of upfront lifting? thanks!
Best answer by Troy Tessalone
View original
