composer require google/apiclient:^2.0

require_once __DIR__ . '/vendor/autoload.php';

function getClient()
{
    $client = new Google_Client();
    $client->setApplicationName('Google Sheets API PHP Quickstart');
    $client->setScopes(Google_Service_Sheets::SPREADSHEETS);
    $client->setAuthConfig('credentials.json');
    $client->setAccessType('offline');
    return $client;
}

function readSheet($spreadsheetId, $range)
{
    $client = getClient();
    $service = new Google_Service_Sheets($client);
    
    $response = $service->spreadsheets_values->get($spreadsheetId, $range);
    $values = $response->getValues();
    
    if (empty($values)) {
        echo "No data found.\n";
    } else {
        foreach ($values as $row) {
            echo implode(", ", $row) . "\n";
        }
    }
}

// 使用示例
$spreadsheetId = '你的电子表格ID';
$range = 'Sheet1!A1:C3';
readSheet($spreadsheetId, $range);

function writeSheet($spreadsheetId, $range, $values)
{
    $client = getClient();
    $service = new Google_Service_Sheets($client);
    
    $body = new Google_Service_Sheets_ValueRange([
        'values' => $values
    ]);
    
    $params = [
        'valueInputOption' => 'RAW'
    ];
    
    $result = $service->spreadsheets_values->update(
        $spreadsheetId,
        $range,
        $body,
        $params
    );
    
    printf("%d cells updated.\n", $result->getUpdatedCells());
}

// 使用示例
$spreadsheetId = '你的电子表格ID';
$range = 'Sheet1!A1';
$values = [
    ['Name', 'Age', 'City'],
    ['John', '30', 'New York'],
    ['Jane', '25', 'London']
];
writeSheet($spreadsheetId, $range, $values);