Track job applications from Gmail to Google Sheets with Groq and Ollama

How it works

Monitors your Gmail inbox** for job-related emails and extracts application details using a local AI model (Llama 3.1 via Ollama)

Analyzes email content** to determine application status and enriches the data with structured fields Appends or updates rows** in your Google Sheet automatically, keeping your job tracker always up to date Falls back to Groq (Llama 3.3) if the local Ollama model is unavailable

Set up steps

Run docker compose up -d to spin up n8n and Ollama, then pull the model with docker exec -it jobstatusanalyser-ollama-1 ollama pull llama3.1:8b

about 5 minutes depending on your internet speed

Access n8n at http://localhost:5679 , import text.json via Workflows → Import from File, and set up three credentials: Gmail OAuth2, Google Sheets, and optionally a Groq API key

In the Config (Live) and Config (Backfill) nodes, replace googleSheetId and googleSheetUrl with your own sheet values, then activate the Gmail Trigger