Script that appends rows to a spreadsheet via the Google Sheets API.

google-sheets-append-rows.php

<?php
require __DIR__ . '/vendor/autoload.php';

$creds = 'credentials.json';
$sheedId = '1IMwiyCa1gCfh1lacyzZqFrYFsqCe-hOSRlaHIc2gFDw';
$range = 'Sheet1';

$client = new Google_Client();
$client->setAuthConfigFile($creds);
$client->useApplicationDefaultCredentials();
$client->addScope(Google_Service_Sheets::SPREADSHEETS);

$service = new Google_Service_Sheets($client);

$body = new Google_Service_Sheets_ValueRange([
    'values' => [
        ['[email protected]', 42, true],
        ['[email protected]', 'hello', false]
    ]
]);

$params = [
    'valueInputOption' => 'USER_ENTERED'
];

$result = $service->spreadsheets_values->append($sheedId, $range, $body, $params);
printf("%d cells appended.", $result->getUpdates()->getUpdatedCells());