Skip to main content
  • Home
  • Get Help
  • How Do I
  • How do I create a trigger in Google Sheets to send an email based on matching names from two different sheets?
Question

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

  • 6 November 2023
  • 2 replies
  • 20 views

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

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

2 replies

Troy Tessalone
Userlevel 7
Badge +14

Hi @YairSabag 

Good question.

Try adding this Zap action: GSheets - Lookup Row

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
shalgrim
Userlevel 6
Badge +8

This will be at least a three step Zap:

  1. Google Sheets Trigger - New Spreadsheet Row
  2. 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
  3. Email integration - Send Email

Let us know if you have more questions!

Terms & Conditions