How to send email to an entire coloumn on another sheet if some conditions met via zapier or make?

[FIRAT_BAYRAM_BA]

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

1. Lead form requests
2. Vendors with their info

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.

[Mohamed_Swella1]

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.

[FIRAT_BAYRAM_BA]

Thanks for the reply.

Currently I am doing this but don’t know how to filter by country.

[Mohamed_Swella1]

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

[ScottWorld]

@FIRAT_BAYRAM_BAKIR

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.

[FIRAT_BAYRAM_BA]

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

[ScottWorld]

You need to put {curly brackets} around your field name, not (parentheses).

[FIRAT_BAYRAM_BA]

Tried that as well =(

[ScottWorld]

Post a screenshot of the error you’re getting.

[FIRAT_BAYRAM_BA]

Sure!