{"report":{"v":1,"package":"@a-bonus/google-docs-mcp","version":"2.0.1","ranAt":"2026-11-16T11:30:24.989Z","install":{"ok":true,"integrity":"sha512-puwoFYBHB9oTR8gZO9uifQVK1R/zX2k/oS85ZW60rZ3q5UsXwZBfJJjc83+n2SpRsTRBphllcLTNRxkmNL/VYQ==","deps":272,"scripts":["protobufjs"],"bins":["google-docs-mcp"],"license":"ISC","engines":"node >=22","bin":"google-docs-mcp"},"start":{"ok":true,"ms":966,"serverName":"Ultimate Google Docs & Sheets MCP Server","serverVersion":"2.0.1","protocol":"2025-06-18","stderr":"/node_modules/@a-bonus/google-docs-mcp/dist/clients.js:161:36)\n    at async Object.execute (file:///app/node_modules/@a-bonus/google-docs-mcp/dist/tools/gmail/listLabels.js:10:27)\n    at async file:///app/node_modules/fastmcp/dist/chunk-ASOZUCE2.js:1842:37\n    at async wrappedHandler (file:///app/node_modules/@modelcontextprotocol/sdk/dist/esm/server/index.js:114:32)\n[INFO] Attempting to authorize Google API client...\n[INFO] Attempting OAuth 2.0 authentication...\n[INFO] No saved token found. Starting interactive authentication flow...\n[ERROR] FATAL: Failed to initialize Google API client: Error: No OAuth credentials found. Either set GOOGLE_CLIENT_ID and GOOGLE_CLIENT_SECRET, or download your OAuth client JSON from the Google Cloud Console and save it as /app/node_modules/@a-bonus/google-docs-mcp/credentials.json. Then run `npx @a-bonus/google-docs-mcp auth` to authorize.\n    at loadClientSecrets (file:///app/node_modules/@a-bonus/google-docs-mcp/dist/auth.js:118:19)\n    at async authenticate (file:///app/node_modules/@a-bonus/google-docs-mcp/dist/auth.js:228:42)\n    at async initializeGoogleClient (file:///app/node_modules/@a-bonus/google-docs-mcp/dist/clients.js:30:28)\n    at async getGmailClient (file:///app/node_modules/@a-bonus/google-docs-mcp/dist/clients.js:161:36)\n    at async Object.execute (file:///app/node_modules/@a-bonus/google-docs-mcp/dist/tools/gmail/listDrafts.js:24:27)\n    at async file:///app/node_modules/fastmcp/dist/chunk-ASOZUCE2.js:1842:37\n    at async wrappedHandler (file:///app/node_modules/@modelcontextprotocol/sdk/dist/esm/server/index.js:114:32)\n"},"tools":[{"name":"readDocument","description":"Reads the content of a Google Document. Returns plain text by default. Use format='markdown' to get formatted content suitable for editing and re-uploading with replaceDocumentWithMarkdown, or format='json' for the raw document structure.","params":["documentId","format","maxLength","tabId","suggestionsViewMode"]},{"name":"listTabs","description":"Lists all tabs in a document with their IDs and hierarchy. Use the returned tab IDs with other tools' tabId parameter to target a specific tab.","params":["documentId","includeContent"]},{"name":"renameTab","description":"Renames a tab in a Google Docs document. Use listDocumentTabs to get tab IDs first.","params":["documentId","tabId","newTitle"]},{"name":"addTab","description":"Adds a new tab to a Google Docs document. Optionally set the tab title, position, parent tab (for nesting), and icon emoji. Returns the new tab's ID and properties.","params":["documentId","title","parentTabId","index","iconEmoji"]},{"name":"appendText","description":"Appends plain text to the end of a document. For formatted content, use appendMarkdown instead.","params":["documentId","text","addNewlineIfNeeded","tabId","suggestMode"]},{"name":"insertText","description":"Inserts text at a specific character index within a document. Use readDocument with format='json' to determine the correct index.","params":["documentId","text","index","tabId","suggestMode"]},{"name":"deleteRange","description":"Deletes content within a character range [startIndex, endIndex) from a document. Use readDocument with format='json' to determine index positions.","params":["documentId","startIndex","endIndex","tabId","suggestMode"]},{"name":"modifyText","description":"Combines text replacement/insertion and formatting in one atomic operation. Can insert text at a position, replace a range or found text, apply formatting, or any combination. Use readGoogleDoc with format='json' to determine indices.","params":["documentId","target","text","style","tabId","suggestMode"]},{"name":"findAndReplace","description":"Replaces all occurrences of a text string throughout the document (or a specific tab). Returns the number of replacements made. Use an empty replaceText to delete all matches.","params":["documentId","findText","replaceText","matchCase","tabId","suggestMode"]},{"name":"findElement","description":"Locates elements in a Google Document. With textQuery, returns the document index range (startIndex/endIndex) of every non-overlapping occurrence of the text — use each as a range for deleteRange or the text-styling tools, or its startIndex as an insertText location. With elementType \"paragraph\" or \"table\", lists those elements with their ranges and a text preview. Limitations: searches the first tab only (on multi-tab documents, tabs 2+ are not searched); paragraph listing covers top-level body paragraphs only, not paragraphs inside table cells (textQuery does search inside cells, but only one level deep — text in a table nested inside a table cell is not searched). At least one of textQuery or elementType is required.","params":["documentId","textQuery","elementType"]},{"name":"listSuggestions","description":"Lists pending suggestion threads in a Google Doc, with the suggestion IDs needed for manageSuggestions (accept/reject/delete). Reads with suggestionsViewMode=SUGGESTIONS_INLINE across body, tabs, headers, footers and footnotes.","params":["documentId"]},{"name":"manageSuggestions","description":"Accepts, rejects or deletes pending suggestion threads in a Google Doc (created in Suggesting mode or via suggestMode=true writes). Call listSuggestions first to get suggestion IDs.","params":["documentId","action","suggestionIds"]},{"name":"insertTable","description":"Inserts an empty table with the specified number of rows and columns at a character index in the document.","params":["documentId","rows","columns","index","tabId"]},{"name":"insertTableWithData","description":"Inserts a table pre-populated with data at a specific index in the document. All cell content is inserted in a single operation. Optionally bolds the first row as a header. Ragged rows are padded with empty cells to match the widest row.","params":["documentId","data","index","hasHeaderRow","tabId"]},{"name":"insertPageBreak","description":"Inserts a page break at a character index in the document.","params":["documentId","index","tabId"]},{"name":"insertSectionBreak","description":"Inserts a section break at a character index in the document. A section break starts a new section whose style (page orientation, margins, columns, page numbering) can then be customized with updateSectionStyle. Use sectionType=\"NEXT_PAGE\" when you want the new section to start on a fresh page (required for mixing portrait and landscape pages in a single document) and \"CONTINUOUS\" when the new section should begin inline without a page break.","params":["documentId","index","sectionType","tabId"]},{"name":"updateSectionStyle","description":"Updates the style of a section identified by a character range. The range must cover the section whose style is changing — typically from the character right after an inserted section break to any index inside that section. Supports flipping page orientation (landscape <-> portrait), setting margins, and changing the section type. Common workflow for a landscape page: call insertSectionBreak with sectionType=\"NEXT_PAGE\" before the landscape content, call insertSectionBreak again after it, then call updateSectionStyle on the range between the two breaks with flipPageOrientation=true.","params":["documentId","startIndex","endIndex","flipPageOrientation","sectionType","marginTop","marginBottom","marginLeft","marginRight","pageNumberStart","tabId"]},{"name":"insertImage","description":"Inserts an inline image into a Google Document. Provide either a publicly accessible URL or a local file path. Local files are automatically uploaded to Google Drive before insertion.","params":["documentId","imageUrl","localImagePath","index","width","height","tabId"]},{"name":"insertDateChip","description":"Inserts a Google Docs date smart chip at a specific paragraph location. This creates a real date element, not plain text.","params":["documentId","index","date","timeZoneId","locale","dateFormat","timeFormat","tabId"]},{"name":"insertPerson","description":"Inserts a Google Docs person smart chip at a specific paragraph location using an email address.","params":["documentId","index","email","name","tabId"]},{"name":"insertRichLink","description":"Inserts a Google Docs rich link smart chip at a specific paragraph location. Use for Google resource links such as Drive files or Calendar events.","params":["documentId","index","uri","mimeType","title","tabId"]},{"name":"listSmartChips","description":"Lists smart chips in a Google Document, including date elements, person mentions, and rich links.","params":["documentId","tabId"]},{"name":"cloneTable","description":"Clones a source Google Docs table into a target document, preserving text, column widths, row styles, cell styles, and pinned header rows where supported.","params":["documentId","sourceDocumentId","sourceTableId","index","sourceTabId","targetTabId","copyColumnWidths","copyRowStyles","copyCellStyles","copyPinnedHeaderRows","copyHeaderBold"]},{"name":"listDocumentTables","description":"Lists tables in a Google Document with stable MCP table IDs, ranges, and dimensions. Use this before table-specific editing tools.","params":["documentId","tabId"]},{"name":"getTableStructure","description":"Returns detailed structure for a table in a Google Document, including row/column counts and extracted cell text.","params":["documentId","tableId","tabId"]},{"name":"findSectionsByHeading","description":"Finds heading-based sections in a Google Document and reports heading ranges plus the first table that follows each heading.","params":["documentId","headings","tabId"]},{"name":"replaceTableRowData","description":"Replaces the plain-text contents of a single row in an existing Google Docs table while preserving the table structure and formatting.","params":["documentId","tableId","rowIndex","values","tabId"]},{"name":"deleteTableRows","description":"Deletes one or more rows from an existing Google Docs table without replacing the whole document.","params":["documentId","tableId","rowStart","rowCount","tabId"]},{"name":"applyTextStyle","description":"Applies character-level formatting (bold, italic, color, font, etc.) to text identified by a character range or by searching for a text string. This is the primary tool for styling text in a document.","params":["documentId","target","style","tabId","suggestMode"]},{"name":"batchApplyTextStyle","description":"Applies character-level formatting (bold, italic, color, font, etc.) to MANY ranges in a single tool call, instead of one applyTextStyle call per range. Built for scripts that colour dozens or hundreds of cues: do one readDocument (format=\"json\") pass, compute every range from that one read, then pass them all here as one operations[] array. Internally chunks into batches of up to 50 requests per Docs API call (Google's per-request-array limit), so 100+ operations still cost only 2-3 API calls instead of 100+ round trips.","params":["documentId","operations","tabId","suggestMode"]},{"name":"applyParagraphStyle","description":"Applies paragraph-level formatting (alignment, spacing, heading styles) to paragraphs identified by a character range or by searching for text. Use namedStyleType to set heading levels (HEADING_1 through HEADING_6).","params":["documentId","target","style","tabId","suggestMode"]},{"name":"updateTableCellStyle","description":"Applies cell-level formatting to a Google Docs table range, including background color, alignment, padding, and borders.","params":["documentId","tableId","rowStart","rowEnd","columnStart","columnEnd","backgroundColor","contentAlignment","paddingTopPt","paddingBottomPt","paddingLeftPt","paddingRightPt","tabId"]},{"name":"updateTableBorders","description":"Applies table border styles to a Google Docs table range. Supports top/bottom/left/right borders across a cell range.","params":["documentId","tableId","rowStart","rowEnd","columnStart","columnEnd","top","bottom","left","right","tabId"]},{"name":"updateTableColumnWidth","description":"Sets fixed widths for one or more columns in an existing Google Docs table.","params":["documentId","tableId","columnIndices","widthPt","tabId"]},{"name":"updateTableRowStyle","description":"Applies row-level styling to a Google Docs table, including minimum row height and optional pinned header rows.","params":["documentId","tableId","rowIndices","minRowHeightPt","preventOverflow","pinnedHeaderRowsCount","tabId"]},{"name":"listComments","description":"Lists all comments in a document with their IDs, authors, status, and quoted text. Returns data needed to call getComment, replyToComment, resolveComment, or deleteComment.","params":["documentId"]},{"name":"getComment","description":"Gets a specific comment and its full reply thread. Use listComments first to find the comment ID.","params":["documentId","commentId"]},{"name":"addComment","description":"Adds a comment to the document at the specified text range. Use listComments to retrieve the comment ID after creation. Note: programmatically created comments appear in the comments panel but may not show as anchored highlights in the document UI.","params":["documentId","startIndex","endIndex","content"]},{"name":"replyToComment","description":"Adds a reply to an existing comment thread. Use listComments or getComment to find the comment ID.","params":["documentId","commentId","content"]},{"name":"resolveComment","description":"Marks a comment as resolved. Note: resolved status may not persist in the Google Docs UI due to a Drive API limitation.","params":["documentId","commentId"]},{"name":"deleteComment","description":"Permanently deletes a comment and all its replies from the document.","params":["documentId","commentId"]},{"name":"listDocuments","description":"Lists Google Documents in your Drive, optionally filtered by name or content. Use modifiedAfter to find recently changed documents.","params":["maxResults","query","orderBy","modifiedAfter"]},{"name":"searchDocuments","description":"Searches for documents by name, content, or both. Use listDocuments for browsing and this tool for targeted queries.","params":["query","searchIn","maxResults","modifiedAfter"]},{"name":"listDriveFiles","description":"Lists files across Google Drive with optional filtering by type, folder, and ownership. Unlike listDocuments (which only returns Google Docs), this tool works with all file types (Sheets, PDFs, images, folders, etc.) and supports sort direction and size-based ordering. Use mimeType shortcuts: \"document\", \"spreadsheet\", \"presentation\", \"folder\", \"form\", \"pdf\", \"zip\" or pass any full MIME type string.","params":["maxResults","mimeType","folderId","orderBy","sortDirection","ownedByMe","sharedWithMe","modifiedAfter"]},{"name":"searchDriveFiles","description":"Searches across all file types in Google Drive by name or content. Unlike searchDocuments (which only searches Google Docs), this tool finds Sheets, PDFs, presentations, folders, and any other Drive file. Supports filtering by MIME type, scoping to a specific folder subtree, controllable sort order, and pagination via pageToken.","params":["query","searchIn","mimeType","folderId","orderBy","sortDirection","maxResults","modifiedAfter","pageToken"]},{"name":"getDocumentInfo","description":"Gets metadata about a document including its name, owner, sharing status, and modification history.","params":["documentId"]},{"name":"createFolder","description":"Creates a new folder in Google Drive. Optionally places it inside an existing parent folder.","params":["name","parentFolderId"]},{"name":"listFolderContents","description":"Lists files and subfolders within a Drive folder. Use folderId='root' to browse the top-level of the Drive.","params":["folderId","includeSubfolders","includeFiles","maxResults"]},{"name":"getFolderInfo","description":"Gets metadata about a Drive folder including its name, owner, sharing status, and parent folder.","params":["folderId"]},{"name":"moveFile","description":"Moves a file or folder to a different Drive folder. By default adds the new parent while keeping existing parents; set removeFromAllParents=true for a true move.","params":["fileId","newParentId","removeFromAllParents"]},{"name":"copyFile","description":"Creates a copy of a file or document in Google Drive. Returns the new copy's ID and URL.","params":["fileId","newName","parentFolderId"]},{"name":"renameFile","description":"Renames a file or folder in Google Drive. Returns the updated file info.","params":["fileId","newName"]},{"name":"deleteFile","description":"Moves a file or folder to the trash, or permanently deletes it. Set permanent=true for irreversible deletion.","params":["fileId","permanent"]},{"name":"createDocument","description":"Creates a new empty Google Document. Optionally places it in a specific folder and adds initial text content. For a native Markdown (.md) file instead, use createMarkdownFile.","params":["title","parentFolderId","initialContent","contentFormat"]},{"name":"createMarkdownFile","description":"Creates a native Markdown (.md) file in Google Drive. Unlike createDocument (which makes a Google Doc and converts markdown to formatted content), this keeps the raw .md source so Docs/Drive edit it natively with live preview and comments preserved.","params":["title","parentFolderId","content"]},{"name":"readMarkdownFile","description":"Reads the raw markdown source of a native .md file in Drive (mimeType text/markdown). For Google Docs documents, use readDocument instead.","params":["fileId","maxLength"]},{"name":"updateMarkdownFile","description":"Replaces (or appends to) the raw markdown source of a native .md file in Drive. Edits apply as file content, not as Docs suggestions: use listSuggestions/manageSuggestions only for Google Docs.","params":["fileId","content","append"]},{"name":"createDocumentFromTemplate","description":"Creates a new document by copying an existing template and optionally replacing placeholder text. Provide key-value pairs in the replacements parameter to substitute template variables.","params":["templateId","newTitle","parentFolderId","replacements"]},{"name":"downloadFile","description":"Downloads any file from Google Drive to a local path. For Google Workspace files (Docs, Sheets, Slides), exports to a specified format (defaults to text/markdown for Docs, text/csv for Sheets). For regular files (PDFs, images, etc.), downloads the raw bytes. Optionally extracts and returns text content for text-based files.","params":["fileId","savePath","exportMimeType","extractText","returnAs"]},{"name":"setFilePermission","description":"Sets a sharing permission on a Drive file or folder. Common case: type='anyone' with role='reader' enables 'anyone with the link can view'. Use type='user' with emailAddress to grant a specific person access. Returns the created permission record.","params":["fileId","role","type","emailAddress","domain","sendNotificationEmail","allowFileDiscovery"]},{"name":"readSpreadsheet","description":"Reads data from a range in a spreadsheet. Returns rows as arrays. Use A1 notation for the range (e.g., \"Sheet1!A1:C10\").","params":["spreadsheetId","range","valueRenderOption"]},{"name":"writeSpreadsheet","description":"Writes data to a range in a spreadsheet, overwriting existing values. Use appendRows to add data without overwriting.","params":["spreadsheetId","range","values","valueInputOption"]},{"name":"batchWrite","description":"Writes data to multiple ranges in a single API call. More efficient than multiple separate writeSpreadsheet calls when updating several ranges at once.","params":["spreadsheetId","data","valueInputOption"]},{"name":"appendRows","description":"Appends rows to the end of a sheet. Data is added after the last row with content in the specified range.","params":["spreadsheetId","range","values","valueInputOption"]},{"name":"clearRange","description":"Clears all cell values in a range without deleting the cells themselves. Formatting is preserved.","params":["spreadsheetId","range"]},{"name":"getSpreadsheetInfo","description":"Gets metadata about a spreadsheet including its title, URL, and a list of all sheets with their dimensions.","params":["spreadsheetId"]},{"name":"addSheet","description":"Adds a new sheet (tab) to an existing spreadsheet. Returns the new sheet's title and ID.","params":["spreadsheetId","sheetTitle"]},{"name":"createSpreadsheet","description":"Creates a new spreadsheet. Optionally places it in a specific folder and populates it with initial data.","params":["title","parentFolderId","initialData"]},{"name":"listSpreadsheets","description":"Lists spreadsheets in your Drive, optionally filtered by name or content.","params":["maxResults","query","orderBy"]},{"name":"deleteSheet","description":"Deletes a sheet (tab) from a spreadsheet. Use getSpreadsheetInfo to find the numeric sheet ID.","params":["spreadsheetId","sheetId"]},{"name":"renameSheet","description":"Renames a sheet (tab) in a spreadsheet. Use getSpreadsheetInfo to find the numeric sheet ID.","params":["spreadsheetId","sheetId","newName"]},{"name":"duplicateSheet","description":"Duplicates a sheet (tab) within a spreadsheet, copying all values, formulas, formatting, validations, and conditional formatting. Use getSpreadsheetInfo to find the numeric sheet ID.","params":["spreadsheetId","sheetId","newSheetName"]},{"name":"copySheetTo","description":"Copies a sheet (tab) from one spreadsheet to another spreadsheet. Use getSpreadsheetInfo to find the numeric sheet ID. The copied sheet will be appended to the destination spreadsheet.","params":["sourceSpreadsheetId","sheetId","destinationSpreadsheetId"]},{"name":"insertRows","description":"Inserts empty rows into a sheet, shifting existing rows down (like \"Insert rows above\" in the Sheets UI). Formulas and references to shifted cells are adjusted by Google Sheets automatically. Use this instead of rewriting a block of data when new rows are needed in the middle of a sheet.","params":["spreadsheetId","sheetName","startRow","count","inheritFromBefore"]},{"name":"deleteRows","description":"Deletes a range of rows from a sheet, shifting the rows below up (like \"Delete rows\" in the Sheets UI). Unlike clearRange, the rows themselves are removed, including their formatting. This cannot be undone through the API — read the range first if unsure.","params":["spreadsheetId","sheetName","startRow","endRow"]},{"name":"formatCells","description":"Applies formatting to a range of cells in a spreadsheet. Supports bold, italic, font size, text color, background color, alignment, and number format. Use range '1:1' to format an entire header row, 'A:A' for an entire column, or 'A1:D1' for specific cells. Use numberFormat to control how values are displayed (e.g. as numbers, text, dates) or to clear a format by setting type to 'TEXT'.","params":["spreadsheetId","range","bold","italic","fontSize","foregroundColor","backgroundColor","horizontalAlignment","verticalAlignment","wrapStrategy","numberFormat"]},{"name":"readCellFormat","description":"Reads the formatting/style of cells in a given range. Returns formatting details like bold, italic, fontSize, fontFamily, colors, alignment, borders, and number format per cell.","params":["spreadsheetId","range"]},{"name":"copyFormatting","description":"Copies formatting (not values) from a source range to a destination range within the same spreadsheet. Copies bold, colors, borders, number formats, etc.","params":["spreadsheetId","sourceSheetName","sourceRange","destinationSheetName","destinationRange"]},{"name":"freezeRowsAndColumns","description":"Pins rows and/or columns so they stay visible when scrolling. Use frozenRows=1 to freeze a header row. Set a value to 0 to unfreeze.","params":["spreadsheetId","sheetName","frozenRows","frozenColumns"]},{"name":"setColumnWidths","description":"Sets the width (in pixels) of one or more columns in a spreadsheet. Accepts multiple column specs in a single call, each targeting a single column or a contiguous range (e.g., \"A\", \"B:D\").","params":["spreadsheetId","sheetName","columnWidths"]},{"name":"autoResizeColumns","description":"Auto-resizes columns in a spreadsheet to fit their content. Optionally restrict to a column range (e.g., \"A:S\"); defaults to all columns.","params":["spreadsheetId","sheetName","columns"]},{"name":"autoResizeRows","description":"Auto-resizes rows in a spreadsheet to fit their content. Optionally restrict to a row range (e.g., startRow=2, endRow=50); defaults to all rows.","params":["spreadsheetId","sheetName","startRow","endRow"]},{"name":"setRowHeights","description":"Sets a fixed pixel height for a range of rows in a spreadsheet. Useful for ensuring rows are tall enough to display wrapped text.","params":["spreadsheetId","sheetName","startRow","endRow","pixelSize"]},{"name":"setCellBorders","description":"Sets borders on a range of cells. Each side (top, bottom, left, right, innerHorizontal, innerVertical) can be configured independently with a style and color. Use style \"NONE\" to remove a border.","params":["spreadsheetId","range","top","bottom","left","right","innerHorizontal","innerVertical"]},{"name":"protectRange","description":"Locks (protects) a range or an entire sheet to prevent accidental edits. Optionally specify a description. The protection applies to the authenticated user's account.","params":["spreadsheetId","sheetName","range","description","warningOnly"]},{"name":"getConditionalFormatting","description":"Lists all conditional formatting rules for a sheet as JSON. Each rule includes its index (needed for deleteConditionalFormatting), kind (BOOLEAN or GRADIENT), ranges, condition type/values, and applied formats (colors, bold, italic).","params":["spreadsheetId","sheetName"]},{"name":"deleteConditionalFormatting","description":"Deletes one or more conditional formatting rules from a sheet by their index. Use getConditionalFormatting to list existing rules and their indices.","params":["spreadsheetId","sheetName","ruleIndices"]},{"name":"setDropdownValidation","description":"Adds or removes a dropdown list on a range of cells. Provide values to create a dropdown restricting input to those options. Omit values to remove dropdown validation from the range.","params":["spreadsheetId","range","values","strict","inputMessage"]},{"name":"addConditionalFormatting","description":"Adds a conditional formatting rule to one or more ranges in a spreadsheet. Applies a format (background color, bold, text color, etc.) when cells meet a specified condition. Use CUSTOM_FORMULA for complex conditions like \"=$A1>$B1\". Note: each call appends a new rule — use deleteConditionalFormatting to remove existing rules before re-adding.","params":["spreadsheetId","sheetName","ranges","conditionType","conditionValues","backgroundColor","bold","italic","strikethrough","underline","foregroundColor","fontSize"]},{"name":"groupRows","description":"Creates collapsible row groups in a Google Sheet using the Sheets API addDimensionGroup request. Each group specifies a range of rows (1-based, inclusive) to collapse.","params":["spreadsheetId","sheetName","groups"]},{"name":"ungroupAllRows","description":"Removes all row groupings from a sheet by deleting the entire row dimension group. Use before re-running groupRows to prevent duplicate collapse widgets from accumulating across report refreshes.","params":["spreadsheetId","sheetName","totalRows"]},{"name":"createSheetsComment","description":"Creates a new comment in a Google Spreadsheet. When you target a specific cell or range, a click-through link to that location is added to the comment body by default (includeCellLink), letting users jump to the cell. Note: the Drive API cannot natively anchor spreadsheet comments to a cell in the Sheets UI, so the comment itself appears under \"All comments\" — the click-through link is the supported way to navigate to the target.","params":["spreadsheetId","content","sheetName","cell","range","includeCellLink"]},{"name":"createSheetsCellNote","description":"Creates or replaces a native Google Sheets cell note on a cell or range. Use this when the review text must be attached to a specific cell in the Sheets UI. This is a cell note, not a threaded Drive comment.","params":["spreadsheetId","range","content"]},{"name":"listSheetsComments","description":"Lists all comments in a Google Spreadsheet. Filter by sheet name, specific row(s), specific cell, or a cell range. Returns comment IDs needed for getSheetsComment, replyToSheetsComment, resolveSheetsComment, or deleteSheetsComment.","params":["spreadsheetId","sheetName","row","rows","cell","range","includeResolved"]},{"name":"getSheetsComment","description":"Gets a specific comment and its full reply thread from a Google Spreadsheet. Use listSheetsComments first to find the comment ID.","params":["spreadsheetId","commentId"]},{"name":"replyToSheetsComment","description":"Adds a reply to an existing comment thread in a Google Spreadsheet. Use listSheetsComments or getSheetsComment to find the comment ID.","params":["spreadsheetId","commentId","content"]},{"name":"resolveSheetsComment","description":"Marks a comment as resolved in a Google Spreadsheet. Note: resolved status may not persist in the Sheets UI due to a Drive API limitation.","params":["spreadsheetId","commentId"]},{"name":"deleteSheetsComment","description":"Permanently deletes a comment and all its replies from a Google Spreadsheet.","params":["spreadsheetId","commentId"]},{"name":"createTable","description":"Creates a new named table with specific column types. Tables provide structured data with typed columns, automatic formatting, and special features like dropdown validation.","params":["spreadsheetId","name","range","columns","hasHeaderRow","hasFooterRow"]},{"name":"listTables","description":"Lists all tables in a spreadsheet or specific sheet. Use this to discover table names and IDs before performing table operations.","params":["spreadsheetId","sheetName"]},{"name":"getTable","description":"Gets detailed information about a specific table including its columns, range, and properties. Use the table name or ID returned by listTables.","params":["spreadsheetId","tableIdentifier"]},{"name":"deleteTable","description":"Deletes a table from a spreadsheet. By default, only removes the table object and formatting while keeping the cell data. Optionally clears the data as well.","params":["spreadsheetId","tableIdentifier","deleteData"]},{"name":"updateTableRange","description":"Modifies a table's dimensions (add/remove rows and columns) by updating its range. The new range must include the original table range.","params":["spreadsheetId","tableIdentifier","range"]},{"name":"appendTableRows","description":"Appends rows to the end of a table using table-aware insertion. This method respects footers and automatically inserts rows before the footer if one exists.","params":["spreadsheetId","tableIdentifier","values","valueInputOption"]},{"name":"insertChart","description":"Inserts a chart into a Google Sheet. Supports bar, column, line, area, scatter, pie, donut, and treemap (hierarchical) chart types. For treemap charts, the data must have a label column and a parent label column (use empty string for root nodes) plus a numeric size column. Chart is placed as an overlay at the specified anchor cell.","params":["spreadsheetId","sheetName","chartType","stackedType","title","dataRange","headerRow","labelColumnIndex","parentColumnIndex","valueColumnIndex","anchorRow","anchorColumn","offsetXPixels","offsetYPixels","widthPixels","heightPixels"]},{"name":"deleteChart","description":"Deletes a chart from a Google Spreadsheet by chart ID. The chart ID is returned when a chart is created with insertChart.","params":["spreadsheetId","chartId"]},{"name":"replaceDocumentWithMarkdown","description":"Replaces the entire document body with content parsed from markdown. Supports headings, bold, italic, strikethrough, links, and bullet/numbered lists. Use readDocument with format='markdown' first to get the current content, edit it, then call this tool to apply changes.","params":["documentId","markdown","preserveTitle","tabId","firstHeadingAsTitle","suggestMode"]},{"name":"appendMarkdown","description":"Appends formatted content to the end of a document using markdown syntax. Supports headings, bold, italic, strikethrough, links, and bullet/numbered lists. Use this instead of appendText when you need formatting.","params":["documentId","markdown","addNewlineIfNeeded","tabId","firstHeadingAsTitle","suggestMode"]},{"name":"replaceRangeWithMarkdown","description":"Replaces a specific character range in a document with formatted markdown content. Use readDocument with format='json' to determine the start and end indices of the content you want to replace. Supports headings, bold, italic, strikethrough, links, bullet/numbered lists, code blocks, horizontal rules, and tables.","params":["documentId","startIndex","endIndex","markdown","tabId","suggestMode"]},{"name":"listMessages","description":"Lists Gmail messages for the authenticated user. Supports the full Gmail search syntax via the q parameter (e.g. \"is:unread\", \"from:alice@example.com\", \"subject:invoice newer_than:7d\"). Returns message IDs with sender, subject, date, and snippet for each result.","params":["maxResults","q","labelIds","includeSpamTrash"]},{"name":"getMessage","description":"Fetches a single Gmail message by ID with headers, decoded plain-text body, HTML body, and a list of attachments (metadata only). Use listMessages to discover message IDs.","params":["messageId","format"]},{"name":"sendEmail","description":"Sends a plain-text email from the authenticated Gmail account. Supports cc/bcc and optional threading by passing replyToMessageId (which copies threadId and sets In-Reply-To/References so the reply lands in the same thread).","params":["to","subject","body","cc","bcc","replyToMessageId"]},{"name":"trashMessage","description":"Moves a Gmail message to Trash. This is the same as clicking Delete in the Gmail UI — reversible from the Trash folder for 30 days. Not a permanent delete.","params":["messageId"]},{"name":"modifyMessageLabels","description":"Adds and/or removes labels on a Gmail message. Use this to star (add STARRED), archive (remove INBOX), mark read (remove UNREAD), or apply custom labels. Discover label IDs with listLabels. At least one of addLabelIds or removeLabelIds must be provided.","params":["messageId","addLabelIds","removeLabelIds"]},{"name":"listLabels","description":"Lists all Gmail labels for the authenticated user, including system labels (INBOX, SENT, STARRED, UNREAD, etc.) and custom user-created labels. Use the returned IDs with modifyMessageLabels or listMessages labelIds filter.","params":[]},{"name":"createDraft","description":"Creates a Gmail draft (does NOT send). Use this for AI-composed emails that the user should review before sending. The draft appears in the Gmail Drafts folder and can be sent later with sendDraft, edited with updateDraft, or deleted with deleteDraft. Supports threading via replyToMessageId and local file attachments. The response includes the From address of the account the draft was created in.","params":["to","subject","body","cc","bcc","replyToMessageId","attachments"]},{"name":"listDrafts","description":"Lists Gmail drafts for the authenticated user. Returns draft IDs along with the recipient, subject, snippet, and date for each. Use sendDraft, updateDraft, or deleteDraft to act on a returned draft.","params":["maxResults","q"]},{"name":"getDraft","description":"Fetches a single Gmail draft by ID with full headers, body, and a list of attachments (metadata only). Use listDrafts to discover draft IDs.","params":["draftId"]},{"name":"updateDraft","description":"Replaces the contents of an existing Gmail draft. The new contents fully overwrite the old draft (this is a full replace, not a patch), attachments included: pass attachments again or the draft loses them. The draft stays in its thread unless replyToMessageId names another message. Use this when iterating on an AI-composed draft before sending.","params":["draftId","to","subject","body","cc","bcc","replyToMessageId","attachments"]},{"name":"sendDraft","description":"Sends an existing Gmail draft. After sending, the draft is removed and the message appears in Sent. This is the second half of the compose-review-send flow that pairs with createDraft.","params":["draftId"]},{"name":"deleteDraft","description":"Permanently deletes a Gmail draft. This is irreversible — the draft is removed entirely, not moved to Trash. Use when an AI-composed draft was rejected or replaced.","params":["draftId"]},{"name":"triageInbox","description":"Composite tool: fetches the user's most recent unread Gmail messages with full content and heuristic categorization in a single call. Returns headers, body excerpts, labels, plus per-message signals (newsletter, meeting reference, contains question, action requested) AND aggregate stats (total unread, top senders, breakdown by category). Designed for AI inbox triage workflows — use the returned data to decide which messages need a reply, can be archived, or warrant a draft response. Pairs naturally with createDraft, modifyMessageLabels, and trashMessage.","params":["maxResults","additionalQuery","bodyExcerptLength"]},{"name":"listEvents","description":"Lists or searches Google Calendar events. Defaults to the user's primary calendar starting now. Use timeMin/timeMax (RFC3339 timestamps) to bound the window, q for free-text search, and maxResults to cap the count. Returns event IDs needed for updateEvent and deleteEvent.","params":["calendarId","q","timeMin","timeMax","maxResults","singleEvents"]},{"name":"createEvent","description":"Creates a new event on a Google Calendar. Supports timed events (start/end with dateTime) and all-day events (start/end with date). Set sendUpdates to email invitations to attendees.","params":["calendarId","summary","description","location","start","end","attendees","sendUpdates","conferenceData"]},{"name":"updateEvent","description":"Updates an existing Google Calendar event with PATCH semantics — only the fields you provide are changed; everything else stays the same. Common uses: reschedule (set start+end), retitle (set summary), add/remove attendees (set attendees array which fully replaces).","params":["calendarId","eventId","summary","description","location","start","end","attendees","sendUpdates"]},{"name":"deleteEvent","description":"Deletes an event from a Google Calendar. This is permanent — the event is removed, not trashed. Use sendUpdates to email cancellations to attendees.","params":["calendarId","eventId","sendUpdates"]},{"name":"quickAddEvent","description":"Creates a calendar event from a natural-language string using Google Calendar's quick-add parser. Examples: \"Lunch with Sarah tomorrow at 12pm\", \"Dentist appointment next Tuesday 3-4pm\", \"Team standup every weekday 9am\". Faster than createEvent when you don't need attendees, descriptions, or precise control over fields.","params":["calendarId","text","sendUpdates"]},{"name":"createAppsScriptProject","description":"Creates an Apps Script project, optionally bound to a Doc, Sheet, Slides or Form so its triggers and custom menus run inside that file. Optionally writes the initial files in the same call. Requires the Apps Script API to be enabled at https://script.google.com/home/usersettings.","params":["title","parentId","files"]},{"name":"getAppsScriptContent","description":"Reads the files of an Apps Script project. Use it before updateAppsScriptContent to see what is already there, or to review code that is currently deployed.","params":["scriptId","versionNumber","includeSource"]},{"name":"updateAppsScriptContent","description":"Writes files into an existing Apps Script project. Default mode \"merge\" replaces same-named files and keeps the rest; mode \"replace\" makes the project contain exactly the files passed in. The manifest is preserved automatically.","params":["scriptId","files","mode"]}],"toolsHash":"8272ea166c547e8fb24a26426c7f01dd7e47e1b74d86cc8147535ef8a191a500","wrote":[],"callsAt":"2026-11-16T11:30:36.530Z","calls":[{"tool":"listDocuments","ok":false,"ms":5,"bytes":0,"error":"tool reported an error: Tool 'listDocuments' execution failed: Google client initialization failed. Cannot start server tools."},{"tool":"listDriveFiles","ok":false,"ms":1,"bytes":0,"error":"tool reported an error: Tool 'listDriveFiles' execution failed: Google client initialization failed. Cannot start server tools."},{"tool":"listSpreadsheets","ok":false,"ms":1,"bytes":0,"error":"tool reported an error: Tool 'listSpreadsheets' execution failed: Google client initialization failed. Cannot start server tools."},{"tool":"listLabels","ok":false,"ms":1,"bytes":0,"error":"tool reported an error: Tool 'listLabels' execution failed: Google client initialization failed. Cannot start server tools."},{"tool":"listDrafts","ok":false,"ms":1,"bytes":0,"error":"tool reported an error: Tool 'listDrafts' execution failed: Google client initialization failed. Cannot start server tools."}],"host":{"commit":"eaaffffaf52255d1b77dc4aacffdfaf353f0c12c","run":"https://github.com/itsHaddad/bragproof/actions/runs/43857070216"},"network":{"names":["registry.npmjs.org"],"conns":[],"callNames":[],"callConns":[]}},"summary":{"outcome":"started","needs":[],"contacts":[],"flags":[],"tools":130,"wrote":0,"callsTried":5,"callsAnswered":0,"callContacts":[]},"history":[{"package":"@a-bonus/google-docs-mcp","version":"2.0.1","ranAt":"2026-11-16T11:30:24.989Z","outcome":"started","tools":130,"contacts":0,"flags":0,"serious":0,"toolsHash":"8272ea166c547e8fb24a26426c7f01dd7e47e1b74d86cc8147535ef8a191a500"},{"package":"@a-bonus/google-docs-mcp","version":"1.11.3","ranAt":"2026-11-12T17:50:47.412Z","outcome":"needs-setup","tools":0,"contacts":0,"flags":0,"serious":0,"toolsHash":"e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855"}],"page":"https://bragproof.smaverk.com/r/%40a-bonus/google-docs-mcp"}