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

Client side API google.script.run not working
Generate google docs with QR code from google sheet
I need to average that last four cells of every third column
How to add google analytics data into a 2D array in app script
Updated Google Calendar events from Sheets
Bigquery and Google Sheets Integration
Performing Actions after a loop
AdminDirectory.Members.insert returns “Member already exists”
Arrange/Merge 'index split' values in a single row
Google Apps Script: Find and replace in specific column only
Run spreadsheet function from google form script
Overwrite existing file in a specific Google Drive folder
Lock Service not always locking in Google Apps Script
Google Sheets Script - copy entire external spreadsheet to current spreadsheet
Use inline keys in Telegram bot on google app script
Detect access token expiration when invoking Google APIs

Categories

HOME
visual-studio-2015
sql-server
jsf
textwatcher
backup
deep-linking
h2
sequelize.js
apiconnect
avl-tree
deeplearning4j
packer
x11
google-shopping
phoenix
multiple-monitors
lstm
cross-platform
reduction
bootstrap-popover
primes
propel2
multiple-columns
prediction
restfb
logarithm
iis-10
croppic
branch
rhmap
guile
hash-collision
pptp
fetch-api
pljson
rhino
precedence
lego
issue-tracking
declare
alchemy.js
linq-to-entities
floating-accuracy
knockout-3.0
ttcn
fastq
lumen-5.3
double-buffering
range-v3
appstore-approval
multi-agent
ogre3d
dwarf
greenhills
openh264
cdk
festival
rsqlite
pspice
master
libreadline
xib
glkit
galleriffic
git-annex
instruments
asteriskami
gradle-eclipse
shipitjs
sun-codemodel
portfolio
except
asymptote
anythingslider
direct3d12
eyeql
sourcegear-vault
datasnap
mysqldumpslow
uialertview
urn
ticket-system
obfuscar
activity-streams
ghostdoc
libssh2
io.js
mfmailcomposeviewcontroll
picat
data-generation
config-files
edit-in-place
visual-studio-addins
bigint
ruboto
threadx
arbor.js
mvs
crocodoc
maven-ear-plugin
osi
jquery-selectbox
zookeeper
associative
for-xml-path
symbol-server
camtasia
filetime
swfloader
odbc-sql-server-driver





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