Stop Losing Track of Candidates to Chaos

Transform Google Sheets™ into a customizable applicant tracking system! This ready-to-use template helps small businesses and recruiters start managing job openings, tracking candidates, and making better hiring decisions, without expensive software or a complex setup.

KEY FEATURES

• Requisition Management – Create job openings with auto-generated Job IDs, track status (Open, On Hold, Closed, Hired), and monitor Days Open metrics automatically.

• Candidate Database – Maintain a complete repository of all candidates and profiles. Build your talent pool by adding contacts for future opportunities.

• Active Pipeline View – See only candidates for currently open positions. When jobs close, candidates automatically move to historical records.

• Bidirectional Sync – Edit in any tab and changes sync everywhere within seconds. Work where it's most convenient without worrying about data consistency.

• Resume Import – Upload PDF or DOCX resumes directly. The system automatically extracts contact information (email, phone, LinkedIn) and creates candidate profiles.

• Bulk Import – Add multiple candidates at once by pasting spreadsheet data. Perfect for migrating from other systems or importing sourced candidate lists.

• Candidate Submission Form – Optionally create a Google Form™ that candidates complete to apply. Submissions flow directly into your database.

• Hire Flow Automation – When you hire a candidate, the system updates the job status, records the hire date, and automatically marks other candidates as rejected.

• Customizable Workflows – Configure interview stages, rejection reasons, and dropdown options to match your recruiting process.

• Dashboard & Metrics – Track open requisitions, average days to fill, conversion rates, and hiring trends at a glance.

HOW IT WORKS

The template includes three main tabs that stay synchronized:

• Requisitions – All job openings with status tracking and timeline metrics
• Candidate Database – Complete candidate records and talent pool profiles
• Active Candidates – Filtered view of your current pipeline for open positions

WHO IT'S FOR

Designed for small to mid-sized business owners, office managers, recruiting teams, HR departments, and hiring managers who want a straightforward way to track candidates without the cost and complexity barrier of enterprise ATS software.

WHAT'S INCLUDED

• Pre-configured spreadsheet template with automation
• Customizable workflow stages and dropdown menus
• Resume upload sidebar with contact extraction
• Optional candidate submission form setup
• Dashboard with recruiting metrics
• Comprehensive documentation (Quick Start, User Operations, and Admin Reference guides)

PRIVACY AND SECURITY

All data remains in your Google account. Resume files are processed in your browser and never uploaded to external servers. You can review the automation code at any time via Extensions > Apps Script.