Skip to Content (Press Enter)
UserImage.jpg
Punardeep Singh
284Views
4Comments
[Google Sheets Connector] Demo Link for Google Sheets Connector
Question
Forge
google-sheets-connector
Web icon
Google Sheets Connector (O11)
Forge asset by João Pedro Abreu

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

0
0
22 Nov 2018
Copy Link
2019-09-17 09-11-00
João Pedro Abreu
Staff

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.

1
0
22 Nov 2018
Copy Link
2021-02-13 15-53-05
Duncan Cunningham

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'

0
0
30 Jan 2021
Copy Link
UserImage.jpg
Hridesh Prajapati

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

Please check and advice how we can check it.


Thanks,

Hridesh

0
0
08 Feb 2020
Copy Link
2020-03-01 17-52-33
Nikhil Gaur

Hi Haridesh,

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

0
0
09 Feb 2020
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.