Google sheets API configuration

Hey Bubblers,

Really need some help with this. I need to connect to the Google sheets API as I need my app to be able to write to multiple spreadsheets and show filtered views.
I already watched all the youtube videos about this and tested out all the plugins available but none do the job.

My configuration looks like this at the moment:

I’m getting this error message:

I’m unsure if I must use a service account here or not.
Each user will have his/her spreadsheet created in my own google drive so that’s the only access I need.

I followed the instructions from Bubble and configured the Google login without navigation action to initiate the API. That works fine, proving I use the correct APP ID and APP secret.

Thanks in advance for your help :slight_smile: