Question

How do I trigger an alert if a duplicate name exists in two Google Sheets tabs?

  • 19 September 2023
  • 5 replies
  • 45 views

Hi, 

How do i set up a zap to trigger an alert if there is a duplicate name in one cell on tab 1 with another cell in tab 2 on google sheets?


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

5 replies

Userlevel 7
Badge +14

Hi @danielle879235 

Good question.

That depends on the type of alert. (e.g. email, sms, etc.)

Try using this Zap action: GSheets - Lookup Row

Followed by a Filter step: https://zapier.com/apps/filter/help

 

I dont have the option for lookup spreadsheet row

Userlevel 7
Badge +14

@danielle879235 

That is an action step as indicated by “Action” on the screenshot.

 

amazing. found it. now what lol. how do i fill in these 

 

Userlevel 7
Badge +14

@danielle879235 

Might be worthwhile to review the available help articles for using GSheets in Zaps: https://zapier.com/apps/google-sheets/help