How can you monitor for click events in Google Apps script for spreadsheets?
google-apps-script
Solution
As stated on the comments above before there's no way (right now) to create an `onClick()` function for Google Spreadsheets. That makes sense due to the fact that the google app script functions are processed in the server, the amount of load generated by `onClick()` events execution would make pretty easy to deplete all the quota of requests provided by default.
You should be using the documentation for creating a button and clicking on it.
Problem
I'm managing a Google spreadsheet with a script. onEdit is working - I can colour a cell red by putting ``` SpreadsheetApp.getActiveRange().setBackgroundRGB(255, 0, 0); ``` in the onEdit function. I would like to put the same code in a onClick function, so that when a user clicks on a cell it immediately turns red. Is this possible? I can't find any way to do it in the documentation.