Skip to main content
Glama

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> ...
    

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
group_emailsYes
output_sheet_idYes
output_sheet_nameYes

Output Schema

TableJSON Schema
NameRequiredDescriptionDefault
resultYes
Behavior3/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

With no annotations, the description carries the full burden. It discloses the output to a Google Sheet and multiprocess redirect, but does not address permissions, error conditions, or whether the sheet is created or overwritten. The description implies a read operation but writing to a sheet is a side effect.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness4/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is concise and well-structured, with a purpose statement, usage note, parameter list, and GAM pattern. It is front-loaded and wastes no words, though the GAM pattern may be extraneous for some users.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness3/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

The description covers core functionality and parameters but does not explain the return value or behavior (e.g., whether the sheet is appended or overwritten). The presence of an output schema may help, but without it, the description leaves some gaps.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters4/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema coverage is 0%, so the description fully compensates by explaining all three parameters: group_emails as list of email addresses, output_sheet_id as Google Sheet ID, and output_sheet_name as tab name. This adds significant meaning beyond the schema names.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description clearly states the tool retrieves group members and their roles, outputting to a Google Sheet. It uses a specific verb and resource, distinguishing it from sibling tools that audit other aspects.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines3/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description implies usage for exporting group member roles to a sheet and mentions multiprocess for speed, but it does not explicitly state when to use this tool over alternatives like audit_all_permissions or reapply_user_group_permissions. The GAM pattern provides technical context but lacks comparative guidance.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

Install Server

Other Tools

Latest Blog Posts

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/ktibbs9417/gamcp'

If you have feedback or need assistance with the MCP directory API, please join our Discord server