google-docs-mcp / src /tools /docs /getTableStructure.ts
iFightDucks's picture
Initial HF Space deploy: a-bonus/google-docs-mcp with HF metadata
7dc28be
import type { FastMCP } from 'fastmcp';
import { UserError } from 'fastmcp';
import { z } from 'zod';
import { getDocsClient } from '../../clients.js';
import { DocumentIdParameter } from '../../types.js';
import { getTableById } from './structureHelpers.js';
export function register(server: FastMCP) {
server.addTool({
name: 'getTableStructure',
description:
'Returns detailed structure for a table in a Google Document, including row/column counts and extracted cell text.',
parameters: DocumentIdParameter.extend({
tableId: z
.string()
.min(1)
.describe('The MCP table ID returned by listDocumentTables, for example "table:body:0".'),
tabId: z
.string()
.optional()
.describe(
'The ID of the specific tab to inspect. If not specified, inspects the first tab or legacy document body.'
),
}),
execute: async (args, { log }) => {
const docs = await getDocsClient();
log.info(
`Getting table structure for ${args.tableId} in ${args.documentId}${args.tabId ? ` (tab: ${args.tabId})` : ''}`
);
try {
const res = await docs.documents.get({
documentId: args.documentId,
includeTabsContent: true,
fields:
'body(content(startIndex,endIndex,table(tableRows(tableCells(startIndex,endIndex,content(startIndex,endIndex,paragraph(elements(textRun(content))))))))),tabs(tabProperties(tabId,title),documentTab(body(content(startIndex,endIndex,table(tableRows(tableCells(startIndex,endIndex,content(startIndex,endIndex,paragraph(elements(textRun(content)))))))))))',
});
const table = getTableById(res.data, args.tableId, args.tabId);
if (!table) {
throw new UserError(`Table "${args.tableId}" not found in document.`);
}
return JSON.stringify(table, null, 2);
} catch (error: any) {
log.error(
`Error getting table structure for ${args.tableId} in doc ${args.documentId}: ${error.message || error}`
);
if (error instanceof UserError) throw error;
if (error.code === 404) throw new UserError(`Document not found (ID: ${args.documentId}).`);
if (error.code === 403)
throw new UserError(`Permission denied for document (ID: ${args.documentId}).`);
throw new UserError(`Failed to get table structure: ${error.message || 'Unknown error'}`);
}
},
});
}