Hey I’m trying to get my spreadsheet automatically update the data on AppSheet.
I’ve read that it can be accomplished by writing a dedicated script using the onChange function. Unfortunately I am not a skilled coder and have to look for a point&click solutions.
I’ve found a Trigger&Send Add-on to Spreadsheet and it can trigger the onChange function as I wanted, but it need a URL to push it to. I’ve searched all across the internet and I can’t find info whether AppSheet has any public API nor if I can generate a URL for my app.
Am I doing it the right way? How can I make it work? I need the data I put manually into the spreadsheet to appear in my app.
Thanks for help in advance!