About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

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

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

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.

Question

How do I tell a Zapier loop to send message only once to a user?

  • 6 March 2024
  • 1 reply
  • 45 views
M

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.

 

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

1 reply

Troy Tessalone
Userlevel 7
Badge +14

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.

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
Terms & Conditions