Love Spreadsheets
PricingContactAPI
Log inSign up free
Tutorials

Free ATS for Small Business — Google Sheets Hiring Tool

Love SpreadsheetsPublished Jul 22, 20265 min read

Marcy owns an auto repair shop with five bays and needed a service advisor. She posted on Indeed, dropped a note in the neighborhood Facebook group, and mentioned it to every regular who came through. What she got back was a drawer full of chaos: PDFs in her inbox, Facebook messages she found a week late, and a promising candidate whose number lived on a sticky note that went through the wash.

Her previous hire took two months. Not because nobody applied — thirty people did — but because Marcy is the recruiter, the bookkeeper, and the person under the lift. Interviews got squeezed into lunch breaks, follow-ups slipped three days, and the best applicant took another job while her reply sat in drafts.

Hiring software exists for this, but Workable wants about $199 a month whether you're hiring or not, and a shop that adds two people a year can't justify a subscription that costs more than the ad. There's a better fit: one Google Sheet, turned into a real hiring system by AI — careers link, resume screening, and reminder emails included — for free.

Step 1: Set Up the Hiring Sheet

Make a tab called Roles with a row for each job — title, what it pays, what it needs, open or filled. Then a tab called Applicants that the system will populate on its own. Its columns look like this:

ColumnExample
ApplicantJordan Reyes
RoleService advisor
SourceIndeed
Score84
StageInterview
Interview dateJul 29, 12:30 pm
AvailabilityWeekdays, can start Aug 4
Notes3 yrs at a dealership; asked about Saturdays

The Source column earns its keep fast — after one hire you'll know whether Indeed or the Facebook group actually sends you people worth meeting.

Step 2: Grab a Free Account

Sign up at lovespreadsheets.com. Everything in this article — the page, the scoring, the emails — runs on the free tier. You'd only pay if you later want logins for a manager or the application page living on your own web address.

lovespreadsheets.com
Describe what you want to build from your spreadsheet…
shop_hiring.xlsxSend →
Your free account, your sheet attached — shop_hiring.xlsx stays the source of truth.

Step 3: Say What You Need, in Owner Language

Choose the Website template and type the request the way you'd explain it to a friend who's good with computers:

"I want one page that shows my open jobs from the Roles tab. Someone taps a job, answers a few quick questions like a text conversation — name, phone, email, when they can work — and uploads a resume if they have one. Put every application in my Applicants tab, rate it 1 to 100 against what the job needs with a short note on why, and send the person an email right away so they know I got it."

Three add-ons worth asking for while you're typing:

  • One careers link you can paste into Indeed, the Facebook post, your Google Business profile, and a text to your regulars — every source funnels into the same sheet
  • Same-day alerts whenever an applicant scores high, so the strong ones hear from you within hours instead of weeks
  • Interview reminders in both directions — the candidate gets one the morning of, and so do you, because you'll be under a car at 12:15

The AI might ask a clarifying question or two, then builds the whole thing in about a quarter of an hour.

lovespreadsheets.com
"One page with my open jobs from the Roles tab; people answer a few questions like a text conversation, get rated 1 to 100, and hear back right away."
shop_hiring.xlsx✦ AI OptimizeSend →
Plain English is the whole interface — AI Optimize tightens the wording if it needs it.
lovespreadsheets.com
Building your hiring page
Reading your columns
Designing the app
·Wiring two-way sync
The AI builds while you watch (or play) — typically 15–20 minutes.

Step 4: Hiring Runs Itself Between Oil Changes

From then on, applications file themselves. Each new row shows up scored and explained before you've opened a single attachment, so a two-minute glance at the sheet tells you who to call first. Move people through stages — Applied, Screened, Interview, Offer, Hired or Passed — right from your phone between customers.

The number next to each name is a reading order, nothing more. You still meet people, trust your gut, and make the call; the sheet just makes sure the best applicant isn't discovered on day 40. This is the same system a startup used for a 200-applicant hiring rush, shrunk to fit a business run by one busy owner.

lovespreadsheets.com
hiring.eastsideautoworks.comCopy link
Private — team logins only+ Add team memberCustom domain: Connect
One link for the whole team — private logins and your own domain are the paid extras.
What you end up with
hiring.eastsideautoworks.com
Shop Hiring BoardLive appSynced to your sheet
Service Advisor3 applicants
84Jordan Reyes3 yrs at a dealershipInterview Jul 29
76Kelly NashWeekdays only — Saturdays?Screen call
68Rita VaughnPassed
A two-minute glance tells you who to call first — stages move from your phone between customers.

Why Small Business Owners Keep the Sheet

Zero dollars during the quiet months. You might hire twice a year. A sheet doesn't invoice you in the ten months between.

Nothing new to learn. It's the spreadsheet you already understand, wearing a nicer shirt. No onboarding videos, no admin console, no "workspace setup."

Speed wins the good ones. Small shops beat chains on one thing: a human answers fast. Instant confirmations and same-day alerts let you be the first callback a great applicant gets.

Common Questions from Small Business Owners

What if applicants don't have a resume? Plenty won't. Ask the AI to add a couple of role-specific screening questions, and applications get evaluated on those answers plus whatever experience they describe.

Do I need a website first? No — the careers page comes with its own link. Paste it anywhere text goes; a site of your own is optional.

Can it turn people down for me? It won't, and it shouldn't. Every applicant gets an acknowledgment automatically, but decisions and rejections stay yours — that's your name on the door.

Build Yours

List your open job in a sheet, open lovespreadsheets.com, and describe the hiring help you wish you had. If your business is a restaurant, there's a version tuned for hourly hiring too. This time next week, applicants get answered while you're still under the lift.

Skip the manual steps — build this in 60 seconds
Upload the sheet you already have and let AI turn it into a working app.
Try it free
More versions of this guide
Written by
Love Spreadsheets

The team turning other people's spreadsheets into software they actually trust — one sheet at a time.

Keep reading

Tutorials

Tax Calculator Lead Generation for Accountants

Jul 22, 20265 min read
Tutorials

Contractor Estimate Calculator That Wins You Leads

Jul 22, 20264 min read
Tutorials

Macro Calculator for Coaches: Grow Your List, Not Ads

Jul 22, 20264 min read

Your spreadsheet is already an app. Let's turn it on.

Upload your sheet and watch it become a working app — with a real engineer to finish the last mile with you.