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.
Google script Can't get SheetID to return value
Google Apps script - change the background color of a cell with a hex value from another cell
How to get element ID in UiApp
Iterators built with different continuation tokens are producing the same results in Google Apps
addTimer not working with global app in GAS
Google Sheet: Update item in Add-on Menu
Uninstalling UserPassChange script
Google apps script: Create a new document and send it using Gmail
google apps script table We're sorry, a server error occurred. Please wait a bit and try again
Google Spreadsheet: How To Counting Rows with specific date
Google script won't ask for authorization unless it is run in the script editor
how to speedup several hundred calls DriveApp.getFolderById(id)
Is there a way to disable custom function in Google SpreadSheet Via Google Apps Script
onOpen trigger not being activated on Google Form
Testing whether a gmail user has previously communicated with a given email
How do I get Google Apps Script to open an external webpage and click on a button from that page?