I have a simple script on my personal server that retus JSON data. I have a Google Sheet with a list of useames, and I want to be able to somehow run a script on a useame cell to update only the values in that row, on demand.
Is there a way to trigger an apps script that will call my API and update only the specific row with a given useame? I don't know where I would even start with this.