147
Views
4
Comments
[Google Sheets Connector] Demo Link for Google Sheets Connector
Question
Forge component by João Pedro Abreu
4
Published on 09 Jul 2020

Can you provide a tutorial showing how sheets connector is configured in outsystems?

Staff
Rank: #60

Hi Punardeep,

Along with the GoogleSheetConnector eSpace there's an eSpace called GoogleSheetsDemo, with an example of how to use it.

A few important steps are that you'll need to register your connector with Google before you can use it:

  1. Sign in to your Google API Console and enable the Google Sheets and Google Plus APIs.
  2. Create one credential in Google API Console:
    1. Choose the OAuth client ID type + Web Application credential type.
    2. Fill in the Authorized Javascript Origins with the base url of your server. For me, it was https://setilight.outsystemscloud.com, which is the address for my personal cloud.
    3. Fill in the Authorized Redirect URLs with the URL of the authorization response page, which is in the GoogleServicesOAuth2 eSpace. For me it was https://setilight.outsystemscloud.com/GoogleServicesOAuth2/AuthorizationResponse.aspx.
  3. Finally, fill in the GoogleOAuth_ClientId and GoogleOAuth_ClientSecret site properties in the GoogleServicesOAuth2 eSpace with the respective values of the credential your created.

I hope this helps.

Rank: #16491

I was hoping to use this but I got stuck on the last step.  I am assuming that I'm putting the ClientId and the Secret in to the eSpace in Outsystems?  if so I've not yet found where that is.  

Edit:  so it is the Home under the MainFlow?  if so I now might have got it.  but the app is not verified yet.  Still learning in a sea of unknown for me.

Edit: So i changed the app from testing to published and I think this has allowed me to complete this but I can't get passed the "continue" button.  it says 'Authorization completed'

Rank: #14316

I don't see any eSpace called GoogleSheetsDemo to check the demo.

Please check and advice how we can check it.


Thanks,

Hridesh

mvp_badge
MVP
Rank: #113

Hi Haridesh,

You can download the demo along with the component. See below screenshot for example