🚀 Google Workspace MCP Server

The Ultimate MCP Server for Google Workspace Automation — Seamlessly integrate Google Drive, Sheets, and Docs with Claude AI and other AI agents through the Model Context Protocol (MCP).

---

📖 Overview

Google Workspace MCP Server is a TypeScript-based Model Context Protocol server that empowers AI agents like Claude with 76 powerful tools to interact with Google Workspace services. Automate document creation, spreadsheet manipulation, file management, and more—all through natural language conversations with AI.

🌟 Key Features

• 76 Comprehensive Tools across Google Drive, Sheets, and Docs
• Production-Ready with OAuth 2.0 authentication
• Type-Safe implementation using TypeScript and Zod validation
• Cross-Platform executable support for easy deployment
• Real-Time Operations with Google Workspace APIs
• Secure credential management and session handling

---

⚙️ Quick Start

1. 📁 Clone the Repository

git clone https://github.com/chayan-1906/Google-Workspace-MCP.git
cd Google-Workspace-MCP

2. 📦 Install Dependencies

npm install

3. 🔧 Configure OAuth Credentials

Follow the User Guide for detailed setup instructions.

4. 🚀 Run the Server

npm run dev

Or build and package:

npm run package

---

🧰 Complete Tool Reference

👤 Profile (1 tool)

| Tool Name | Description | |-------------------|------------------------------------------------| | myGoogleAccount | Fetches the authenticated user's email address |

📁 Google Drive - Folder Management (8 tools)

| Tool Name | Description | |-----------------------------|-------------------------------------------------------------------| | getDriveFolderIdsByName | Finds the Google Drive folder IDs by folder name | | getDriveFolderContentById | Finds the Google Drive folder contents by folder ID | | createDriveFolder | Creates a new folder in Google Drive | | copyDriveFolder | Copies a folder in Google Drive to a new location with a new name | | moveDriveFolder | Moves a folder to a different location in Google Drive | | deleteDriveFolder | Permanently deletes a folder from Google Drive | | getDriveStorageQuota | Gets Google Drive storage quota and usage information | | getDriveSharedWithMe | Lists files shared with the authenticated user |

📄 Google Drive - File Operations (10 tools)

| Tool Name | Description | |------------------------------|-------------------------------------------------------------------------------------| | getDriveFileMetadata | Gets detailed metadata for a Google Drive file | | getDriveFilePermissions | Gets all permissions for a Google Drive file | | updateDriveFilePermissions | Updates permissions for a specific user on a Google Drive file | | copyDriveFile | Copies a file in Google Drive to a new location with a new name | | moveDriveFile | Moves a file to a different folder in Google Drive | | deleteDriveFile | Permanently deletes a file from Google Drive | | searchDriveFiles | Searches for files in Google Drive using query parameters | | removeDriveFileAccess | Removes access permissions for a specific user from a Google Drive file | | setDriveLinkPermission | Sets link sharing permissions for a Google Drive file (anyone with link can access) | | duplicateDriveFile | Duplicates a file in the same folder with "Copy of" prefix |

📊 Google Spreadsheets - Document Management (6 tools)

| Tool Name | Description | |----------------------|--------------------------------------------------------------------------------| | getSheetIdsByName | Finds the Google Spreadsheet IDs by spreadsheet name | | createSpreadsheet | Creates a new Google Spreadsheet in the specified Drive folder | | deleteSpreadsheet | Deletes a Google Spreadsheet from Drive permanently | | renameSpreadsheet | Renames an existing Google Spreadsheet by the spreadsheet ID | | shareSpreadsheet | Shares the Google Spreadsheet with one or more users | | unshareSpreadsheet | Unshares the spreadsheet from specific email addresses (ignores if not shared) |

📝 Google Docs - Document Management (5 tools)

| Tool Name | Description | |-------------------|---------------------------------------------------------------------| | getDocIdsByName | Finds the Google Doc IDs by doc name | | getDocMetadata | Fetches basic metadata for a Google Doc (title, timestamps, owners) | | createDoc | Creates a new Google Doc in the specified Drive folder | | deleteDoc | Deletes a Google Docs document | | renameDoc | Renames a Google Docs document |

📈 Google Sheets - Data Manipulation (27 tools)

| Tool Name | Description | |-------------------------------------|---------------------------------------------------------------------------------------------------| | appendSheetTabRow | Appends a new row in an existing spreadsheet | | deleteRow | Deletes one or more rows in a sheet tab | | clearRanges | Clears certain ranges from a Google Spreadsheet | | updateRanges | Updates specific ranges in a Google Spreadsheet | | getSheetTabContent | Fetches values from a specific sheet range in given Google Spreadsheet | | addSheetTab | Creates a new sheet tab in Google Spreadsheet | | renameSheetTab | Renames a sheet tab in Google Spreadsheet | | deleteSheetTab | Deletes a sheet tab by its numeric sheet tab ID | | addSheetTabContent | Adds new content (rows) to a specified range in a Google Spreadsheet | | updateSheetTabContent | Overwrites content in a specific Google Spreadsheet range | | insertColumn | Inserts a new column in a sheet at a specific position in Google Spreadsheet | | deleteColumn | Deletes one or more columns in a sheet tab from Google Spreadsheet | | addChart | Adds a chart to the specified sheet in Google Spreadsheet | | sortSheet | Sorts a row range by one or more column indexes in Google Spreadsheet | | filterSheet | Applies filter view to a specified cell range in Google Spreadsheet | | functions | Applies spreadsheet function formulas (e.g., SUM, AVERAGE) to specific cell in Google Spreadsheet | | addConditionalFormatting | Adds conditional formatting to a range in a Google Spreadsheet | | clearAllConditionalFormatting | Clears all conditional formatting rules in a sheet tab in Google Spreadsheet | | freezeRowsColumns | Freezes specified number of rows and columns in a sheet in Google Spreadsheet | | unfreezeRowsColumns | Removes any frozen rows or columns from the Google Spreadsheet | | customCellFormatting | Applies custom formatting to a specified cell range in a Google Spreadsheet | | clearAllCustomCellFormattingSheet | Clears all custom cell formatting (like font, color, alignment) from the given Google Spreadsheet | | duplicateSheetTab | Duplicates a sheet and assigns a new name in given Google Spreadsheet | | mergeCells | Merges a specified cell range in a sheet using a selected merge type in Google Spreadsheet | | unmergeCells | Unmerges cells in the given range on a Google Spreadsheet | | setHeightWidth | Sets row height or column width in a Google Spreadsheet | | protectCells | Adds a protected range to specific cells with a warning in a Google Spreadsheet | | insertLinkSheet | Inserts a hyperlink into a specific cell in Google Spreadsheet |

📋 Google Docs - Content & Formatting (18 tools)

| Tool Name | Description | |-----------------------------|-------------------------------------------------------------------------------------------------------------------------------------------------| | getDocContent | Retrieves the complete plain text content from a Google Docs document, including text from tables and other elements | | appendDocText | Appends text content to the end of a Google Docs document | | findTextIndices | Finds all indices of a character or word in a Google Docs document, similar to Google Docs Find tool | | insertTextAtPosition | Inserts text at a specific character position in a Google Docs document | | deleteTextRange | Deletes specific content ranges in a Google Docs document using precomputed start and end indices