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

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.

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.

Thanks for the reply.

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

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

1 Like

@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.

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

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

Tried that as well =(

Post a screenshot of the error you’re getting.

Sure!

If you are sure of the table and base, then I would assume the field name has a space or something in the end. Try copy pasting the name

2 Likes