# Data-Explorer Automated Emails?

**URL:** https://meta.discourse.org/t/data-explorer-automated-emails/259597
**Category:** Support
**Tags:** email, data-explorer, automation
**Created:** [March 27, 2023, 6:08pm UTC](https://meta.discourse.org/t/data-explorer-automated-emails/259597 "2023-03-27T18:08:53Z")
**Posts on this page:** 6
**Page:** 1

<div class="post-metadata">

### Author: ![shane\_m](https://avatars.discourse-cdn.com/v4/letter/s/b5e925/32.png) [@shane\_m](https://meta.discourse.org/u/shane_m)
#### Post date: [March 27, 2023, 6:08pm UTC](https://meta.discourse.org/t/data-explorer-automated-emails/259597/1 "2023-03-27T18:08:53Z")

</div>

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?

---

<div class="post-metadata">

### Author: ![JammyDodger](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/jammydodger/32/254611_2.png) [@JammyDodger](https://meta.discourse.org/u/JammyDodger)
#### Post date: [August 13, 2023, 1:21pm UTC](https://meta.discourse.org/t/data-explorer-automated-emails/259597/2 "2023-08-13T13:21:54Z")

</div>

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. 👍

---

<div class="post-metadata">

### Author: ![simon](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/simon/32/339122_2.png) [@simon](https://meta.discourse.org/u/simon)
#### Post date: [August 13, 2023, 1:46pm UTC](https://meta.discourse.org/t/data-explorer-automated-emails/259597/3 "2023-08-13T13:46:05Z")

</div>

Could the feature be the ability to apply bulk actions to [Data Explorer](https://meta.discourse.org/t/32566?silent=true) 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.

---

<div class="post-metadata">

### Author: ![JammyDodger](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/jammydodger/32/254611_2.png) [@JammyDodger](https://meta.discourse.org/u/JammyDodger)
#### Post date: [August 13, 2023, 2:11pm UTC](https://meta.discourse.org/t/data-explorer-automated-emails/259597/4 "2023-08-13T14:11:37Z")

</div>

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](https://meta.discourse.org/t/32566?silent=true) 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.

 ![Schedule a PM with Data Explorer results' automation](https://global.discourse-cdn.com/meta/original/4X/d/e/c/decf43fb03b3ce2743647c4653afae4566109ed9.png)

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:

 ![add group access](https://global.discourse-cdn.com/meta/original/4X/5/c/4/5c49d532eabe62a6e4f561795e934ccaacd5b7ea.png)

They’re simple lists though, so may not be quite what you’re looking for:

 ![email version of the results](https://global.discourse-cdn.com/meta/original/4X/7/5/1/7514dad4d47f0c058539f467fcb7e19ce450939c.png)

---

<div class="post-metadata">

### Author: ![JammyDodger](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/jammydodger/32/254611_2.png) [@JammyDodger](https://meta.discourse.org/u/JammyDodger)
#### Post date: [August 13, 2023, 7:32pm UTC](https://meta.discourse.org/t/data-explorer-automated-emails/259597/5 "2023-08-13T19:32:48Z")

</div>

I also found this #Contribute > Feature request for including the results as a CSV attachment too:

> [@Turn Data Explorer query results into CSV to attach to Discourse automated emails](https://meta.discourse.org/t/turn-data-explorer-query-results-into-csv-to-attach-to-discourse-automated-emails/267529):
>
> Follow up feature request spawned from this [previous thread](https://meta.discourse.org/t/automatically-email-admin-report-csvs-on-a-recurring-cadence/267283/5) With Discourse automation, I’m able to run a [Data Explorer](https://meta.discourse.org/t/32566?silent=true) query on a recurring cadence to pull the values constituting the Trending Search Terms report that can be downloaded as a CSV from the Discourse Admin panel. Running the query through Automation, however, puts the results into the body of the email instead of giving me the option to attach the results as a CSV or JSON file to the email, which is what I’d prefer so I can open t…

---

<div class="post-metadata">

### Author: ![system](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/system/32/443519_2.png) [@system](https://meta.discourse.org/u/system)
#### Post date: [September 12, 2023, 7:33pm UTC](https://meta.discourse.org/t/data-explorer-automated-emails/259597/6 "2023-09-12T19:33:02Z")

</div>

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.
