I'm currently exploring retool and will especially need the public sharing option. I connected a Google sheet to my app and the data is read correctly when I access a public app. However, when I try to work with a query consisting of
append data to spreadsheet it won't execute on a public app. Is there any way to make this possible? I connect to the Google Sheet via OAuth. Would this functionality be available in case I use a service account to connect?
Thanks and kind regards