Automation / Personal Project

Job Tracker

Watches OnlineJobs.ph for matching developer roles and keeps the good fits in a Google Sheet with scores and application tracking.

View Code

Job Tracker Google Sheet showing matched OnlineJobs.ph roles with salary and employment type — Part Time tab of the Job Tracker sheet listing matched OnlineJobs.ph roles with job links, salary text, employment type, and posted dates.

How it works

Google Apps Script reads enabled searches, checks up to 50 job pages per run, and scores matches on skills like Next.js, Supabase, and Claude Code. Open roles land in employment-type tabs with match score, reason, and location, while Applied rows move to Applications and unapplied discovery rows expire after 14 days. A Runs tab logs each execution.

Capabilities

Scheduled hourly refresh plus manual Run now from the sheet menu
Skill scoring with match reason and location per job
Open-role filtering with closed and bad-fit jobs hidden
Application tracking with permanent Applications history
Per-run diary with added counts and error reporting
Structured JSON execution logs per run

Built with

Google Apps Script
JavaScript
GitHub

Related projects

Resume RAG

Automates resume synchronization from Google Docs into Supabase vector embeddings and drafts tailored job application emails using an n8n LangChain chat agent.

Gmail Inbox Organizer

Keep important messages in view while routine email is labeled and archived automatically, without deleting messages or changing unread status.