Retail Hiring Tracker — Free ATS from Google Sheets

Every retail manager knows the hiring calendar better than any recruiter does. Nothing happens in February. Then October arrives, corporate approves six seasonal headcount, and thirty applications hit in three weeks — a stack of paper forms behind the register, a tangle of job-board messages, and two walk-ins who talked to the assistant manager on a Saturday and were never written down anywhere.

The applicants themselves don't fit resume logic. They're students who can close on weeknights but vanish during finals, parents free exactly nine-to-two, and — the most valuable group of all — last December's seasonal hires who were never late once. That last group should get the first call every fall. Instead, the list of who they were lives in a manager's memory, and managers change stores.

Subscription applicant-tracking software wants $199 a month from Workable or roughly $6,500 a year from Greenhouse — twelve months of billing for six weeks of hiring. The better fit for a store: a Google Sheet that becomes a real hiring tracker, with an AI-built careers page on top, for free.

Step 1: One Sheet for Every Store

Give the sheet two tabs. Roles holds a row per opening per location — "Seasonal associate, Riverside Mall, open" reads differently from "Keyholder, Downtown, open," and your careers page will treat them differently too. Applicants stays empty; the system writes it for you. Its columns:

Notice what's missing: a resume column doing all the work. Retail hires on reliability and schedule fit, so the sheet is built around those.

Step 2: Open a Free Account

Sign up at lovespreadsheets.com. The careers page and tracker cost nothing to build or operate; if you later want each store manager on their own login, or the page on your shop's own domain, those are the paid add-ons.

Step 3: Say It the Way You'd Brief an Assistant Manager

Choose the Website template and write out the hiring flow in ordinary language:

"Build a careers page that lists open positions at each of our three stores from the Roles tab. An applicant picks their store and position, then goes through a short application conversation — name, contact info, any past retail work, and a grid where they mark the days and hours they can actually work. Each finished application becomes a row in the Applicants tab, tagged to the store they picked. Score every application 1–100 against that role, weighting dependable availability and customer-facing experience over resume polish, and write a one-line reason beside the score. Send an automatic confirmation email the second someone applies."

Three retail-specific requests worth adding:

• Location routing — Riverside applications land filtered for Riverside's manager, so nobody screens candidates for a store across town
• Availability captured up front — the grid gets filled at apply time, ending interviews that die at "so, can you work Saturdays?"
• A rehire shortlist — anyone your team marks "great last season" rolls into a first-call list you pull up every October before posting a single job

Click AI Optimize if the wording feels clumsy, answer the follow-up questions the AI asks, and the build finishes in roughly 15–20 minutes.

Step 4: Live Before the Season Is

You get a careers page URL — put it in job posts, and print a QR code for the counter so walk-ins apply on their phones instead of on paper that gets lost. Applications appear as sheet rows the moment they're submitted, already scored with the reasoning spelled out, and every applicant has a confirmation in their inbox before a manager has looked up.

Treat the score as a sort order, nothing more. An 85 who can only work Tuesday mornings loses to a 70 with wide-open weekends — the number gets the right applications read first, and the manager makes the call.

Why Retail Managers Keep the Sheet

October starts with a list instead of a scramble. The rehire column turns last season's best people into this season's first calls — before competitors' postings even go up.

Schedule mismatches die at the application. Availability sits in the row from minute one, so interviews only happen with people who can cover the hours you're actually short.

The tracker doesn't bill you in March. Seasonal hiring means months of silence; a sheet-based system idles for free while a subscription keeps charging.

Common Questions from Retail Stores

Can someone apply to two of our locations at once? Yes — describe it that way and the application flow lets them pick multiple stores, creating a row per location so each manager sees them.

What do we do with applicants once the season wraps? Nothing gets deleted. Mark the standouts in the Rehire? column, and next fall's shortlist is already sitting in your sheet.

Will teenagers actually complete it? More reliably than a PDF. It's a short conversation on a phone — tapping an availability grid beats formatting a resume for a first job.

Build Yours

Open a fresh sheet, list this season's openings in a Roles tab, and go to lovespreadsheets.com. Describe how hiring should work across your stores, and by the weekend every application — walk-in, job board, or somebody's niece — funnels into one scored, sorted list with nobody left waiting on a reply.