Applicant Tracking System (ATS) Template — Candidates That Move Themselves Through the Pipeline

Target Keyword: ATS template Secondary Keywords: applicant tracking system, hiring tracker, recruitment pipeline template, candidate management Vertical: Gap Wave Word Count: ~1,050

Small hiring teams run into the same wall: they need an ATS, but Greenhouse costs $6,000 per year and Lever wants a multi-year contract. So they build a spreadsheet. The spreadsheet works for three candidates. By candidate thirty, half the applicants have been sitting in "Phone Screen" for two weeks because nobody remembered to move them forward, and the best candidates have already accepted offers elsewhere.

The OpenSource AI Pro Applicant Tracking System is built for teams that need pipeline automation without enterprise pricing. Candidates move through stages with auto-assignment rules. When a candidate transitions from one stage to the next, the hiring manager gets an email alert. When a candidate has been sitting in any stage beyond the expected duration, a Stale_Candidate flag fires. A daily digest summarizes your entire pipeline: new applicants, candidates in progress, interviews scheduled, and offers extended.

Key Features

• Pipeline Stage Automation — Define your hiring stages (Applied, Phone Screen, Interview, Technical Assessment, Offer, Hired, Rejected). When a candidate's stage changes, auto-assignment rules route them to the right reviewer for the next step.

• Stage-Transition Alerts — When a candidate moves to a new stage, an event-triggered email fires to the assigned interviewer or hiring manager. The alert includes the candidate name, position, new stage, and any notes from the previous stage.

• Stale_Candidate Flag — A formula field tracks how long each candidate has been in their current stage. When the duration exceeds the expected time for that stage, the flag fires. No more candidates quietly dying in "Awaiting Feedback" for three weeks.

• Daily Pipeline Digest — A scheduled automation sends a morning summary of your hiring pipeline: new applications received, candidates per stage, stale candidates flagged, and interviews scheduled for today. Your recruiting lead starts the day with full visibility.

• Interview Log — Track every interview with date, interviewer, scorecard rating, and notes. Roll up interview scores per candidate to see aggregate team feedback in one view.

• Position and Department Organization — Link candidates to open positions. Link positions to departments. Track time-to-fill and pipeline velocity per role and per department.

How It Works

The Formula Flags

Each candidate record carries a Current_Stage, a Stage_Entry_Date, and a linked Position with expected stage durations. The Stale_Candidate formula compares today() - Stage_Entry_Date against the expected duration for the current stage. When the candidate has been in-stage longer than expected, the flag fires.

A second formula calculates Days_in_Pipeline (total time from application to current date) so you can track overall candidate experience alongside stage-level velocity.

The Event Alerts

When a candidate's Current_Stage field changes, an event-triggered automation identifies the new stage's assigned reviewer and sends them an email. The alert includes everything they need to act: candidate name, resume link, position title, and any notes from the previous reviewer.

When the Stale_Candidate flag fires, a separate alert notifies the recruiting lead so they can follow up with the interviewer or move the candidate forward.

The Scheduled Digest

A daily automation compiles pipeline metrics and sends a summary email: total open positions, candidates per stage, new applications in the last 24 hours, candidates flagged as stale, and interviews scheduled for today. Your hiring team gets a complete pipeline snapshot without opening the system.

Who It's For

• Startup hiring managers (10-200 employees) who need structured recruiting without Greenhouse or Lever pricing
• HR generalists managing hiring for multiple departments simultaneously
• Recruiting coordinators tracking candidates across phone screens, interviews, and offers
• Agency recruiters managing candidate pipelines for multiple client companies
• Department heads who want visibility into their open positions without learning an ATS
• Nonprofits and educational institutions hiring with limited HR technology budgets

vs the Alternatives

| | OpenSource AI Pro | Greenhouse / Lever | Google Sheets | |---|---|---|---| | Pipeline automation | Stage-transition alerts, auto-assign | Full ATS with integrations | Manual updates | | Stale candidate flags | Formula-driven, automatic | SLA tracking at enterprise tier | None | | Per-seat cost | $0 (self-hosted) | $6,000+/year base | Free but no automation | | Interview scorecards | Built-in | Built-in | Manual templates | | Setup time | Under 30 minutes | Weeks of implementation | Hours of spreadsheet design |

Greenhouse and Lever are best-in-class applicant tracking systems with job board integrations, interview kits, and EEOC compliance reporting. If you are hiring 50+ roles per year and need those capabilities, they are worth the investment. But if your team hires 5-20 roles per year and needs candidates to stop falling through the cracks, this template delivers pipeline automation at self-hosted cost.

What's Included

• Candidates table — Name, email, phone, resume link, source, current stage, Stage_Entry_Date, Stale_Candidate flag, Days_in_Pipeline, assigned reviewer
• Positions table — Title, department, hiring manager, status (Open/Closed/On Hold), expected stage durations, time-to-fill
• Interviews table — Candidate, interviewer, date, stage, score, notes, recommendation
• Departments table — Department name, head, linked positions, open position count
• Pre-built views — All Candidates, By Stage, Stale Candidates, By Position, Interview Schedule, New Applications, Offers Extended
• 2 automation workflows — Stage-transition alert (with auto-assignment) + daily pipeline digest
• Formula fields — Stale_Candidate flag, Days_in_Pipeline, Days_in_Current_Stage, position time-to-fill, pipeline velocity

Get Started Free

Download the Applicant Tracking System template and deploy it on your own Baserow instance. A real recruiting pipeline. No per-seat fees. No annual contracts.

Download Free Template

Self-hosted on Baserow. Open source. Zero per-seat pricing.

Related Templates

• Attendance & PTO Tracker — Track employee time off with automated approval workflows.
• Timesheet & Time Tracking — Manage time entries with project-budget rollups and over-budget flags.
• Booking & Appointment System — Schedule interviews and client appointments with automated confirmations.