I have a Google sheet that I share with many collaborators who have "Commenter" privileges. They are notified only if a comment is mentioned with the "@their email" symbol unless they go and change that from "Notification Settings" to receive "All comments". Is there a way to create a script that will send to all commenters all comments written inside the Google sheet?
In this case, what values do you want to send as an email?
If you write a comment in Google Sheets the owner of the Excel file is receiving that information that shows in my picture inside the post. I want the same thing with the script.
That is:
The name of the commenter,
The file name,
The cell title,
The comment, and
the option to reply or to open the Google sheet in the cell with the comment. fileId: string - The ID of the file. commented: string - The ID of the comment.