Automated email assistant for suppliers using OpenAI and Google Sheets
Needs changesNeeds changes. This template uses 1 thing(s) that n8n 3.0 removes: AI Agent v1 (old agent modes). 1 breaking item(s) found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 9 nodes and runs when an MCP client calls one of its tools (plus 1 other trigger). Along the way it connects Gmail, OpenAI Chat Model, MCP Client and Google Sheets.
How it runs
Trigger: When an MCP client calls one of its tools (plus 1 other trigger).
- Personal Email Assistant (AI Agent): runs an AI agent, with model: AI Model Open AI; 3 tools (Supplier database., Thinker, think before executing., Node that connects to the MCP server.); memory: Chat Memory
- Send message by Gmail (Gmail Tool): uses Gmail Tool
Services it uses
Before you upgrade to n8n 3.0
1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:
- AI Agent v1 (old agent modes) in Personal Email Assistant (v1.9): replace with Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent.
Rather not rewrite it? Many of these flows can be rebuilt in Make (free plan).
| Removed in 3.0 | Replace with |
|---|---|
| AI Agent v1 (old agent modes) Personal Email Assistant (v1.9) | Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent. |
Nodes used (9)
- MCP Server Trigger
@n8n/n8n-nodes-langchain.mcpTrigger - Gmail Tool
n8n-nodes-base.gmailTool - Chat Trigger
@n8n/n8n-nodes-langchain.chatTrigger - AI Agent
@n8n/n8n-nodes-langchain.agent - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Simple Memory
@n8n/n8n-nodes-langchain.memoryBufferWindow - MCP Client Tool
@n8n/n8n-nodes-langchain.mcpClientTool - Think Tool
@n8n/n8n-nodes-langchain.toolThink - Google Sheets Tool
n8n-nodes-base.googleSheetsTool
From the author
Automated Email Assistant for Busy Professionals This assistant is designed for people who don't have time to write and send emails to suppliers. With just one request, it drafts and sends clear, professional messages automatically. How It Works The user…