We receive a CSV file from the Group Portal via email, which is then processed in the ServiceNow

[selvambala]

Need some help for the below requirement.

We receive a CSV file from the Group Portal via email, which is then processed in the ServiceNow system to update the Group Owner field in the sys_user_group table.

The Portal system sends an email to the 'Admin Account' email ID, which is then forwarded to the ServiceNow system.

The sheet within the email contains Group Name, Employee ID, and Owner’s Email ID. Based on either the email or Employee ID, I update the Owner's details. How can I achieve this requirement in ServiceNow?

The sample CSV file will be below format.

[Ankur Bawiskar]

@selvambala 

you said the email is forwarded to ServiceNow system, it means it comes as an inbound email.

So simply get the csv, parse and handle the update in inbound action script

If my response helped please mark it correct and close the thread so that it benefits future readers.

[selvambala]

Thank you for your response. Yes. I'm trying to implement what you suggested, but I'm a bit confused about the script part. The CSV file will have more than 2500 groups. Can you please help in the script part?