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

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
Displaying PopupPanel
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

Categories

HOME
sql-server-2008
plsql
pug
sed
visualization
computer-vision
h2
ios10
propertygrid
tumblr
schemacrawler
websphere-liberty
codeblocks
shader
metronic
data-synchronization
simple-injector
cosmicmind
glpk
android-toolbar
zoomcharts
flexlm
google-maps-android-api-2
apply
fop
compare-and-swap
pipelinedb
osmdroid
skygear
data-extraction
pycparser
readfile
silverlight-3.0
jquery-multidatespicker
restful-url
cross-entropy
nsexception
knockout-3.0
google-account
html-agility-pack
z3py
w3-total-cache
range-v3
taskmanager
tuleap
amazon-machine-learning
xmgrace
workflow-foundation-4.5
text-classification
google-maps-ios
quintus
hpcc
uicollectionviewlayout
system.web.ui.webcontrols
backstop.js
chessboard.js
aescryptoserviceprovider
scalar
clob
spatial-query
uwp-maps
interactive-brokers
document-oriented-db
code-readability
zuora
evo
abas
mogrify
calibration
ytplayerview
bridge
web-component-tester
shift-jis
hg-git
ultrawingrid
genetic-programming
anjuta
logentries
apache2.2
shortcuts
adomd.net
fileconveyor
template-haskell
icefaces-3
continuous-testing
redirectstandardoutput
xmlslurper
z-machine
signals2
galaxy-tab
adsl
getresource
hibernate3-maven-plugin
hadoop-plugins
rtsp-client
savestate
microsoft.ink
winsnmp
web-analytics-tools
self-reference
dotproject

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