Spaces:
Sleeping
Sleeping
File size: 3,170 Bytes
7dc28be | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 | import type { FastMCP } from 'fastmcp';
import { UserError } from 'fastmcp';
import { z } from 'zod';
import { google } from 'googleapis';
import { getAuthClient } from '../../../clients.js';
export function register(server: FastMCP) {
server.addTool({
name: 'getSheetsComment',
description:
'Gets a specific comment and its full reply thread from a Google Spreadsheet. Use listSheetsComments first to find the comment ID.',
parameters: z.strictObject({
spreadsheetId: z
.string()
.describe(
'The spreadsheet ID — the long string between /d/ and /edit in a Google Sheets URL.'
),
commentId: z.string().describe('The ID of the comment to retrieve.'),
}),
execute: async (args, { log }) => {
log.info(`Getting comment ${args.commentId} from spreadsheet ${args.spreadsheetId}`);
try {
const authClient = await getAuthClient();
const drive = google.drive({ version: 'v3', auth: authClient });
const response = await drive.comments.get({
fileId: args.spreadsheetId,
commentId: args.commentId,
fields:
'id,content,anchor,quotedFileContent,author,createdTime,modifiedTime,resolved,replies(id,content,author,createdTime)',
});
const comment = response.data;
const cellInfo = comment.anchor ? parseSheetsAnchor(comment.anchor) : null;
return JSON.stringify(
{
id: comment.id,
author: comment.author?.displayName || null,
content: comment.content,
cell: cellInfo ? rowColToA1(cellInfo.row, cellInfo.col) : null,
quotedText: comment.quotedFileContent?.value || null,
resolved: comment.resolved || false,
createdTime: comment.createdTime,
modifiedTime: comment.modifiedTime,
replies: (comment.replies || []).map((r: any) => ({
id: r.id,
author: r.author?.displayName || null,
content: r.content,
createdTime: r.createdTime,
})),
},
null,
2
);
} catch (error: any) {
log.error(`Error getting sheets comment: ${error.message || error}`);
throw new UserError(`Failed to get comment: ${error.message || 'Unknown error'}`);
}
},
});
}
function parseSheetsAnchor(
anchorStr: string
): { sheetId: number; row: number; col: number } | null {
try {
const anchor = JSON.parse(anchorStr);
const actions = anchor.a;
if (!actions || !Array.isArray(actions)) return null;
for (const action of actions) {
if (action.sht) {
const sid = action.sht.sid;
const rng = action.sht.rng;
if (sid !== undefined && rng) {
return { sheetId: sid, row: rng.r || 0, col: rng.c || 0 };
}
}
}
return null;
} catch {
return null;
}
}
function rowColToA1(row: number, col: number): string {
let colStr = '';
let c = col;
do {
colStr = String.fromCharCode(65 + (c % 26)) + colStr;
c = Math.floor(c / 26) - 1;
} while (c >= 0);
return `${colStr}${row + 1}`;
}
|