get_user_email_count_to_sheet
Retrieve email counts for specific Gmail labels across multiple users and output results to a Google Sheet for analysis.
Instructions
Retrieves email counts for specific labels across multiple users.
Uses multiprocess redirect if outputting to a sheet.
Args:
user_emails: List of user emails to query.
label: The Gmail label to count (e.g., 'INBOX', 'TRASH').
output_sheet_id: Optional Sheet ID for output.
output_sheet_name: Tab name for sheet output.
GAM pattern:
gam [redirect csv - multiprocess todrive ...]
user <email1>,<email2> show messages label <label> countsonly
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": {
"user_emails": "<user_emails>"
},
"name": "get_user_email_count_to_sheet"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| label | No | INBOX | |
| user_emails | Yes | ||
| output_sheet_id | No | ||
| output_sheet_name | No | Email Counts |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |