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 file? Or used the proper scopes in authorizing request for Spreadsheet. I hope this helps. — Mr.Rebot
@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
GoogleAuthorizationCodeFlow flow = new GoogleAuthorizationCodeFlow.Builder( HTTP_TRANSPORT, JSON_FACTORY, clientSecrets, SCOPES) .setDataStoreFactory(DATA_STORE_FACTORY) .setAccessType("offline").setApprovalPrompt("force") .build(); — hoozecn

Alex Kolo Alex Kolo · Accepted Answer · 2016-06-08T12:23:18

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

Write to GoogleSheet via API with Java

4 Answers