Automation/Workflow from sheet summary fields

Bek T

We're setting up a training register and as there is no auto-cut-off option for a certain date with Forms (as yet) our work-around is to set up an automation. This will be based on when a certain number of submissions have been reached, that alert will be pinged to the person managing registrations, as a trigger to them to close off the form.

Instead of adding an additional column to the sheet for the count formula, it would be great if the automation could be triggered from the sheet summary fields (as these also contain formula calculations used for reports and dashboards) and would save additional work of additional columns, etc.

I know there's another post on auto-cut off of forms once a date is reached, but bonus if you can deliver that also!