Listen for spreadsheet events in ui

[enuchi]

Listen for spreadsheet events in ui

[PopeOnARope]

Thanks so much for the reply! I ended up having my component query the server at an interval, but wasn't sure if there was a built-in way to listen for changes from the ui. This is my first time working with Google Apps Script, so still figuring it out!

[enuchi]

Hey @PopeOnARope , great question. There is probably a workaround, but it would be a very hacky solution.

The way you're trying won't work. You can't share code like that between client and server. They are essentially two different apps that get bundled separately: a client app and a server app. The server (Google Apps Script) code doesn't know anything about react so can't use context.

The only way to communicate between client and server is through the google.script.run api, which I've wrapped with a "gas-client" package that tries to simplify things and let you easily call server functions. onSelectionChange is basically its own, separate, server function that gets called whenever you select something new. I don't know how you could trigger something in the react app that was initiated from the server code.

You could do something like poll the server on an interval or something but can't think of a simple solution off the top of my head.