Webhooks for Sheets — Workspace Add-on
to read through the privacy policy for this add-on, please refer here.
i've previously built 2 add-ons:
- workbook statistics — which was a g suite editor add-on for google sheets and
- count von count — which is a workspace add-on that summarises accessible stats about different workspace services.
the general idea behind this workspace add-on is to be able to create an apps script-native webhook for google sheets by making use of the apps script rest apis and the doGet
and doPost
functions to deploy the container-bound script as a web app.
here's how the auth process of the app would look like -
(right click and open image in a new tab to see it in a more enlarged format)
and, once you've authorized the add-on, it would look something like this -
(right click and open image in a new tab to see it in a more enlarged format)