Automate SES Project Emails to Google Sheets with n8n

Transform your SES project recruitment process with this intelligent n8n workflow that automatically monitors Gmail, extracts project data using AI, and organizes everything in Google Sheets—no manual data entry required.

What this workflow does

This powerful automation continuously monitors your Gmail inbox every minute, scanning for SES (System Engineering Service) project recruitment emails. When project emails arrive, the workflow leverages AI to classify and parse structured data, then automatically appends the extracted project information to your Google Spreadsheet for seamless project management.

The workflow follows a precise 6-step process: Gmail Trigger polls your inbox every minute, AI Project Classifier analyzes each email to identify recruitment messages, Parse JSON converts AI responses into structured data, conditional routing forwards only project emails while skipping others, Set Spreadsheet Config targets your designated Google Sheet, and finally Append to Spreadsheet writes extracted project data as new rows.

Use cases

• SES contractors tracking new project opportunities from multiple recruitment sources
• Engineering consultancies managing incoming project leads and proposals
• Project managers centralizing recruitment communications for team visibility
• Freelance engineers automating project pipeline management
• Staffing agencies organizing SES project placements efficiently

Technical details

This n8n workflow integrates Gmail, OpenAI, and Google Sheets through a sophisticated node structure including Gmail Trigger, conditional logic nodes, JSON parsing, and spreadsheet operations. The automation requires Gmail OAuth2 credentials for inbox access, OpenAI API credentials for intelligent email classification, and Google Sheets OAuth2 credentials for data storage.

Setup is straightforward: ensure you have a Google Spreadsheet with a "Projects" sheet (or customize the sheet name in Set Spreadsheet Config), configure your API credentials, and activate the workflow. The system immediately begins monitoring your inbox, transforming project recruitment emails into organized, searchable spreadsheet data without manual intervention.