Key metrics attached.
` ).toString("base64url"); await gmail.users.messages.send({ userId: "me", requestBody: { raw: encodedMessage }, }); // Apply labels for organization await gmail.users.messages.modify({ userId: "me", id: messageId, requestBody: { addLabelIds: ["Label_Reviewed"], removeLabelIds: ["UNREAD"], }, }); ``` ### Google Sheets Operations ```typescript const sheets = google.sheets({ version: "v4", auth }); // Read data const data = await sheets.spreadsheets.values.get({ spreadsheetId: SHEET_ID, range: "Pipeline!A1:F100", }); // Write data await sheets.spreadsheets.values.update({ spreadsheetId: SHEET_ID, range: "Pipeline!A1", valueInputOption: "USER_ENTERED", requestBody: { values: [ ["Deal Name", "Stage", "Amount", "Close Date", "Owner", "Probability"], ["Acme Corp", "Negotiation", "$150,000", "2026-04-30", "Jane", "75%"], ["Beta Inc", "Proposal", "$80,000", "2026-05-15", "John", "50%"], ], }, }); // Append rows (add to end) await sheets.spreadsheets.values.append({ spreadsheetId: SHEET_ID, range: "Leads!A:D", valueInputOption: "USER_ENTERED", requestBody: { values: [["New Lead", "lead@example.com", "Technology", new Date().toISOString()]], }, }); ``` ### Google Drive Operations ```typescript const drive = google.drive({ version: "v3", auth }); // Search files const files = await drive.files.list({ q: "name contains 'Q2 Report' and mimeType = 'application/pdf' and trashed = false", fields: "files(id, name, modifiedTime, webViewLink, size)", orderBy: "modifiedTime desc", pageSize: 10, }); // Upload a file const uploadedFile = await drive.files.create({ requestBody: { name: "Monthly-Report-March-2026.pdf", parents: [folderId], }, media: { mimeType: "application/pdf", body: fs.createReadStream("report.pdf"), }, }); // Share with specific users await drive.permissions.create({ fileId: uploadedFile.data.id, requestBody: { role: "reader", type: "user", emailAddress: "manager@company.com", }, }); ``` ### Workspace MCP Server ```typescript server.tool( "search_gmail", "Search Gmail messages using Gmail search syntax", { query: z.string().describe("Gmail search query (e.g., 'from:boss is:unread')"), maxResults: z.number().default(10), }, async ({ query, maxResults }) => { const results = await gmail.users.messages.list({ userId: "me", q: query, maxResults, }); if (!results.data.messages?.length) { return { content: [{ type: "text", text: "No messages found." }] }; } const messages = await Promise.all( results.data.messages.map(async (m) => { const full = await gmail.users.messages.get({ userId: "me", id: m.id, format: "metadata", metadataHeaders: ["Subject", "From", "Date"], }); const headers = Object.fromEntries( full.data.payload.headers.map(h => [h.name, h.value]) ); return { subject: headers.Subject, from: headers.From, date: headers.Date, snippet: full.data.snippet }; }) ); return { content: [{ type: "text", text: messages.map(m => `From: ${m.from}\nSubject: ${m.subject}\nDate: ${m.date}\n${m.snippet}\n` ).join("\n---\n"), }], }; } ); server.tool( "update_spreadsheet", "Read from or write to a Google Sheets spreadsheet", { spreadsheetId: z.string(), range: z.string().describe("Cell range (e.g., 'Sheet1!A1:D10')"), action: z.enum(["read", "write", "append"]), data: z.array(z.array(z.string())).optional().describe("Rows of data for write/append"), }, async ({ spreadsheetId, range, action, data }) => { if (action === "read") { const result = await sheets.spreadsheets.values.get({ spreadsheetId, range }); return { content: [{ type: "text", text: result.data.values?.map(row => row.join(" | ")).join("\n") || "Empty range", }], }; } // write or append const method = action === "append" ? "append" : "update"; await sheets.spreadsheets.values[method]({ spreadsheetId, range, valueInputOption: "USER_ENTERED", requestBody: { values: data }, }); return { content: [{ type: "text", text: `${data.length} rows ${action === "append" ? "appended" : "written"} to ${range}` }] }; } ); ``` ## Best Practices 1. **Use service accounts with domain-wide delegation** for server-side automation 2. **Batch API calls** — Google APIs support batch requests (up to 100 per batch) 3. **Respect quotas** — Gmail: 250 messages/day (free), Drive: 1000 queries/100s 4. **Use push notifications** over polling for real-time updates (Drive, Gmail watch) 5. **Paginate with nextPageToken** — never assume complete results 6. **Scope permissions minimally** — only request OAuth scopes you actually need ## Resources - [Google Workspace API Documentation](https://developers.google.com/workspace) - [Gmail API Reference](https://developers.google.com/gmail/api) - [Google Sheets API](https://developers.google.com/sheets/api) - [googleapis Node.js Client](https://github.com/googleapis/google-api-nodejs-client) ## Changelog | Version | Date | Changes | |---------|------|---------| | 1.0.0 | 2026-03-31 | Initial documentation |