Help

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

853 1
cancel
Showing results for 
Search instead for 
Did you mean: 
FIRAT_BAYRAM_BA
5 - Automation Enthusiast
5 - Automation Enthusiast

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.

10 Replies 10

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

You can use the Search Records and input something like that in the formula

Screen Shot 2022-08-23 at 4.29.33 PM

@ScottWorld would be much better at this though as he works more with Make.com. I use Zapier.com usually

@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:
image

This is the Vendor airtable:
image

and lastly, this is the search formula:
image

Any input is appreciated

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

Tried that as well =(
image

Post a screenshot of the error you’re getting.

Sure!
image

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