Writing to Google sheets from public retool app

Queries and Resources
#1

Hey,
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
HRR

#2

Hey HRR!

This should work, depending on how you've connected your Google Sheet. If you've hardcoded in your credentials (e.g. a service account as you've mentioned), all should be well :slight_smile:

This funky behavior is just because public apps don't have any sort of auth.

#3

Great, thanks - will try that!

#4

Awesome, let me know how it goes! :crossed_fingers:

#5

It worked!

#6