Hi Olivier!

Answer 1: Yes, the the Application Type should be Web Application and the authorized redirect URL should be https://yourpersonalarea.outsystemscloud.com/GoogleServicesOAuth2/AuthorizationResponse.aspx.

Answer 2: Since you have set the client ID and secret in Service Center, the issue may be that you also need to enable the Google+ API. This is something that I may need to change but, for now, the AuthorizationResponse screen makes a call to a Google+ API, in order to retrieve the google account's email address.

For my tests, I also added my personal area (https://setilight.outsystemscloud.com) to the authorized javascript origins. I'm not sure if it's required, though.

Let me know if that fixed your problem!

Thank you João for your prompt reply!

Indeed, I only had enabled Google Drive API. I now also enabled Google+ API and the authorization worked fine. I now get a screen on the GoogleSheetsDemo/Authorize with my Google login, the scope https://www.googleapis.com/auth/spreadsheets and last updated date

But the read & write actions are not still working. I get a "403 Forbidden" (module REST (Consume), stack 403 Forbidden at ssGoogleSheetsConnector.CcGoogleSheetsAPI.ActionGetValues).

I insert the Spreadsheet ID as described, but the "Test" button fails with the error above. I've also added the Javascript origin authorization, but it didn't have any effect.

I'm pretty sure I set the correct inputs (Spreadsheet ID and sheet name) on the Demo, I'm the developer of the old Google Spreadsheet API   

Any ideas    ?

Regards, Olivier

I've tested reading and writing to spreadsheets I owned and to spreadsheets that were shared with me with Edit permissions. The only case where I got a 403 Forbidden error, while being authenticated, was when trying to access a spreadsheet that my account didn't have access to.

I suggest you double check if the account you authorized has edit access to the spreadsheet. If you find that the account you used has access, I'll probably ask you for help reproducing the issue.

It's working!!!   

The problem was with the API enabled: I had authorized Google Drive API, but the correct autorization is Google Sheets.

Thank you for your support! May I vote for the "Find" option as the next implementation   ?

Regards, Olivier

Hi Olivier and João,

Can I know what you did for solving this 403 forbidden issue? I've authorized my client id and secret successfuly. But when I tried to create a spreadsheet, it returned me that 403 error. What should I do to fix this? Thank you

Kind regards,

Shenn

Hi Shenn!

Did you enabled the APIs and made the settings on your Google API console (https://console.developers.google.com/) as described in this post?

Regards, Olivier

Hello,

Am unable to get this highlighted part of the screen

I get the message saying the Authorization is done - however i do NOT get the details. Can you please let me know what is that am missing? Kinda stuck with this since days...

had followed all the steps and got the previous screen for authorization - filled in the required details, but after pressing NEXT - get only Google Authorization complete... but nothing further to that.

Also THANK YOU for this wonderful tool.

Hi João Pedro Abreu,

I am not able to authorize andI configure the redirect URL as: "https://yourpersonalarea.outsystemscloud.com/GoogleServicesOAuth2/AuthorizationResponsePage.aspx", I enabled the google sheet API, google drive, and google+ API also getting error as:

Thank you for your support, Pallavi

@João Pedro Abreu  and @Olivier 

Team, I am trying to work on GoogleSheet Demo for past couple of days and by following this post, I was able to authorize my gmail address. Only authorization is done on screen and it shows "Google Authorization Complete". When i click on Continue button, it's not displaying any details of me or not allowing me to proceed with next steps. Could someone please help in finding the issue.
This issue is similar to what @vishill has posted above but no solutions was posted for that. Please help