TypeScript Code

link - learn.microsoft.com/en-us/office/dev/add-ins/excel/excel-add-ins-comments

The script extracts employee information from the employee worksheet.
The script then adds a comment (including the relevant employee email) to the appropriate cell in the shift record.
Existing comments in the cell are removed before adding the new comment.

function main(workbook: ExcelScript.Workbook) { 
  const employees = workbook.getWorksheet('Employees').getUsedRange().getTexts();  
  console.log(employees); 
  
  // Get the schedule information from the schedule table. 
  const scheduleSheet = workbook.getWorksheet('Schedule');  
  const table = scheduleSheet.getTables()[0]; 
  const range = table.getRangeBetweenHeaderAndTotal(); 
  const scheduleData = range.getTexts(); 

  // Look through the schedule for a matching employee. 
  for (let i = 0; i < scheduleData.length; i++) { 
    let employeeId = scheduleData[i][3]; 

    // Compare the employee ID in the schedule against the employee information table. 
    let employeeInfo = employees.find(employeeRow => employeeRow[0] === employeeId); 
    if (employeeInfo) { 
      console.log("Found a match " + employeeInfo); 
      let adminNotes = scheduleData[i][4]; 

      // Look for and delete old comments, so we avoid conflicts. 
      let comment = workbook.getCommentByCell(range.getCell(i, 5)); 
      if (comment) { 
        comment.delete(); 
      } 

      // Add a comment using the admin notes as the text. 
      workbook.addComment(range.getCell(i,5), { 
        mentions: [{ 
          email: employeeInfo[1], 
          id: 0, // This ID maps this mention to the `id=0` text in the comment. 
          name: employeeInfo[2] 
        }], 
        richContent: `<at id=\"0\">${employeeInfo[2]}</at> ${adminNotes}` 
      }, ExcelScript.ContentType.mention);        
      
    } else { 
      console.log("No match for: " + employeeId); 
    } 
  } 
}