Spreadsheets, driven by code.

<?php

require 'vendor/autoload.php';

use Google\Client;
use Google\Service\Sheets;
use Google\Service\Sheets\ValueRange;

/**
 * Set up parameters.
 */
$spreadsheetId = 'Your spreadsheetId here.';
$keyFile = 'service-account.json';
$range = 'Sheet1!A1';
$valueInputOption = 'RAW';
$insertDataOption = 'INSERT_ROWS';

$client = new Client();
$client->setApplicationName('Append Google Sheets Rows');
$client->setAuthConfig($keyFile);
$client->addScope(Sheets::SPREADSHEETS);

$service = new Sheets($client);

$newRows = [
    ['N1', 'n1@example.com', '2026-08-12', 'Pro'],
    ['N2', 'n2@example.com', '2026-08-13', 'Free'],
    ['N3', 'n3@example.com', '2026-08-14', 'Team'],
];

$response = $service->spreadsheets_values->append(
    $spreadsheetId,
    $range,
    new ValueRange(['values' => $newRows]),
    [
        'valueInputOption' => $valueInputOption,
        'insertDataOption' => $insertDataOption,
    ]
);

// The API found the table itself. Ask it what it found, and where it wrote.
printf("Range we asked for : %s\n", $range);
printf("Table it detected  : %s\n", $response->getTableRange());
printf("Where it wrote     : %s\n", $response->getUpdates()->getUpdatedRange());
printf("Rows added         : %d\n", $response->getUpdates()->getUpdatedRows());
printf("Cells written      : %d\n\n", $response->getUpdates()->getUpdatedCells());

// Read the sheet back so the result is the sheet, not the response.
$rows = $service->spreadsheets_values->get($spreadsheetId, 'Sheet1!A1:D12')->getValues() ?? [];

echo "Sheet1 after the append:\n";
foreach ($rows as $i => $row) {
    printf("  row %-2d %s\n", $i + 1, implode(' | ', $row));
}