Add comments to Excel cell with at-mention of a contact.
Example scenario:
- Team lead maintains shift schedule information. Team lead assigns employee ID to shift record.
- Team lead wishes to send send email reminder by adding a comment with @mention of the employee by cross referencing the employee email address along with a custom message from the sheet.
- Employee can then address/respond to the comment.
- Office Script that extracts employee information from the employee sheet.
- The script then cross references the shift record and adds comment to the appropriate cell by including relevant employee email, team lead comment.
- It also removes any existing comment before adding new comment.
Download the input Excel file used in this sample and try it out yourself!
This is the input Excel file being used.