You can use Glide to change a value in your spreadsheet (anywhere), and then detect that change with an onChange() trigger. That trigger can then fire your script. I demonstrated this technique in my Apps Script JSON API tutorial.
1 Like