Skip to main content
Question

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

  • 19 September 2023
  • 5 replies
  • 49 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?

@danielle879235 

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


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

 


@danielle879235 

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

 


I dont have the option for lookup spreadsheet row


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