Parse an excel which we receive via email

[Qamrain Peerzad]

if I have to parse an excel sheet which we we receive via email that email will end up  in sys_email table and its attachment will reside in sys_attachment table. The Excel contains details about terminated users and that users need to be removed from multiple groups how can i achieve that. i have added the format of excel screenshot for reference. 

[Ankur Bawiskar]

@Qamrain Peerzad 

you can use ExcelParser API for this and iterate over each row and then query and deactivate the user

check below links

GlideExcelParser - Scoped, Global 

How to populate Manager field(reference type) and effective date from excel sheet when using Glide E... 

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏