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).
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.
Removed the demo and implemented it in a independent component.