gworkspace-mcp

Connect to a Google Spreadsheet and discover everything about it.

Args: spreadsheet_url: Spreadsheet URL or ID script_url: Optional. The Apps Script URL or ID (from Extensions > Apps Script). Container-bound scripts don't appear in Drive API (Google limitation), so pass the script URL for full discovery. If omitted, only sheet structure is returned.

Returns: sheet structure, and if script_url is provided: all files with functions, triggers, and deployments.

List all functions in a script project with their file, signature, and line numbers.

Get the source code of a specific function by name.

Get the full source code of a file in the script project.

Replace a specific function's source code. Only that function is modified.

Add a new function to an existing file. Appends at the end.

Delete a function from the script project.

Replace the entire content of a file in the script project.

Create a new .gs file in the script project.

Execute a function in a deployed script. Requires API Executable deployment.

Read values from a sheet. Pass spreadsheet URL or ID.

Write values to a sheet range. values is a 2D array.

Append rows to the end of a sheet.

Get full structure of a spreadsheet: sheets, named ranges, protected ranges.

Format a range. Colors as hex (#RRGGBB). h_align: LEFT/CENTER/RIGHT.

Protect a sheet or range. If range_a1 is None, protects the entire sheet.

Add conditional formatting. rule_type: NUMBER_GREATER, NUMBER_LESS, NUMBER_EQ, TEXT_CONTAINS, TEXT_NOT_CONTAINS, CUSTOM_FORMULA. For CUSTOM_FORMULA, condition_value is the formula (e.g., '=A1>8').

Add data validation. validation_type: DROPDOWN, CHECKBOX, NUMBER, DATE. For DROPDOWN, pass values as list of options.

Create a Google Sheets Table (the structured table feature, Ctrl+Alt+T). Converts a data range into a formal table with headers, banding, and filtering.

Copy a sheet from one spreadsheet to another.

Copy a Drive file (spreadsheet, doc, etc). Returns the new file ID and URL.

Move a file to a different folder.

Search Drive files. Uses Drive query syntax. Examples: "name contains 'report'", "mimeType='application/vnd.google-apps.spreadsheet'".

Create a new Google Spreadsheet. Returns ID and URL.

Send an email via Gmail. Set html=True for HTML body. cc/bcc are comma-separated email addresses.

Send an HTML email with optional plain-text fallback.

Preview an email without sending it. Returns the formatted message.

List all triggers for a script project.

Create a time-driven trigger via Apps Script execution. Generates and runs trigger setup code in the script.

Options:

• every_minutes: 1, 5, 10, 15, 30

• every_hours: 1, 2, 4, 6, 8, 12

• day_of_week + hour: weekly trigger (MONDAY-SUNDAY, hour 0-23)

• hour only: daily trigger at that hour

Delete a trigger by ID. Use trigger_list to find IDs.

Generate functional documentation for a spreadsheet project. Analyzes the spreadsheet structure, script functions, triggers, and manifest to produce a complete technical document.

Args: spreadsheet_url: Spreadsheet URL or ID script_url: Optional Apps Script URL or ID output: "sheet" writes a Documentacion tab in the spreadsheet, "text" returns the doc as text