使用Drive API (PHP)在Google电子表格中设置“发布到web”

<?php
require_once 'vendor/autoload.php';

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

$service = new Google_Service_Sheets($client);

// 获取电子表格的元数据
$spreadsheetId = 'your-spreadsheet-id';
$spreadsheet = $service->spreadsheets->get($spreadsheetId);

// 创建请求对象，设置“发布到web”
$request = new Google_Service_Sheets_BatchUpdateSpreadsheetRequest([
  'requests' => [
    'updateSpreadsheetProperties' => [
      'properties' => [
        'sheetId' => $spreadsheet->sheets[0]->properties->sheetId,
        'title' => $spreadsheet->properties->title,
        'publishingInfo' => [
          'isPublished' => true,
        ],
      ],
      'fields' => 'publishingInfo.isPublished',
    ],
  ],
]);

// 发送请求，设置“发布到web”
$response = $service->spreadsheets->batchUpdate($spreadsheetId, $request);

// 打印结果
print_r($response);
?>