get_group_permissions_to_sheet
Retrieves members and roles from multiple Google Groups and writes the data to a Google Sheet.
Instructions
Retrieves group members and their roles, outputting to a Google Sheet.
Uses multiprocess redirect to quickly gather many groups.
Args:
group_emails: List of group email addresses to query.
output_sheet_id: ID of the Google Sheet for output.
output_sheet_name: Tab name for the output sheet.
GAM pattern:
gam redirect csv - multiprocess todrive tdfileid <id> tdsheet <name> tdupdatesheet
print group-members group <email1> <email2> ...
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": {
"group_emails": "<group_emails>",
"output_sheet_id": "<output_sheet_id>",
"output_sheet_name": "<output_sheet_name>"
},
"name": "get_group_permissions_to_sheet"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| group_emails | Yes | ||
| output_sheet_id | Yes | ||
| output_sheet_name | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |