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