Free Job Application Tracker – Google Sheets Apps Script

A hiring dashboard that takes a job application from the form it arrived on to the interview that was scheduled for it, with Google Sheets as the database. Small teams usually run recruitment out of a shared inbox: applications sit in email, shortlists live in someone's head, and candidates are left without a reply. This puts the pipeline, the decisions and the emails in one place.

What it does

Applications come in through a job application form and land in the dashboard. HR reviews each candidate and moves them along — shortlisted, rejected, scheduled — and the candidate's status is visible at every step rather than implied. Interviews are scheduled automatically and an interviewer is assigned and tracked, so nobody has to chase who is taking which call. Emails go out from a customisable template library, which is what makes a rejection actually get sent: it is one action against a template rather than a message somebody has to find the words for. Access is role-based for HR and interviewers, and an activity log records what was done and when.

Highlights

• Application form feeding straight into the dashboard
• Candidate status monitoring across the hiring pipeline
• Shortlisting management and a rejection workflow
• Automated interview scheduling
• Interviewer assignment and tracking
• Customisable email template library with automated sending
• Role-based access for HR and interviewers
• Activity logs and audit trail

Who it is for

HR teams, recruitment agencies, schools and growing companies that hire often enough for a shared inbox to break down, but not often enough to justify paying per seat for an applicant tracking system.