CompanyOnwership_icon
OutSystems Lab
Created on 03 February 2021
icon_unfollowing
Login to follow
googlesheets-is

Google Sheets Integration Service

icon_trusted
Stable version 1.0.2 (Compatible with OutSystems 11)
Uploaded on 11 February 2021 by 
OutSystems Lab
googlesheets-is

Google Sheets Integration Service

Documentation
1.0.2

In order to be able to use the Google Sheets API you need to be authenticated. To determine your authentication the APIs request a Token that proves who is trying to use the services and if that configuration has permissions to access the requested API.

Google has different types of authentication. You can use a service account or you can use a Google ID token where you have your Users logging in. You can check more information on the google documentation here.

On forge you have already Google Authentication Core and Google Authentication Management that allows you to do an Google Id token authentication. You can start by configure the Google Authentication Core  and create and configure your app in the Google Authentication Management.

On the Google Authentication Management, please add the Sheets API scopes

After having those configurations you're ready to use the Google Sheets integration. You'll need to use the Token that is generated. You can use the actions provided on the Google Authentication Core or provide the token yourself with other authentication methods.


Useful Actions:

  • AddDataToSheet - Add data to an existing spreadsheet. You can edit values in a sheet or even add new sheets. Allows for a batch update of information;
  • CreateNewSheet - Add a New sheet (or update) to a spreadsheet;
  • CreateNewSpreadsheet - Creates a new spreadsheet;
  • DeleteSheet - Deletes a sheet in a spreadsheet;
  • GetSpreadSheetDetail - Get all the spreadsheet details: the metadata, formatting, sheets data etc.;
  • GetValueByRange - Get a set of values for a defined range. The range follows the A1 notation. More info here.




Support options
This asset is not supported by OutSystems. You may use the discussion forums to leave suggestions or obtain best-effort support from the community, including from  who created this asset.
Dependencies
Google Sheets Integration Service has no dependencies.