It is pretty simple i belive but for what ever reason it is not working, well, i have the sheet that has a list of vehicels and their license exparation date, then i have a ROW that deducts that date with todays date and it is telling me how much days there is until the registration end, and all i want to do is that when a number comes under 15 (days) i need to send an email to my company email alerting us that registration for that vehicle is coming to an end
Best answer
How to make Zapier send an email if value in row drops below number X?
- Beginner
Best answer by SamB
Hi there,
From your screenshot of the selected test record it looks as though the Row Number in the selected test record is 436. I couldn’t see row 436 pictured in your previous screenshots though. Can you take a look in the spreadsheet and confirm whether row 436 definitely has a value in column H (Registration Countdown)?
If it doesn’t, then you may want to try pulling in a new test record sample for a different row to double-check that the Zap is able to see the registration countdown value when there is one present in the row.
Looking forward to hearing from you on this!
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
+14- Zapier Orchestrator & Solution Partner
Hi
Try adding a Filter as step 2 in the Zap: https://zapier.com/apps/filter/help
+14- Zapier Orchestrator & Solution Partner
Alternatively you can use Airtable.
Airtable has Views, which are segments of data.
You can create a View that has Filter conditions.
Views can be used to trigger Zaps.
Also, Airtable has native automations.
Airtable Automations have a native integration with Gmail.
- Beginner
I am very new with all this and now it even more complicated to me.. haha sorry, can you be more specific if i may ask
- Beginner
Hi
Try adding a Filter as step 2 in the Zap: https://zapier.com/apps/filter/help
i tried this but i reach to this problem:
+14- Zapier Orchestrator & Solution Partner
The Filter step warning is indicating the Filter would not have passed because the mapped variable value has no data, so the Filter condition was not met.
Post screenshots of the Zap trigger example you are using that shows the Row/ID.
Check that Row/ID in GSheets to see if that column has data.
- Beginner
ok im sending you this to prove that sheet is full
and another picture to how you what type of formula is used to get that number:
+14- Zapier Orchestrator & Solution Partner
Post screenshots of the Zap trigger Step 1 example you are using that shows the Row/ID.
+14- Zapier Orchestrator & Solution Partner
The Zap trigger example will be shown in the “Test” section of Step 1.
+11- Community Manager
- Answer
Hi there,
From your screenshot of the selected test record it looks as though the Row Number in the selected test record is 436. I couldn’t see row 436 pictured in your previous screenshots though. Can you take a look in the spreadsheet and confirm whether row 436 definitely has a value in column H (Registration Countdown)?
If it doesn’t, then you may want to try pulling in a new test record sample for a different row to double-check that the Zap is able to see the registration countdown value when there is one present in the row.
Looking forward to hearing from you on this!
- Beginner
Thank you!! it is working now, i just added a number to the latest row and i got checked marks
now i need to buy premium zapier to make it work hehe
Thank you everybody for the help
+11- Community Manager
Yay! I’m so glad to hear it’s working now
Ah yes, with multi-step Zaps you’d need a paid Zapier plan. That said, it may be helpful to know that with paid Zapier plans tasks for apps like Filter don’t count towards your task usage. 🙂
Please do reach out in the Community again if there’s anything else we can help with. In the meantime, happy Zapping!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.