Request an Update Works Sporadically

I have a sheet where I have 18 different school site managers set to receive Request an Update emails when a new row with certain criteria is created. I essentially made one automation and then copied it 17 more times, changing the school name and the email recipient.

The automation only works randomly and I can't figure out why. On some days, everyone receives a message, and on others only some receive it.

We have a person manually entering each row. She does up to 50-60 entries per day. An intake form will have several names on it. Each person gets their own row. She will add all of the rows for the names on a form and upload split copies of the forms to the sheet in their respective rows. I have a filter set up and every few days I go in and manually send out the filtered names without update requests.

I have verified email accounts are correct, their settings are correct, the automation permissions are set to unrestricted. Site managers who have received both the automated and the manual email requests are responding and updating with no issues.

Any ideas on how to solve this would be greatly appreciated!


Screen Shot 2022-05-31 at 16.04.31.png Screen Shot 2022-05-31 at 15.04.28.png


Answers