Automate sending out a PDF based on meeting criteria

I'd like to automate the generation of a PDF of a sheet or report based on criteria defined in an Automate Workflow. This doesn't appear possible.

For example, send out a PDF when a cell containing a date changes, or a completion percentage is modified, a comment is made, an attachment attached, etc..

I'm well-versed in sending out alerts for these events, but many of our users aren't all that comfortable with even the simple task of clicking on an embedded link to a report to view the updates online.

Anything? Thanks in advance.