Email sent when records are in a view at a set time

Topic Labels: Automations
1015 2
Showing results for 
Search instead for 
Did you mean: 
5 - Automation Enthusiast
5 - Automation Enthusiast

Hello community!

I am trying to create an automation that will send an email out every 14 days only if there are records in a specific view. The use case for this would be to email functional leaders every pay week if they have expense reports to approve for their team. I only want them to get an email if they have expenses to approve. If their view is empty, I don’t want an email to be sent. Thanks for your help!

2 Replies 2

Set up an Automation that triggers every 14 days (“At scheduled time”)

Add a Find Records step that looks at your view. Note: Find Records has a limit of 100 records, if there are more than 100 records not all will appear in the email.

Conditional Actions:
Set your condition to only run if the length of the Find Records is greater than zero.

Add a send email step (regular, Gmail, or Outlook) and insert content from the Find Records Step in the Body.

5 - Automation Enthusiast
5 - Automation Enthusiast

This was perfect, thank you so much!