CODEWITHSUNDEEP
google-apps-scriptgoogle-sheetstriggers
John K
John K

Reputation: 28917

Run Google Apps Script on Google-Spreadsheet event?

If I create a Google apps script, can I hook it up to Google spreadsheet to run based on an event, or must I manually invoke it?

I don't know if Google Sheets supports any events.

For example: a Google app script that strikes out rows in the spreadsheet that have been marked completed by way of a column having the digit 1 beside completed rows. I would like this to run whenever a row is modified, or even when the spreadsheet is first loaded.

Upvotes: 5

Views: 10948

Answers (1)

user298038
user298038

Reputation:

The function onOpen() is automatically executed every time a Spreadsheet is loaded. In the future, we will expose a general event API, but until then you can simply define your own function as long as it is called onOpen().
From the Section 2 of the Tutorial

There is also function onEdit() as can be viewed in at:

http://www.google.com/support/forum/p/apps-script/thread?tid=584a17c79e4c04d5&hl=en

It seems that event handling is in flux and dependent on security issues being worked out.

Upvotes: 3

Related Questions