{"product_id":"automate-ses-project-emails-to-google-sheets-with-n8n","title":"Automate SES Project Emails to Google Sheets with n8n","description":"\u003cp\u003eTransform 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.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cp\u003eThis 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.\u003c\/p\u003e\n\n\u003cp\u003eThe 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.\u003c\/p\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli\u003eSES contractors tracking new project opportunities from multiple recruitment sources\u003c\/li\u003e\n\u003cli\u003eEngineering consultancies managing incoming project leads and proposals\u003c\/li\u003e\n\u003cli\u003eProject managers centralizing recruitment communications for team visibility\u003c\/li\u003e\n\u003cli\u003eFreelance engineers automating project pipeline management\u003c\/li\u003e\n\u003cli\u003eStaffing agencies organizing SES project placements efficiently\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cp\u003eThis 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.\u003c\/p\u003e\n\n\u003cp\u003eSetup 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.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45490501550259,"sku":"N8N-15485","price":25.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/dFuYQs6AtYjGeEpyjsiMm_b0bd0288e6914bc0bbc87fef51a4c1e1.jpg?v=1777971754","url":"https:\/\/buyflowscripts.com\/products\/automate-ses-project-emails-to-google-sheets-with-n8n","provider":"N8N Commerce","version":"1.0","type":"link"}