Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

  • Home
  • Get Help
  • How Do I
  • How do I prevent duplicate Zaps in Google Sheets to Gmail and ensure email lookup for updated rows?

Hi, i have a working zap for gsheets-gmail, whenever a row is updated. I constantly get a bunch of zaps by mistake when the sheet is sorted, organized etc.. (seperate post)

I was thinking it would do email lookup to help with the tons of emails and confusion on which was the latest info. 

But, when i do that, it wasnt finding the email. 

 

I use my googlesheets account, but when the email is generated, its coming from a differnt email (instead of mine otherwise it was going straight to inbox). but, still, its not looking for a previous email with same subject line and just creates a new email instead (after i clicked that option). 

What am i doing wrong?

Hi @danielle879235 

For us to have more context, post screenshots with how your Zap steps are outlined and configured in EDIT mode.

Now, looking closer, is it because i want it to to find a subject line that keeps changing? The email subject should read “Route XXX driver has changed to (name of the driver)” Since the initial goal of the zap is to alert us if there a driver change, all the words up until to” will stay constant and only the driver name should change. Is that why it wont trigger a zap? Would the info need to be in the body of the email rather than the subject?

 

@danielle879235 

For GSheets to be used in Zaps, they must be configured as a flat file.

  • Row 1 with Headers.
  • Value in Cell A1.
  • No hidden rows/columns
  • No grouped rows/columns
  • No gap rows/columns

 

NOTE: Zap trigger being used will trigger for NEW rows AND for UPDATED rows.

You may want to add a Filter as Step 2 to only have the Zap continue if certain row cell values match conditions.

 

The Zap action in Step 2 being used will FIND an existing Gmail email OR Send a new Gmail email IF NO existing Gmail email is found for the search criteria. (not sure if that’s your desired logic)

 

In your screenshots, the mapped variables in Step 2 from Step 1 have a value of “No Data”.

Check to make sure the selected Zap trigger step example record selected has values for those column cells.

 

Terms & Conditions