Capture and log trade instructions from Gmail with Gemini and Google Sheets
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 10 nodes and runs on Gmail events. Along the way it connects Google Gemini Chat Model, Gmail, Google Sheets and Slack.
How it runs
Trigger: On Gmail events.
- Map Email Body & Sender (Edit Fields (Set)): sets 2 fields: email_content, sender_info
- Extract Trade Details (Gemini AI) (AI Agent): runs an AI agent, with model: Google Gemini Chat Model; output parser: Enforce Trade Data Schema
- Verify Trade Data Validity (If): checks a condition and branches into true / false
- Log Trade to Master Ledger (Google Sheets) (Google Sheets): append
- Alert Ops Team (Extraction Failed) (Slack): uses Slack
- Notify Ops Team (Success) (Slack): uses Slack
- Send Confirmation to Client (Gmail): reply
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
- Still check Gmail Trigger below v1.4 runs as v1.4 (drafts skipped, max emails per poll) (Watch for New Trade Instructions).
Nodes used (9)
- Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - Gmail Trigger
n8n-nodes-base.gmailTrigger - Edit Fields (Set)
n8n-nodes-base.set - AI Agent
@n8n/n8n-nodes-langchain.agent - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - If
n8n-nodes-base.if - Google Sheets
n8n-nodes-base.googleSheets - Gmail
n8n-nodes-base.gmail - Slack
n8n-nodes-base.slack
From the author
Quick Overview This workflow watches Gmail for emails with the subject “Trade Instruction”, uses Google Gemini to extract structured trade fields, validates the result, logs valid trades to Google Sheets, replies to the sender with a confirmation, and alerts…