Aug 23, 2022 05:19 AM
How to send individual emails to an entire column on another sheet if some conditions are met via Zapier or Make?
I want to match requests with my vendor’s location and only send emails to people who match with the requested country.
I have two sheets
When Lead submits a form, it is transferred to the airtable Lead requests table.
When a new request is submitted, I want to match their location with my vendors and only send emails to those vendors on the Vendors table. Via any platform.
Aug 23, 2022 06:26 AM
Hi @FIRAT_BAYRAM_BAKIR ,
Welcome to Airtable Community !
This can be done very easily.
I would however make sure the country is not a single text field, i.e.: they cannot change the capitalization.
Second, using Zapier newly added Line Items support you can search for the country in the vendors table and send emails using Loop in Zapier.
Aug 23, 2022 07:11 AM
Thanks for the reply.
Currently I am doing this but don’t know how to filter by country.
Aug 23, 2022 07:30 AM
You can use the Search Records and input something like that in the formula
@ScottWorld would be much better at this though as he works more with Make.com. I use Zapier.com usually
Aug 23, 2022 08:24 AM
For your “Search Records” step, you would just use a normal Airtable formula, but be sure to insert the value from the first module in quotation marks to compare to your Airtable field. Something like this:
{Your Country Field}="🟦🟦🟦"
Replace the blue boxes with your desired value from the first module.
Aug 23, 2022 08:40 AM
Hey Scott!
Thanks for the reply.
I am getting an error= The operation failed with an error. The formula for filtering records is invalid: Invalid formula. Please check your formula text.
This is the requests:
This is the Vendor airtable:
and lastly, this is the search formula:
Any input is appreciated
Aug 23, 2022 08:43 AM
You need to put {curly brackets} around your field name, not (parentheses).
Aug 23, 2022 08:46 AM
Tried that as well =(
Aug 23, 2022 08:50 AM
Post a screenshot of the error you’re getting.
Aug 23, 2022 08:56 AM
Sure!