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

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?

Categories

HOME
xbox-live
jenkins-plugins
vb6
amazon-swf
textwatcher
actionscript
laravel-5.2
is-empty
histogrammar
schemacrawler
netflix-feign
hosts
window
cartodb
uiscrollview
sign
cloudflare
pyyaml
jive
shippo
nmake
cruisecontrol.net
header-files
jenkins-job-dsl
system.data.sqlite
reply
autofill
helix-3d-toolkit
spring-profiles
modulo
recurrence-relation
von-neumann
initializer
cgo
dart-pub
web-development-server
jrules
stereo-3d
finite-element-analysis
python-idle
openh264
etherpad
paas
search-box
castle-dynamicproxy
date-range
sqlexception
efxclipse
atlassian-crowd
libtiff.net
coremidi
cron-task
gherkin
remoteapp
gradle-release-plugin
cmocka
optionbutton
code-readability
app.xaml
twitter-rest-api
word-2013
google-earth-plugin
client-side-validation
java-melody
dalekjs
power-law
aquafold
lumx
sanitization
ftp4j
threadx
xslkey
dynamic-data
marmalade-edk
osi
scrollto
expression-evaluation
ubuntu-11.04
nssavepanel
cross-domain-policy
datamember
ruby-debug
rijndael
multibyte-functions
filetime
web-statistics
usability-testing
revision
dirty-data
usergroups

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