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.
Event Calender Time Set in Code Different than Time Zone Setting in Spreadsheet
Cannot create an all day event series into google calendar, from google forms
Google App Script: “getId()” method fails
APP script times out after 6 mins
Is it possible to create a sparkline using apps script and not built in function?
How do you subtract two time values in military format in google apps scripts for a spreadsheet?
How do I write data from a google spreadsheet into a time input field in a templated html file
Multiple File Upload Google Apps Script
HTMLService forms and responses
How do I query update a spreadsheet without using Visualization API, Bigquery or Google Cloud Database?
Google script to remove duplicate rows in spreadsheet and keep the most recent entry based on timestamp
Google Sheet update data from my server
Document ContainerElement metadata / id
How to use google url shortner api by UrlFetchApp.fetch correctly?
Google Forms - Trigger email to send all columns in google spreadsheet upon form submission
Google Sheets Displaying cell data in sidebar