Apps Developer Blog
Information for Google Apps Developers
Installable triggers in add-ons for Google Docs and Sheets
October 1, 2014
Update (Oct 17, 2014): Add-ons can now also use
time-driven triggers
.
Earlier this year
, we introduced
add-ons for Google Docs and Sheets
—packaged Apps Script projects that users can easily install from
our add-on store
to get extra functionality and features.
Since then, plenty of developers told us they were eager to add
installable Apps Script triggers
to their add-ons. We're happy to announce that now you can do just that, making it possible to respond to more user actions. For example, a spreadsheet add-on can now react when a user submits a response to a Google Form, or can call a method that requires authorization when a user edits a cell.
Add-ons can now programmatically create and manage these installable triggers:
Sheets add-ons can use the change, edit, open, and form-submit installable triggers.
Docs add-ons can use the (new!) open installable trigger.
To see the power of installable triggers in action, check out developer Romain Vialard's
Yet Another Mail Merge
, which has already been updated. The original YAMM lets users quickly personalize Gmail drafts by replacing placeholder fields with data from a spreadsheet. The new version uses a trigger to send an email whenever a form is submitted.
If you've worked with installable triggers before, you'll find that they behave a little differently in add-ons (for one thing, there are no pesky "Summary of failures" emails!), so
be sure to check out the documentation
.
Posted by Edward Jones, Googler
No comments :
Post a Comment
Labels
.NET
3
#io15
1
Admin SDK
4
Administrative APIs
26
AdSense
1
analytics
4
Android
5
App Engine
5
Apps Script
98
Auth
1
billing
4
Charts
1
Chrome OS
1
classroom
1
Cloud Storage API
1
Community
1
Developers
5
Directory API
1
Drive
2
Drive SDK
38
execution API
1
Firebase
1
Freemium
1
Fusion Tables
2
Gadgets
5
Gmail APIs
16
Google APIs
3
Google Apps
3
Google Apps Directory API
1
Google Apps Marketplace
3
Google Apps Script
1
Google Calendar API
20
Google Contacts API
3
Google Data Protocol
7
google docs
3
Google Docs API
20
Google Drive
2
Google Forms
4
Google I/O
3
Google Prediction API
3
Google Profiles API
2
Google sheets
2
Google Sites API
4
Google Spreadsheets API
4
Google Talk
1
Google Tasks API
6
Google+
3
googlenew
1
Groups
2
Guest Post
42
ISVs
2
java
1
JavaScript
3
marketing
3
Marketplace
47
Marketplace ISV Guest
21
Migration
1
Mobile
1
mpstaffpick
1
oauth
11
OpenID
7
PHP
1
python
4
realtime API
1
Resellers
2
Ruby
1
SaaS
1
security
1
Staff Picks
2
webinar
2
Archive
2015
Oct
Sep
Aug
Jul
Jun
May
Apr
Mar
Feb
2014
Dec
Oct
Sep
Aug
Jul
Jun
May
Mar
Feb
Jan
2013
Dec
Nov
Oct
Sep
Aug
Jul
Jun
May
Apr
Mar
Feb
Jan
2012
Dec
Nov
Oct
Sep
Aug
Jul
Jun
May
Apr
Mar
Feb
Jan
2011
Dec
Nov
Oct
Sep
Aug
Jul
Jun
May
Apr
Mar
Feb
Jan
2010
Dec
Nov
Oct
Sep
Aug
Jul
Jun
May
Apr
Mar
Feb
Feed
Follow @googleappsdev
No comments :
Post a Comment