How can I email to someone (not gmail) when I get comments in Google Spreadsheet?
I made a Google Spreadsheet which has several different sheets assigned to different people. I'm trying to send a notification email to a person when he has a comment in his sheet. For example, when someone make a comment on Jake's spreadsheet, Jake will get an email saying he got a comment. I tried to use "onEdit" to detect comment action, but onEdit cannot detect it. So, I tried to use Drive.Comments.list, but it didn't work well either. When I tried to test Drive.Comments.list in script editor, it works fine. But, when I tried to use it via spreadsheet, that throw me an error which is "Daily Limit for Unauthenticated Use Exceeded. Continued use requires signup." I have enabled Drive API among advanced google service and google console. I have no idea what's wrong here. Can anyone help me? Is there any way to detect comment action? or can anybody help me to use Drive.Comments.list properly?
Sorry to bear bad news, but there is no way to use the onEdit trigger to get comment data unless I am missing something in the documentation. The only methods I can find is getNote() and getNotes(): https://developers.google.com/apps-script/reference/spreadsheet/range#getnote Those will only help you get notes from the cells and not the comments. You could setup a timed trigger to check for notes and email those, however, like I said, this doesn't solve your problem about getting comment data.
Create a native filter in Gmail using Google Apps Script
Send a full formatted mail with google apps script
Add image files (or other resources) to project?
How do you reset a numbered list on Google Doc?
Functions work from menu or manually run - but not using Google Time Event
How do I reauthorize my account
How to access the appDataFolder with the DriveApp or the Drive Service of app script?
Row locking function in Google spreadsheet
Google Sheets - Email Specific Range With Formatting
Lock a single sheet per spreadsheet in a folder full of spreadsheets
New Line as Delimiter
Google Sheets Go to Today button
Google apps script - “File xyz.csv exceeds the maximum file size.”
Fill multiple rows in google spreadsheet via google script
Fetchin webapp from script fails to login
Delete Project in Google Spreadsheet Script Editor