Streamline Job Applications: Gmail to Sheets Automation

Stop losing track of your job applications in a messy inbox. This n8n workflow automatically scans your Gmail every morning, extracts key details from recruiter emails using AI, and maintains a perfectly organized Google Sheets tracker—so you always know exactly where each application stands.

What this workflow does

Every morning at 9 AM, this automation runs a comprehensive job application tracking process:

• Scans Gmail intelligently - Filters emails from ATS platforms and job-related senders from the last 2 days
• Extracts structured data - Uses GPT-4o-mini to identify the actual hiring company (not just the ATS), clean position titles, and determine application status (Applied, Interview, Offer, Rejected, or Other)
• Updates Google Sheets automatically - Creates unique Match Keys using "Company | Position" format to track each application accurately
• Handles status changes safely - New applications are added immediately, while status updates (Applied → Interview, Interview → Offer/Rejected) require one-tap email approval to prevent AI misclassification errors
• Organizes edge cases - Routes unclear applications to a separate "Other app" sheet tab for manual review

Use cases

Perfect for active job seekers applying to 10-30 roles weekly who need to:

• Automatically track application responses without manual spreadsheet updates
• Prevent duplicate entries while capturing status progressions
• Maintain accurate records when recruiters use different ATS platforms
• Ensure no interview requests or offers get buried in email overload

Technical details

Built with essential n8n nodes including Gmail integration for email processing, Set nodes for data formatting, If nodes for conditional logic, Split Out and Merge for data handling, and Aggregate for batching status updates. The workflow leverages GPT-4o-mini for intelligent email parsing and includes approval gates to maintain data integrity while automating your job search pipeline.