Classify SES project emails with GPT-4.1 mini and save from Gmail to 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 7 nodes and runs on Gmail events. Along the way it connects Gmail, OpenAI and Google Sheets.
How it runs
Trigger: On Gmail events.
- AI Project Classifier (OpenAI): uses OpenAI
- Parse JSON (Code): runs custom JavaScript code
- Is Project Email? (If): checks a condition and branches into true / false
- Set Spreadsheet Config (Edit Fields (Set)): sets 2 fields: Spreadsheet ID, Sheet Name
- Append to Spreadsheet (Google Sheets): append
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) (Gmail Trigger).
Nodes used (7)
- Gmail Trigger
n8n-nodes-base.gmailTrigger - OpenAI
@n8n/n8n-nodes-langchain.openAi - Code
n8n-nodes-base.code - If
n8n-nodes-base.if - Google Sheets
n8n-nodes-base.googleSheets - No Operation, do nothing
n8n-nodes-base.noOp - Edit Fields (Set)
n8n-nodes-base.set
From the author
What this workflow does This workflow monitors your Gmail inbox every minute and automatically extracts SES (System Engineering Service) project information from recruitment emails. It uses AI to classify emails and parse structured data, then appends project…