Overview
For teams hiring 2-20 roles per year, a Sheet plus SheetLink Forms replaces a recurring ATS subscription. Handles the full funnel from applied to offered with interviewer assignment and hire/reject status.
Column layout
Copy this column order into a blank Google Sheet, or let SheetLink Forms create the headers for you on first submission.
| Column | Notes |
|---|---|
| Application ID | Unique ID |
| Applied on | Timestamp |
| Candidate | Name |
| Role | Dropdown of open roles |
| Resume link | URL from form upload |
| Optional URL | |
| Years of experience | |
| Current company | |
| Why interested | Freeform - their cover-letter answer |
| Stage | Applied / Screen / Interview / Offer / Hired / Rejected |
| Recruiter | Assigned |
| Source (UTM) | Where they came from |
| Interviewer notes | Freeform |
| Decision date |
Useful formulas
Paste these into a top-of-sheet summary row or a separate dashboard tab.
Applicants this week
=COUNTIFS(B:B,">="&TODAY()-7)Pipeline by stage
=COUNTIF(K:K,"Interview")Repeat for each stage.
Source attribution
=COUNTIF(M:M,"linkedin")Repeat per source to see best hiring channel.
Conditional formatting
- Stage: blue for Applied/Screen, yellow for Interview, green for Offer/Hired, gray for Rejected.
- Decision date: red if Applied or Screen and older than 7 days - avoids stalled candidates.
Pivot table guidance
Pivot with Stage as rows, Role as columns. Shows funnel depth per role at a glance. Second pivot: Source by Stage to find the best hiring channel.
Recommended add-ons
- AI Lead Scoring (repurposed): Can be reframed as a resume-signal scorer for initial triage.