I have a web site with a form, and I want to push the submitted data from my server into a google sheet which I use as the data store for my AppSheet app.
This seems like it should be very straightforward, but I have struggled with how to securely set up service account authentication from my server to push data into the sheet. I thought that would be ideal if possible.
Otherwise it looks straightforward to upload the data with AppSheet API, but I'm confused on why it looks like I need to upgrade to enterprise plan just to do this.
Does anyone have a good idea for best practice here? maybe I'm missing something simple?
Thanks for any help!!
LinkedIn
Twitter
