share_spreadsheet
Share a Google Spreadsheet with multiple users by assigning specific roles such as reader, commenter, or writer. Send notification emails optionally.
Instructions
Share a Google Spreadsheet with multiple users via email, assigning specific roles.
Args: spreadsheet_id: The ID of the spreadsheet to share. recipients: A list of dictionaries, each containing 'email_address' and 'role'. The role should be one of: 'reader', 'commenter', 'writer'. Example: [ {'email_address': 'user1@example.com', 'role': 'writer'}, {'email_address': 'user2@example.com', 'role': 'reader'} ] send_notification: Whether to send a notification email to the users. Defaults to True.
Returns: A dictionary containing lists of 'successes' and 'failures'. Each item in the lists includes the email address and the outcome.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| spreadsheet_id | Yes | ||
| recipients | Yes | ||
| send_notification | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |