Google Sheets API - OAuth access token

Questions about Thunkable
1

Hello there, i’m trying to connect through WebAPI to Google Sheets.

I know there’s a nice component for it, but unfortunately i need an extra sparkle.
Ideally i need the app to select automatically the page’s sheet where to get data from (or add to), right now it can only be decided through blocks. In general i need the sheet to be a variable.

I created the project in Google Cloud Console, enabled the Google Sheets API, created an Android OAuth and got Client ID.
From here, blank.
What i think i need is how to get an Authorization token from the Client ID to be set as Header in the api call.

I looked a lot on internet, but some solutions seem outdated or not helpful for my case.

Did someone already came across this and can enlight me?

Thank you very much!

2

Hello @maurizio.polverini89
To make the Google Sheets API work you could create a new API using another backend provider and then this API will call Google Sheets. For example, you could use Zappier’s Google Sheets connection or Make. These services have been known to work well with Thunkable.