如何在更新Google电子表格时修复错误

Question

I'm using Google Sheet Api on PHP framework and facing error while updating sheet.

Fatal error: Uncaught Google_Service_Exception: {
  "error": {
    "code": 403,
    "message": "Request had insufficient authentication scopes.",
    "errors": [
      {
        "message": "Request had insufficient authentication scopes.",
        "domain": "global",
        "reason": "forbidden"
      }
    ],
    "status": "PERMISSION_DENIED"
  }

How can I fix it?

function add($spreadsheetId, $range, $value, $service){
    $result = $service->spreadsheets_values->get($spreadsheetId, $range);
    $numRows = $result->getValues() != null ? count($result->getValues()) : 0;
    printf("%d rows retrieved.", $numRows);
    $body = new Google_Service_Sheets_ValueRange([
        'values' => [$value]
    ]);
    $end = chr(65 + count($value) - 1);
    $range = $range."!A".($numRows + 1).":".$end;//ex:Sheet!A6:H
    printf("%s
", $range);
    $result = $service->spreadsheets_values->update($spreadsheetId, $range, $body, ['valueInputOption' => 'USER_ENTERED']);
    printf("%d cells added.
", $result->getUpdatedCells());
}

</div>

Answer 1

I also had error like that. And I solved it by downloading credential.json file again. Additionally, Please check if spreadsheetId is correct or wrote $client->setScopes(Google_Service_Sheets::SPREADSHEETS); before creating service.