我想將數(shù)據(jù)寫入 Google 表格。我可以成功地從我的 GoogleSheet 獲取數(shù)據(jù)。但是我嘗試寫入數(shù)據(jù)時出現(xiàn)以下錯誤。遇到未捕獲的異常類型:Google_Service_Exceptionmessage: { "error": { "code": 403, "message": "調(diào)用方?jīng)]有權(quán)限", "errors": [ { "message": "調(diào)用方?jīng)]有權(quán)限", "domain": "global", "reason": "forbidden" } ], "status": "PERMISSION_DENIED" } }這是我的代碼。 $client = new \Google_Client(); $client->setApplicationName('SheetsPHP'); $client->setScopes([\Google_Service_Sheets::SPREADSHEETS]); $client->setAccessType('offline'); $client->setAuthConfig(__DIR__ . '/../../credentials.json'); $sheets = new \Google_Service_Sheets($client); $spreadsheetId = '.....'; $range = '??1!B2:G5'; $values = [['b', 'c', 'd', 'e', 'f', 'g']]; $body = new Google_Service_Sheets_ValueRange([ 'values' => $values ]); $params = [ 'valueInputOption' => "RAW" ]; $result = $sheets->spreadsheets_values->update($spreadsheetId, $range, $body, $params);我已經(jīng)共享了服務(wù)帳戶電子郵件。請讓我知道出了什么問題。
1 回答

瀟瀟雨雨
TA貢獻1833條經(jīng)驗 獲得超4個贊
僅供測試嘗試修改您的權(quán)限僅供閱讀
$client->setScopes(Google_Service_Sheets::SPREADSHEETS_READONLY);
也許問題出在寫權(quán)限上
- 1 回答
- 0 關(guān)注
- 87 瀏覽
添加回答
舉報
0/150
提交
取消