Caregiver Applicant Tracking — Free ATS from Sheets

Ask anyone who runs a home care agency what they're hiring for and the answer is "always." Caregiver turnover across the industry runs somewhere between brutal and heartbreaking — agencies routinely replace most of their field staff inside a year — which means recruiting isn't a project with an end date. It's a permanent background process, running while you're also scheduling visits, supporting families, and covering call-outs.

And caregiver hiring carries paperwork that ordinary hiring doesn't. A promising CNA applies on Monday; by the time someone finds her certificate scan in the inbox, confirms her CPR card hasn't lapsed, orders the background check, and reaches her two references, it's the following Thursday — and she accepted an offer from the agency across town on Wednesday. Nothing failed except the tracking.

Recruiting platforms priced for corporate HR — about $199 monthly for Workable, near $6,500 annually for Greenhouse — weren't designed for any of this. What an agency needs is a hiring system shaped like its own compliance checklist. You can build one from a Google Sheet, free, in under half an hour of describing what you want.

Step 1: A Sheet Shaped Like Your Checklist

Two tabs. Roles lists what you're recruiting for — CNA, HHA, companion caregiver — each with its requirements. Applicants fills itself as people apply, one row per person, with the fields your coordinators actually check:

Every one of those columns is something that currently lives in a different place — an email, a folder, someone's memory. Here it's a single row.

Step 2: Sign Up (It's Free)

Create an account at lovespreadsheets.com. Building and running the hiring system costs nothing; paid plans add logins for each coordinator and a custom web address, neither of which you need on day one.

Step 3: Describe Hiring the Way Your Agency Does It

Pick the Website template — your applicant tracker is really a small hiring site connected to the sheet — and explain the flow in your own words:

"A page listing our open caregiver roles from the Roles tab. Applicants move through a warm, conversational application: name, contact details, caregiving experience, which certifications they hold, and an upload step for their certificate and CPR card. Each completed application becomes a row in my Applicants tab with the documents attached. Score every applicant 1–100 with a written explanation, weighting hands-on care experience, dependability signals, and completeness of documents. Send a kind, immediate confirmation email — people who spend their days caring for others shouldn't wait a week to hear from us."

Then request the pieces that make it agency-grade:

• Document upload at application — cert scans and CPR cards land in the applicant's row on day zero, not in a follow-up text chain
• Expiry flags — anything dated, like a CPR card within 60 days of lapsing, gets visibly flagged so renewals never ambush onboarding
• Reference-check tracking — a status per reference, so "did anyone reach her second reference?" has an answer sitting in the row

Run AI Optimize on the description, answer the clarifying questions that come back, and the app assembles itself in about twenty minutes.

Step 4: One Row Tells the Whole Story

Your hiring page goes live at its own URL — add it to your website and every job posting. From then on, each applicant arrives as a complete row: documents attached, score and reasoning written in, confirmation email already sent. Coordinators update stages and reference statuses as they work, and the sheet remains your permanent, exportable record.

One thing to keep straight: the background-check column is a tracking field. Your team orders the check through your screening provider and records the result — the tool keeps the status visible; humans do the verifying. Certificates work the same way: the upload gets the document to you instantly, and a coordinator confirms it's valid.

Why Home Care Agencies Keep the Sheet

The pipeline survives constant recruiting. When hiring never stops, an inbox-based process drops somebody every week. A sheet that fills itself doesn't.

Documents show up with the person. Collecting a cert scan at application time collapses the slowest week of caregiver onboarding into a single step.

Nothing dated goes unnoticed. CPR expirations and pending checks sit flagged in plain sight instead of surfacing mid-orientation.

Common Questions from Home Care Agencies

Does this run the background check itself? No. It tracks the status your team enters — ordered, pending, cleared — while your usual screening provider performs the actual check. Nobody advances on software's say-so.

Is scoring caregivers by number appropriate? The score only orders the pile, using criteria you wrote — experience, reliability, documentation — and it shows its reasoning. Compassion gets judged where it should be: by your coordinators, in the interview.

What about applicants who don't have all their documents yet? They can still apply; the empty columns simply show what's outstanding, and your team follows up — which beats never learning they existed.

Build Yours

List your open roles in a sheet, head to lovespreadsheets.com, and describe the hiring process your agency wishes it had. The next caregiver who applies gets an immediate, respectful reply — and your coordinators get one row that answers every question about where she stands.