I’m trying to use an Outsystems form to write information to a Google Sheets file and later on use the information on that Sheets file in an Outsystems table with the possibility of editing or deleting records.

I’m trying to use the following methods I found online:

POST https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}/values/{range}:append

GET https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}/values/{range}

I’m getting the following authentication error:

I’ve used forge components in order to configure some google settings but I have no clue what to do next. Can you point me to a guide or something so I can do this Google Sheets integration properly?

I already configured the google cloud as follows:

Thanks in advance,

Filipe