Construction Hiring Tracker — Free Sheets ATS

The call comes in on a Thursday: the bid landed, the municipal job is yours, and mobilization is five weeks out. Which means the real project starts now — finding two more framers, an electricians' helper, and an operator who can actually run the excavator, not just claim to.

In most construction companies, that search runs through the foreman's phone. He texts the crew: "know anybody?" Names trickle in over three days, half with no last name, a couple with a photo of an OSHA card that gets buried under two hundred other messages. Somebody good gets recommended, nobody calls him for a week, and he's on another outfit's payroll by Monday. The referral system works — the tracking of it is what fails.

Hiring software priced for HR departments — Workable at $199 a month, Greenhouse around $6,500 a year — is built for people who hire year-round from resumes. Crews get built in bursts, from referrals and licenses. Here's how to build a hiring tracker that matches, out of a Google Sheet, for free.

Step 1: A Sheet Organized by Trade

Two tabs do the job. Roles carries one row per open slot, by trade — framer, electricians' helper, operator — each with its must-have tickets. Applicants starts blank and gets written automatically:

That "Referral from" column is the one your current process loses — and the one worth the most.

Step 2: Get the Free Account

Register at lovespreadsheets.com. Nothing about building or running the tracker costs money; paying adds logins for supers and project managers, plus your own domain on the hiring page.

Step 3: Explain the Flow Like You're Talking to a New PM

Select the Website template and lay out how applications should move:

"A hiring page showing our open crew positions grouped by trade, pulled from the Roles tab. An applicant picks a trade and answers a quick chat-style application: years on the tools, which certs and licenses they carry — with photo upload for the cards — who on our crew sent them, and how soon they can start. Every application drops into the Applicants tab as a row. Score each one 1–100 against that trade's requirements, counting relevant experience, current certs, and a referral from someone on our crew, and spell the reasoning out in writing. Send a confirmation email instantly so good hands know we saw them."

Then bolt on the three requests that make it construction-grade:

• Trade-specific screening questions — an operator gets asked about machine hours and tickets; a framer gets asked about layout and headers, not the same generic form
• Cert and license uploads at apply — the OSHA card photo attaches to the row the moment it's submitted, ready for your super to verify
• Referral tracking with priority — anyone vouched for by current crew surfaces on a priority-call list, so referrals get phoned first instead of forgotten

Hit AI Optimize to tighten the write-up, answer whatever the AI asks back, and the build wraps inside 15–20 minutes.

Step 4: The Whole Bench in One Place

You get a live hiring page — text the link to the crew to pass along, drop it in the job posting. Applications hit the sheet in real time, scored and explained before you've opened one, with a confirmation already sent so nobody's left wondering whether it went through.

The score is a stack-ranking, not a verdict. A 91 means "call this one first," and the reasoning tells you why — nine years in the seat and Marco's word. Whether he's hired gets decided by the super who talks to him, same as always.

Why Construction Companies Keep the Sheet

Referrals become an asset instead of a text thread. Every name the crew sends is captured with who sent it — and vouched-for applicants get the first calls, which keeps the referrals coming.

Verification starts before the interview. License and cert photos arrive attached to the application, so your super checks cards on day zero instead of discovering a lapsed ticket at orientation.

Burst hiring costs nothing extra. Staffing up for a big job doesn't mean activating a subscription — the tracker's just there, whether you hire eight people this month or none.

Common Questions from Construction Companies

Our applicants apply from a truck at lunch — will they bother? That's the point of the chat format: short questions, tap-to-answer, snap a photo of the license instead of typing it out. It's closer to texting than to paperwork.

Does a crew referral guarantee the job? No — it earns the first phone call and a note in the scoring reasoning. The hiring decision stays with your super and PM.

Can we track day-one readiness too? Ask for it in your description — columns for PPE sizes, paperwork received, and confirmed start date are exactly the kind of add-on the AI builds in when you request it.

Build Yours

Put your open slots in a Roles tab, go to lovespreadsheets.com, and describe how your company actually finds people — trades, tickets, and crew referrals. Five weeks before mobilization, that's the difference between a full crew and a foreman's phone full of first names.