📊
Google Sheets
Cloud Spreadsheets Google ServicesInstall Command
npx clawhub@latest install google-sheets
Installation Guide
1
Check Environment
Make sure Node.js 22+ and OpenClaw are installed. Run openclaw --version in your terminal to verify.
2
Run Installation
Run the install command above in your terminal. ClawHub will automatically download and install Google Sheets to the ~/.openclaw/skills/ directory.
3
Verify Installation
Run openclaw skills list to check your installed skills and confirm Google Sheets appears in the list.
4
Configure (Optional)
Follow the configuration instructions in the description below to add skill settings to ~/.config/openclaw/openclaw.json5.
Manual Installation: Copy the Skill folder to
~/.openclaw/skills/ or the skills/ directory in your project root. Make sure the folder contains a SKILL.md file.
Create and edit Google Sheets
Read and write cell data and formulas
Manage worksheets and sharing permissions
Detailed Description
Google Sheets MCP Server integrates Google Spreadsheets into AI workflows, enabling automated cloud data reading, writing, and analysis.
Core Features
- Sheet Operations: Create new spreadsheets, add worksheets, read and write cell data
- Formulas & Formatting: Set formulas, conditional formatting, and data validation rules
- Collaboration Management: Manage spreadsheet sharing permissions, view editing history
Configuration
{
"mcpServers": {
"google-sheets": {
"command": "npx",
"args": ["-y", "@anthropic/mcp-google-sheets"],
"env": {
"GOOGLE_CLIENT_ID": "OAuth client ID",
"GOOGLE_CLIENT_SECRET": "OAuth client secret",
"GOOGLE_REFRESH_TOKEN": "Refresh token"
}
}
}
}
Use Cases
- Automatically fetch data from APIs and populate Google Sheets
- Let AI analyze sheet data and generate insight reports
- Automate daily data entry and update tasks
- Consolidate and compare data across multiple spreadsheets