UPDATE: FOUND ISSUE - No changes to automation, but receiving some emails but not all

Oliver Berning

UPDATE: We had two conditions, one that would send an email based upon a column being 'Yes' another that would send an email based upon the column being 'No' - however, I didn't account for the fact that we would sometimes skip over the question, so the column would be blank. I've updated the automation to include 'Blank' along with the 'No' response in the column.

We are running into a situation where the automation on a sheet hasn't changed at all, but the email that should be receiving the notification is receiving some emails, but not all emails. It should be triggering every time a new row is added and we know it works because they received an email this morning with a new row item, but it hasn't worked a few other times. Any ideas on why this might be happening? I hoped to find the automations in the audit log, but it sounds like the automations are not being recorded in the log.

Thank you in advance!

Michelle Choate 2

I am going to put your answer down here so you can considered this question answered and it will stop showing up in the unanswered questions:

Fix was to guarantee that all conditions were being met for the automation. Conditions could be "Yes", "No", and "Blank" and the automation did not have a pathway for "Blank."

Michelle Choate 2

I am going to put your answer down here so you can considered this question answered and it will stop showing up in the unanswered questions:

Fix was to guarantee that all conditions were being met for the automation. Conditions could be "Yes", "No", and "Blank" and the automation did not have a pathway for "Blank."

Oliver Berning

Thanks, @Michelle Choate 2!