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!