google-apps-script


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.

Related Links

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

Categories

HOME
tensorflow
ibm-watson-cognitive
crate
amazon-swf
scipy
firebase-app-indexing
vs-team-services
wms
mainframe
azureservicebus
hyperledger-fabric
xcode8.3
netflix-feign
deeplearning4j
ipfs
xlsx
finite-group-theory
line-api
multiple-monitors
titan
scaling
scenebuilder
propel2
device-detection
shippo
jquery-scrollify
searchbar
rhmap
partial-application
autofill
piecewise
outsystems
stocks
von-neumann
rider
mms
npm-publish
poco-libraries
haskell-pipes
lexical-analysis
dojox.mobile
finite-element-analysis
scalafx
estimation
jtds
chunked-encoding
tiddlywiki
spell-checking
text-classification
in-memory-database
gradle-script-kotlin
easing
pydio
mongoose-populate
cron-task
tuxedo
picking
search-regex
galaxy
ninject.web.mvc
response-headers
paypal-nvp
mogrify
team-build
httpie
code-first-migrations
chaining
pisa
proximity
named-ranges
libsndfile
microblaze
sortable
ghostdoc
mov
bsp
indexing-service
sanitization
magicalrecord-2.2
facebook-sdk-3.1
dllexport
multiple-login
mstsc
resgen
soa-suite
fieldset
template-haskell
cgpath
feof
cadisplaylink
hobo
hashalgorithm
selectmanycheckbox
tcxgrid
printing-web-page
testunit
collect
pureftpd
camtasia
trampolines
opcodes
data-execution-prevention
divx

Resources

Mobile Apps Dev
Database Users
javascript
java
csharp
php
android
MS Developer
developer works
python
ios
c
html
jquery
RDBMS discuss
Cloud Virtualization
Database Dev&Adm
javascript
java
csharp
php
python
android
jquery
ruby
ios
html
Mobile App
Mobile App
Mobile App