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.
Bad performance displaying table chart in google script
Increasing performance on a 90+ seconds google apps script
Google Apps Script Listbox Behavior with setId()?
Get child index of findtext in google API script
Click Handler has suddenly stopped working
Google apps script - Folder as a script container
GMailApp Script: Override default search behavior
How to write data from spreadsheet to a Document?
Hiding columns script returns “Those columns are out of bounds.”
sheet.appendrow in adwords scripts is appending too many lines
Google Apps Script - Share widgets between functions
Print a spreadsheet with IMAGE formula
BigQuery with Google Spreadsheet error 'Required parameter is missing'
Google Spreadsheet; script to automatically change specific text on cell entry
DriveApp .addViewer() .addEditor() internal folder files not inheriting permissions