My time-based automated workflow is not emailing contacts

Katie Lafferty

I created sheet and added 3 columns:

1. Date Last Inspection
2. Inspection Cycle (dropdown: Annual, Bi-Annual, Monthly)
3. Contact Email (inspections)

I setup an Automation "Notify Contact Inspection is Due (Annual)"

1. Trigger 365 days after a date on 'Date Last Inspection'
2. Condition 'Inspection Cycle' is one of: Annual
3. Alert someone: Send to contacts in a cell" Contact Email (Inspections)

When I back-date the Date column for 365 days ago and save, it doesn't email the contact.

Note: My Notifications under personal setting is checked to include my changes & Automation settings is 'Unrestricted'

Paul Newcome

Did you set the date to "tomorrow" and then wait until a little after 8:00am to see if it went through? It would not trigger as soon as you change the date.

Katie Lafferty

i set the trigger date to be over a year ago (more than 365 days) & saved it 2 days ago, thinking email would eventually come, and it never did.

Paul Newcome

Try setting it up so that it is a daily trigger and the condition is where the date is 365 days in the past.

Katie Lafferty

It worked. created another condition, as you said, where 'Date Last Inspection' is not in the last (days): 365

It was set at a Weekly trigger but i changed to Daily. Thank you Paul :)

Paul Newcome

Happy to help. 👍️