Trying to append a row to a Google Spreadsheet in PHP

发布于 2020-03-29 20:59:46

I'm using Google's Client API via Composer (https://packagist.org/packages/google/apiclient) and I have successfully authenticated and received an access token.

I am trying to add a row to a Google sheet in my drive, but I can't find any relevant documentation that specifically addresses PHP.

Here's what I've got so far:

$service = new Google_Service_Sheets($a4e->google); // my authenticated Google client object
$spreadsheetId = "11I1xNv8cHzBGE7uuZtB9fQzbgrz4z7lIaEADfta60nc";
$range = "Sheet1!A1:E";
$valueRange= new Google_Service_Sheets_ValueRange();
$service->spreadsheets_values->update($spreadsheetId,$range,$valueRange);

This returns the following error:

Fatal error: Uncaught exception 'Google_Service_Exception' with message '{ "error": { "code": 400, "message": "Invalid valueInputOption: INPUT_VALUE_OPTION_UNSPECIFIED", "errors": [ { "message": "Invalid valueInputOption: INPUT_VALUE_OPTION_UNSPECIFIED", "domain": "global", "reason": "badRequest" } ], "status": "INVALID_ARGUMENT" } } ' in /usr/share/nginx/vendor/google/apiclient/src/Google/Http/REST.php

I'm stuck as to the format of the "Google_Service_Sheets_ValueRange()" object, and also how to append a row to the end of the sheet, rather than having to specify a particular range.

I would greatly appreciate any help with this issue.

Questioner

praine

Viewed

110

Chinese

Original

// ... // Create the value range Object $valueRange= new Google_Service_Sheets_ValueRange(); // You need to specify the values you insert $valueRange->setValues(["values" => ["a", "b"]]); // Add two values // Then you need to add some configuration $conf = ["valueInputOption" => "RAW"]; // Update the spreadsheet $service->spreadsheets_values->update($spreadsheetId, $range, $valueRange, $conf);

Eric Koleda 2016-10-04 04:46:36

FYI, we just added a small sample for this in the documentation: developers.google.com/sheets/guides/…

Walter M 2020-02-12 10:20:14

@EricKoleda Hey Eric, what happened to the documentation? It is compeletely nonexistent. There are no explanations or examples. Constructors, methods and properties are not listed either? What happened?

Eric Koleda 2020-02-12 22:48:12

What do you mean? PHP-specific reference docs are here: developers.google.com/resources/api-libraries/documentation/…

Trying to append a row to a Google Spreadsheet in PHP

Related issues