Actually… I may have panicked a little and got my facts wrong.
I think it is possible to do this using the ‘Schedule a PM with Data Explorer results’ automation. This will send a PM, which (depending on your ‘Email me when I am sent a personal message’ preferences) will also send out an email.
You can also set an email as the recipient directly too. 
You would need to give that group access to the report first from the query so they’re authorised to receive it:
They’re simple lists though, so may not be quite what you’re looking for:
