Classify SES project emails with GPT-4.1 mini and save from Gmail to Sheets
Go to WorkflowDescription
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)