CODEWITHSUNDEEP
gwtgoogle-drive-apigoogle-sheets
Marten Sytema
Marten Sytema

Reputation: 1926

Do I need Drive API, or Spreadsheet API, or both?

Currently, I am developing a web-app in GoogleWebToolkit (ie. java back-end) that should:

  1. Copy an existing google drive spreadsheet document on the same drive
  2. Modify this copied version based on some business logic.

I looked into the Google Spreadsheet API, but had hard time dealing with the oAuth logic. Then I looked at the google Drive API, and found the Dr.Edit example project.

This last project looks good, and I can create and edit text files, but is it now also possible to use some sort of API that reads out SpreadSheet documents instead?

Bottom line is: should i combine Spreadsheet API and Drive API here. What is recommended? I am confused.

Upvotes: 0

Views: 436

Answers (1)

Burcu Dogan
Burcu Dogan

Reputation: 9213

You can manage files (create/edit/delete/view) with Google Drive SDK but need Spreadsheets API to modify the worksheets, rows and cells individually.

Once you acquire an access token, you can use it to access Spreadsheets endpoints too. Make sure that you're authorizing for the following scope as well:

https://spreadsheets.google.com/feeds

Upvotes: 1

Related Questions