Google Sheets MCP - AI-Powered Spreadsheet Management — n8n 工作流

中 复杂度⚡ 触发器7 个节点💎 Other👁 352 次查看作者：David Olusola

概览

📊 Google Sheets MCP Workflow – AI Meets Spreadsheets! 😄

✨ What It Does

This n8n workflow lets you chat with your spreadsheets using AI + MCP! From reading and updating data to creating sheets, it’s your smart assistant for Google Sheets 📈🤖

🚀 Cool Features

💬 Natural language commands (e.g. "Add a new lead: John Doe") ✏️ Full CRUD (Create, Read, Update, Delete) 🧠 AI-powered analysis & smart workflows 🗂️ Multi-sheet support 🔗 Works with ChatGPT, Claude, and more (via MCP)

💡 Use Cases

Data Tas

使用的节点

MCP Server TriggerGoogle Sheets - Delete SheetSticky Note - Delete Sheet

工作流预览

🎯 WORKFLOW OVERVIEW
Google Sheets MCP - AI-Powered Spreadsheet Management
This workflow provides a complete toolkit for intellige
🚀 Google Sheets MCP - AI-Powered Spreadsheet
What it does:
This is the entry point for AI interactions with Google
📊 READ DATA
Purpose:
Retrieve and analyze data from Google Sheets for AI pro
Use Cases:
• "Show me all customer data"
• "Read the sales figures from Q3"
🗑️ CLEAR DATA
Purpose:
Remove data from specific ranges or entire sheets safel
Use Cases:
• "Clear the temporary calculations"
• "Remove old data from column C"
➕ ADD DATA
Purpose:
Append new records to existing sheets without affecting
Use Cases:
• "Add new customer: John Doe, [email protected]"
• "Log today's sales: $1,500"
📋 CREATE SHEET
Purpose:
Create new worksheet tabs for better data organization
Use Cases:
• "Create 'Q4 Budget' sheet"
• "Add new project tracking tab"
✏️ UPDATE DATA
Purpose:
Modify specific cells with new values while preserving
Use Cases:
• "Update status in C5 to 'Complete'"
• "Change price in product list"
🗑️ DELETE SHEET
Purpose:
Permanently remove entire worksheet tabs and all their
Use Cases:
• "Delete the old testing sheet"
• "Remove expired project tabs"
tooltooltooltooltooltool
⚡
M
MCP Server Trigger
G
Google Sheets - Read Data
G
Google Sheets - Clear Data
G
Google Sheets - Add Data
G
Google Sheets - Create S…
G
Google Sheets - Update D…
G
Google Sheets - Delete S…
7 nodes6 edges

工作原理

  1. 1

    触发器

    工作流由 触发器 触发器启动。

  2. 2

    处理

    数据流经 7 个节点, connecting googlesheetstool, mcptrigger。

  3. 3

    输出

    工作流完成自动化并将结果发送到配置的目标。

节点详情 (7)

MC

MCP Server Trigger

n8n-nodes-langchain.mcpTrigger

#1
GO

Google Sheets - Delete Sheet

googleSheetsTool

#2
ST

Sticky Note - Delete Sheet

stickyNote

#3

如何导入此工作流

  1. 1点击右侧 下载 JSON 按钮保存工作流文件。
  2. 2打开你的 n8n 实例，依次点击 工作流 → 新建 → 从文件导入。
  3. 3选择下载的 google-sheets-mcp-ai-powered-spreadsheet-management 文件并点击导入。
  4. 4为每个服务节点配置 凭证（API 密钥、OAuth 等）。
  5. 5点击 测试工作流 验证一切正常，然后激活它。

或直接在 n8n → 从 JSON 导入 中粘贴：

{ "name": "Google Sheets MCP - AI-Powered Spreadsheet Management", "nodes": [...], ...}

集成

googlesheetstoolmcptrigger

获取此工作流

一键下载并导入

下载 JSON在 n8n.io 上查看
节点7
复杂度medium
触发器trigger
查看次数352
分类Other

创建者

David Olusola

David Olusola

@dae221

标签

googlesheetstoolmcptrigger
⚡

n8n 新手？

n8n 是一款免费开源的工作流自动化工具，支持自托管或使用云版本。

免费获取 n8n →