Trying to append a row to a Google Spreadsheet in PHP <p>I'm using Google's Client API via Composer (<a href="https://packagist.org/packages/google/apiclient" rel="nofollow">https://packagist.org/packages/google/apiclient</a>) and I have successfully authenticated and received an access token.</p> <p>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.</p> <p>Here's what I've got so far:</p> <pre><code>$service = new Google_Service_Sheets($a4e-&gt;google); // my authenticated Google client object $spreadsheetId = "11I1xNv8cHzBGE7uuZtB9fQzbgrz4z7lIaEADfta60nc"; $range = "Sheet1!A1:E"; $valueRange= new Google_Service_Sheets_ValueRange(); $service-&gt;spreadsheets_values-&gt;update($spreadsheetId,$range,$valueRange); </code></pre> <p>This returns the following error:</p> <pre><code>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 </code></pre> <p>I'm stuck as to the format of the "<code>Google_Service_Sheets_ValueRange()</code>" object, and also how to append a row to the end of the sheet, rather than having to specify a particular range.</p> <p>I would greatly appreciate any help with this issue.</p>