Write to GoogleSheet via API with Java

Question

I am trying to write a value to a cell with Google Sheet API with Java. For reading I used guide from Java Quickstart which worked fine for me.

For writing to Google Sheet I use:

service.spreadsheets().values().update(spreadsheetId, "Sheet1!A4:H", response).execute();

This function outputs the following error while run:

com.google.api.client.googleapis.json.GoogleJsonResponseException: 403 Forbidden
{
  "code" : 403,
  "errors" : [ {
    "domain" : "global",
    "message" : "Request had insufficient authentication scopes.",
    "reason" : "forbidden"
  } ],
  "message" : "Request had insufficient authentication scopes.",
  "status" : "PERMISSION_DENIED"
}

As a Authentication Scope I am using

private static final List<String> SCOPES = Arrays.asList(SheetsScopes.SPREADSHEETS);

Have you check your [`client-secret.json`](https://developers.google.com/sheets/guides/authorizing#installed-applications) file? Or used the proper [scopes](https://developers.google.com/sheets/guides/authorizing#OAuth2Authorizing) in authorizing request for Spreadsheet. I hope this helps. — Mr.Rebot, May 31 '16 at 08:07
@Mr.Rebot I have recreated client-secret.json but nothing changed. Regarding the scopes - am I using the right one as I stated in original message? — Alex Kolo, Jun 01 '16 at 07:21
`GoogleAuthorizationCodeFlow flow = new GoogleAuthorizationCodeFlow.Builder( HTTP_TRANSPORT, JSON_FACTORY, clientSecrets, SCOPES) .setDataStoreFactory(DATA_STORE_FACTORY) .setAccessType("offline").setApprovalPrompt("force") .build(); ` — hoozecn, Jun 01 '16 at 13:57

score 13 · Accepted Answer · answered Jun 08 '16 at 12:23

13

Apparently there were several issues together:

Delete credentials that were stored at /Users/XXX/.credentials.
Change Scopes to SheetsScopes.SPREADSHEETS.
Google Sheet Share and Edit options at on Sheet itself.

Now it works! Thank you guys for help

answered Jun 08 '16 at 12:23

Alex Kolo

243
3
14

Sir, you saved a life here. – Berk Olcay Mar 09 '17 at 20:21
Deleting Creds and Changing the scope worked for me. Thank you Alex :) – Rameshwar Jul 20 '17 at 07:34

score 3 · Answer 2 · answered Aug 26 '16 at 01:42

3

I was having the same issue. I resolved the problem that was in the scope. I just changed

SheetsScopes.SPREADSHEETS.READONLY

To

 SheetsScopes.SPREADSHEETS

And it works very well.

answered Aug 26 '16 at 01:42

TSR

17,242
27
93
197

score 0 · Answer 3 · answered Jun 07 '16 at 18:50

The Java API must be used in an interactive way, if you're running this on a server that can't pop up a web-browser (which will let you approve an OAuth dialog), then the authentication flow doesn't get proper credentials and won't work.

While running this, do you see a browser pop up to approve an OAuth dialog? If not, you're likely running in a headless session and will need some other means to get the user's credentials.

score -1 · Answer 4 · answered Aug 26 '16 at 07:54

-1

Try replacing "Sheet1!A4:H" with A4:H

answered Aug 26 '16 at 07:54

Hemant Yadav

601
1
5
4

Write to GoogleSheet via API with Java

4 Answers4

Linked