通过PHP调用Google Sheet API创建表格后，如何将其设置为公开可编辑？

Absolutely! You don't have to manually tweak permissions after creating the sheet—you can configure it to be publicly editable right during the creation process by combining the Google Sheets API (for sheet creation) and Google Drive API (for permission management). Here's a step-by-step guide with practical code examples:

Prerequisites #

• Make sure you’ve installed the Google Client Library via Composer:

  composer require google/apiclient:^2.0
  

• Enable both the Sheets API and Drive API in your Google Cloud project.
• Ensure your authentication credentials (service account or OAuth 2.0 client) have the necessary scopes—like https://www.googleapis.com/auth/drive (full Drive access) or the more restrictive https://www.googleapis.com/auth/spreadsheets + https://www.googleapis.com/auth/drive.file (only access files your app creates).

Step-by-Step Code Implementation #

1. Initialize the Authenticated Google Client #

First, set up your client with the required scopes and credentials:

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

$client = new Google\Client();
$client->setApplicationName('Public Editable Sheet Creator');
$client->setScopes([
    Google\Service\Sheets::SPREADSHEETS,
    Google\Service\Drive::DRIVE
]);
$client->setAuthConfig('path/to/your/credentials.json'); // Path to your service account/OAuth credentials file
$client->setAccessType('offline');

2. Create the New Google Sheet #

Use the Sheets API to generate your spreadsheet:

$sheetsService = new Google\Service\Sheets($client);
$spreadsheet = new Google\Service\Sheets\Spreadsheet([
    'properties' => [
        'title' => 'My Public Editable Sheet' // Customize your sheet title here
    ]
]);
$createdSheet = $sheetsService->spreadsheets->create($spreadsheet);
$sheetId = $createdSheet->getId(); // Grab the ID of the newly created sheet

3. Apply Public Edit Permissions #

Use the Drive API to add a permission that lets anyone on the web edit the sheet:

$driveService = new Google\Service\Drive($client);
$permission = new Google\Service\Drive\Permission([
    'type' => 'anyone', // Grant access to all web users
    'role' => 'writer', // Allow full edit access; use 'reader' for view-only
    'allowFileDiscovery' => false // Optional: Hide the sheet from Google Drive search results
]);

// Execute the permission creation
try {
    $driveService->permissions->create($sheetId, $permission, [
        'sendNotificationEmail' => false // Skip sending auto-notification emails
    ]);
    echo "Sheet created and set to public editable successfully! Sheet ID: $sheetId";
} catch (Exception $e) {
    echo "Error setting permissions: " . $e->getMessage();
}

Key Notes #

• Role Adjustments: Swap 'writer' with 'reader' if you only want public view access instead of edit rights.
• Scope Restrictions: Using https://www.googleapis.com/auth/drive.file instead of full drive scope limits your app’s access to only the files it creates, which is more secure for most use cases.
• Error Handling: Always wrap permission operations in a try-catch block to handle edge cases like invalid credentials or insufficient API permissions.

内容的提问来源于stack exchange，提问作者Test mail