/google-spreadsheet-api-samples

Java samples for google spreadsheet api

Primary LanguageJavaEclipse Public License 1.0EPL-1.0

google spreadsheet api samples

Working java samples for usage of google spreadsheet api in contrast to:

  1. Google Sheets API version 3.0 Dev Guide.

spreadsheet OAuth 2.0 (console sample)

The console application asks user to print out names of all spreadsheets on google drive. Sample shows how to use Google Spreadsheet API v3 (gdata) with OAuth 2.0.

  • Use playground to play with OAuth 2.0.
  • Have a look into good example to know how to deal with deprecated OAuth 1.0.

google sheets api v4 (web sample)

Web application connects with google spreadsheet and reads all data as table. Sample shows how to use Google Sheet API v4.

  1. modify application.properties - add spdreadsheed id and sheet name.
  2. replace clien_secrets.json with right one
  3. Start as normal spring boot application
  4. open brouser: http://localhost:5000/api/sheet