Webhook in a Public App

All you need to do is create a trigger script to “watch” a cell/range in your spreadsheet, and then use Glide to alter a value in that range.

If you look at my JSON/API tutorial, I use exactly that technique there.