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...>
Input Schema
TableJSON 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
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |