[Google Sheets Connector] Demo Link for Google Sheets Connector

[Google Sheets Connector] Demo Link for Google Sheets Connector

  
Forge Component
(4)
Published on 1 Nov by João Pedro Abreu
4 votes
Published on 1 Nov by João Pedro Abreu

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

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.