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.

I have built  the following Zap

 

Description of Zap:

I have Google Sheet table. This table has columns.

One column is called “Due Date” another column is called “Returned”

Everyday at 8AM: IF Due Date is before today AND IF Returned = No, then I want the Zap to send me a single email notification.

I built the Zap and it works great, the issue is that I keep adding more rows everyday, and as I add rows I get more notifications. I want to limit the notification to 1 notification per row. So if I got one email today about Row#2, I do not want to get also tomorrow the notification about Row#2 again..

 

Here is how I built it:

 

  1. Scheduled to work everyday at 8AM excluding weekends
  2. Get Many Speadsheet Rows (Google Sheet)
  3. Create a Loop from Line Item in Looping by Zapier
  4. FIlter → Only continue if date is older then x
  5. Send an email notification to myself (Gmail)

Now what happens is that everyday at 8AM I get the same emails from yesterday + the new emails from today.

I would like to know how can I limit the Zap to only send me 1 notification per Row. So I do not receive duplicate notifications every day for the same row I was already notified about in previous days.

 

Any suggestions?

 

Thanks in advance.

 

Hi @MagicPay 

Add another step to update the GSheet Row to indicate you’ve already sent an email about it.

Then adjust your Filter Step 4 to exclude those rows.

Terms & Conditions