Is there a way to configure Data-Explorer to run specified queries and email the result sets to an email list on a regular schedule?
AI-generated summary
The discussion revolves around the possibility of configuring Data-Explorer to send automated emails with query results to an email list on a regular schedule. Initially, JammyDodger believed this was not possible, but later discovered that it can be achieved using the ‘Schedule a PM with Data Explorer results’ automation, which allows sending a PM that can also trigger an email notification. Additionally, an email can be set as the recipient directly.
JammyDodger provided instructions on how to set this up, including granting group access to the report and configuring the automation. However, the email format is a simple list, which may not meet all requirements.
simon suggested a feature to apply bulk actions to Data Explorer results, which could include sending a PM, adding/removing from a group, granting badges, or other options. JammyDodger also found a related feature request to include query results as a CSV attachment in automated emails.
Sorry for the much delayed response. Unfortunately, I don’t believe that’s possible currently, though I’ll slide this over to Contribute > Feature for consideration. 
Could the feature be the ability to apply bulk actions to Data Explorer results, similar to the way admins can apply bulk actions to a topic list? The options for queries that return users could be things like:
- send a PM
- add to group
- remove from group
- grant badge
These are tasks that can be performed now by copying the results of a query into a PM’s recipient input, or a group’s Add to Group form, or by downloading a query’s results as a CSV file and uploading the CSV file to the Badge bulk award form. Being able to perform the actions directly on the query results would streamline things a bit.
For queries that return topics, the options could be similar to what’s available now in the topic bulk actions modal.
Possibly I’m getting too far away from what the OP is asking for here.
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:
I also found this Contribute > Feature request for including the results as a CSV attachment too: