How do I create a trigger in Google Sheets to send an email based on matching names from two different sheets?

Hello, i know its sound easy but its not( for me anyway ).

I need Trigger ike that: when there is a new row he will take the Name for it and will find this specific name in a different sheet and will take the email adresse for the name row and will send him a mail (this part i know).

Thanks.

Explaine:

i have 2 google sheets:

1.get data from Form.

2.sheets that i have the names and the emails.

so what i want is, when i get new row on the First Sheet he will get the the name and look at the Second Sheet and find the Name Email and will send him an Email

Page 1 / 1

Hi @YairSabag

Good question.

Try adding this Zap action: GSheets - Lookup Row

This will be at least a three step Zap:

Google Sheets Trigger - New Spreadsheet Row
Google Sheets Search - Find or Create Row - Take the info from step 1 and look for it in the different sheet, which you can specify in this step
Email integration - Send Email

Let us know if you have more questions!

Useful links

Code of conduct

Using the Community

Community expectations

Useful links

Code of conduct

Using the Community

Community expectations

Sign up

Use your Zapier credentials

Log in to the Community

Use your Zapier credentials

Scanning file for viruses.

This file cannot be downloaded