添加带有url的数据到Google电子表格(通过PHP)

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

$client = new Google_Client();
$client->setApplicationName('Google Sheets PHP');
$client->setScopes([Google_Service_Sheets::SPREADSHEETS]);
$client->setAuthConfig('path/to/service_account_credentials.json');

$service = new Google_Service_Sheets($client);

$spreadsheetId = 'your_spreadsheet_id';
$range = 'Sheet1!A1:B1';

$values = [
    ['Data 1', 'https://example.com'],
    ['Data 2', 'https://example.com'],
    ['Data 3', 'https://example.com'],
];

$body = new Google_Service_Sheets_ValueRange([
    'values' => $values
]);

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

$result = $service->spreadsheets_values->append($spreadsheetId, $range, $body, $params);

if ($result) {
    echo 'Data added successfully.';
} else {
    echo 'Error adding data.';
}
?>