Validate wholesale order emails against a Google Sheets price list with Gmail and GPT-4o

by Khairul Muhtadin ✓ · 1 views · created 2026-09-15 · Document Extraction, AI Summarization

What this workflow does

This AI workflow has 27 nodes and runs on a schedule (cron 0 8 * * 1) (plus 1 other trigger). Along the way it connects Gmail, OpenAI Chat Model, Google Sheets and Telegram.

How it runs

Trigger: On a schedule (cron 0 8 * * 1) (plus 1 other trigger).

1. Read Orders This Week (Google Sheets): uses Google Sheets
2. Normalize Order Email (Edit Fields (Set)): sets 7 fields: email_id, thread_id, from_email…
3. Summarise Order Week (Code): runs custom JavaScript code
4. Has Order Details (If): checks a condition and branches into true / false
5. AI Write Digest Summary (AI Agent): runs an AI agent, with model: Digest Model
6. AI Extract Order Lines (AI Agent): runs an AI agent, with model: Order Extraction Model
7. Log Unparsable Order Email (Google Sheets): append
8. Format Digest Email (Code): runs custom JavaScript code
9. Parse Extracted Order (Code): runs custom JavaScript code
10. Alert Desk About Unparsable Email (Telegram): uses Telegram

…plus 13 more steps. See the full node list below.

Services it uses

GmailOpenAI Chat ModelGoogle SheetsTelegram

Before you upgrade to n8n 3.0

Nodes used (10)

• Gmail Triggern8n-nodes-base.gmailTrigger
• Edit Fields (Set)n8n-nodes-base.set
• Ifn8n-nodes-base.if
• AI Agent@n8n/n8n-nodes-langchain.agent
• OpenAI Chat Model@n8n/n8n-nodes-langchain.lmChatOpenAi
• Coden8n-nodes-base.code
• Google Sheetsn8n-nodes-base.googleSheets
• Gmailn8n-nodes-base.gmail
• Telegramn8n-nodes-base.telegram
• Schedule Triggern8n-nodes-base.scheduleTrigger

From the author

Quick Overview This workflow monitors Gmail for unread wholesale order emails, uses OpenAI to extract order line items, validates them against a Google Sheets price list, and then sends either a confirmation or a revision request by email while logging the…

View the original on n8n.io → Check your own copy