Effortless Job Application Tracker: Automate Gmail to Google Sheets

Stop manually tracking job applications across scattered emails and spreadsheets. This n8n workflow automatically monitors your Gmail inbox for job-related emails and intelligently extracts application details into a Google Sheets tracker using local AI processing.

What this workflow does

This automation transforms your Gmail inbox into an intelligent job application tracking system:

• Monitors Gmail automatically - Scans your inbox continuously for job-related emails from recruiters, hiring managers, and job boards
• AI-powered content analysis - Uses Llama 3.1 via Ollama to extract key application details and determine status updates from email content
• Structured data enrichment - Converts unstructured email information into organized fields for consistent tracking
• Google Sheets integration - Automatically appends new applications or updates existing rows in your spreadsheet tracker
• Fallback reliability - Switches to Groq (Llama 3.3) when the local Ollama model is unavailable

Use cases

• Job seekers managing multiple applications across different companies and platforms
• Career changers tracking interview stages, follow-ups, and application outcomes
• Recruiters and HR professionals monitoring candidate communication flows
• Freelancers tracking project inquiries and client communications

Technical details

Built with essential n8n nodes including Gmail trigger, HTTP request for AI processing, Function nodes for data transformation, Set nodes for field mapping, and conditional If nodes for smart routing. The workflow leverages:

• Gmail OAuth2 for secure email access
• Google Sheets API for spreadsheet automation
• Local Ollama with Llama 3.1 model for privacy-focused AI processing
• Groq integration as cloud-based fallback option
• Docker deployment for easy setup and consistent performance

Setup takes approximately 5 minutes with the included Docker Compose configuration. Simply import the workflow, configure your credentials, and customize your Google Sheet details to start automated job application tracking.