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
- Lead form requests
- 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.