bulk_process_from_sheet
Run bulk Google Workspace administrative commands by referencing a Google Sheet. Specify command templates with column placeholders, optionally filter rows, and redirect results to a sheet.
Instructions
Executes a GAM bulk command using a Google Sheet as the data source.
Args:
operator_email: The email of the admin running the command (needs access to the sheets).
sheet_file_id: The ID of the source Google Sheet.
sheet_name: The tab name containing the source data.
gam_command_template: List of command template fragments using ~ColumnName syntax.
match_field: Optional column name to filter on.
match_pattern: Optional regex pattern to match against match_field.
redirect_to_sheet_id: Optional Sheet ID to write results to.
redirect_to_sheet_name: Tab name for results.
confirmed: Must be True to execute. If False, returns a preview.
GAM pattern:
[redirect csv - multiprocess todrive tdfileid <id> tdsheet "<name>" tdupdatesheet]
csv gsheet <operator_email> <sheet_file_id> "<sheet_name>"
[matchfield <match_field> <match_pattern>]
gam <gam_command_template...>
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"operator_email": "<operator_email>",
"sheet_file_id": "<sheet_file_id>",
"sheet_name": "<sheet_name>",
"gam_command_template": "<gam_command_template>"
},
"name": "bulk_process_from_sheet"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| confirmed | No | ||
| sheet_name | Yes | ||
| match_field | No | ||
| match_pattern | No | ||
| sheet_file_id | Yes | ||
| operator_email | Yes | ||
| gam_command_template | Yes | ||
| redirect_to_sheet_id | No | ||
| redirect_to_sheet_name | No | Bulk Output |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |