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

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

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.



Rank: #113

Hi Haridesh,

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