🔬 Classify SES project emails with GPT-4.1 mini and save from Gmail to Sheets
⚡ 19 views · 🔬 Document Extraction & Analysis
Description
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 details to a Google Spreadsheet.
Workflow steps
- Gmail Trigger polls your inbox every minute
- AI Project Classifier analyzes each email to determine if it’s a project recruitment email
- Parse JSON converts the AI response into structured data
- Is Project Email? routes project emails forward; others are skipped
- Set Spreadsheet Config sets the target spreadsheet ID and sheet name
- Append to Spreadsheet writes the extracted project data as a new row
Requirements
- Gmail OAuth2 credentials
- OpenAI API credentials
- Google Sheets OAuth2 credentials
- A Google Spreadsheet with a sheet named
Projects(or update the sheet name in the Set Spreadsheet Config node)
🔗 Nodes Used
Google Sheets, Gmail Trigger, OpenAI
📥 Import
Download workflow.json and import into n8n:
Workflow menu → Import from File