Service icon

Google Sheets Integration Service

Stable version 1.0.2 (Compatible with OutSystems 11)
Uploaded on 11 February 2021 by 
 (1 rating)

Google Sheets Integration Service

Integration with the Google Sheets Rest API V4.Contains the rest integration wrapped in specific service actions for easier use of the API.
Read more

All methods require a Token that can be fetched by any different ways (using a user account authentication - you can use Google Authentication Core and Google Authentication Management for that - or a service account authentication).

Service Actions available in this integration:
- Add data to sheet
-Create new sheet
-Create new spreadsheet
-Delete sheet
-Get spreadsheet detail
-Get value by range

Rest services used:

-/spreadsheets (POST)

-/spreadsheets/{spreadsheetId} (GET)

-/spreadsheets/{spreadsheetId}/values/{range} (GET)

-/spreadsheets/{spreadsheetId}/values/{range} (POST)

-/spreadsheets/{spreadsheetId}/values/{range} (PUT)

For more information please consult the Google Sheets API documentation

To demo this application you can install the Google Components Demo

The Demo application contains a demonstration for 4 Google Components:

- Google Authentication Core;

- Google Sheets;

- Google Drive;

- Google Calendar.

Release notes (1.0.2)

Removed the demo and implemented it in a independent component.

Reviews (1)
31 Jan
in version 1.0.2
This one works, but it is not complete, it requires additional development to get it to work
More from OutSystems Lab