How to send notification dynamically based on the assignment group

[Chandra31]

Hello Everyone,

I'm looking for guidance on how to dynamically send notifications based on the assignment group listed in an Excel sheet(generated by report).

For example, the Excel sheet(generated by a scheduled report) has a list of incidents each managed by different groups. Our goal is to send targeted notifications to these groups DL, specifically concerning the incidents they manage. 

Could you provide guidance on how to accomplish this?

Regards,

Chandra

[Mark Manders]

You are on the ServiceNow community and are asking how to send notifications from Excel? 

If this is ServiceNow related, please elaborate on what your business requirement is (since sending emails to groups is straightforward notification functionality).

[Chandra31]

@Mark Manders  I've updated the post.

[Mark Manders]

You either need to create separate reports and schedule them for the group on the report (sinde the report will contain all group's tickets,

Or create an overview in table form through an email client script and trigger it through an event in a scheduled job (or create the table and email completely in the scheduled job). 

A scheduled report does not have the ability to read the content of the attached excel and base it's conditions to send it to groups there.

Best thing, although in most companies a Utopia, is to just create a dashboard with the data and send links to that dashboard. Let people use the system and view real time data.