Question

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

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.

+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

⚡ Troy Tessalone - AutomationAce.com | Platinum Zapier Solution Partner | #1 Zapier Community Contributor

I dont have the option for lookup spreadsheet row

+14

@danielle879235

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

⚡ Troy Tessalone - AutomationAce.com | Platinum Zapier Solution Partner | #1 Zapier Community Contributor

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

+14

@danielle879235

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

⚡ Troy Tessalone - AutomationAce.com | Platinum Zapier Solution Partner | #1 Zapier Community Contributor

Sign up