Can we send an EXCEL sheet with Assessments through Email and get responses in Excel for TPRM Assess

[PANKAJ MAHTO1]

Hi Team,

I hope this message finds you well. We have a unique requirement in our TPRM process, and I'm exploring the possibility of building a custom functionality to streamline the assessment workflow. Here's an outline of the proposed solution:

1. Assessment Creation:

   • Assessments will be created in ServiceNow, similar to our current process.
   • However, the assessments will be attached as Excel files, providing a convenient format for vendors.

2. Email Communication:

   • The Excel file will be automatically attached to the assessment notification sent to the Vendor Manager via email.
   • The Vendor Manager can review the Excel file and respond to the assessment questions directly within the Excel sheet.

3. Response Integration:

   • Upon receiving the response Excel file through email, we'll implement an integration mechanism to automatically process and update the assessment in ServiceNow.
   • The system will extract relevant data from the Excel file, calculate Vendor Risk, and update the assessment accordingly.

4. Lifecycle Considerations:

   • To maintain visibility and consistency, a snapshot of the Excel file and email communication will be stored within the ServiceNow record.
   • The regular assessment lifecycle within ServiceNow will not be affected by this custom process.

Please Suggest and Guide How we can Implement this OR Can Suggest any Better way to Build this TPRM Application in SERVICE NOW.