Hiring Pipeline & Robin — AI Pre-Screening for R Squared AI
A complete Google Sheets and Apps Script hiring pipeline built for R Squared AI's frontend developer hiring, with an AI agent called Robin that stack-ranks resumes A/B/C against weighted criteria.
Inbound resumes piling up, no consistent way to evaluate.
Frontend hiring at R Squared AI was generating inbound applications faster than the team could evaluate them with consistency. Resumes lived in Gusto. Status updates lived in someone's head. Decline emails were written one at a time. There was no shared scoreboard for who was where in the funnel and no shared lens for what made a strong candidate.
What was needed: a single tracker covering every stage from application to offer, a consistent evaluation lens applied before a human spent time, and automation to handle the mechanical parts (status updates, decline emails, date stamps) so people could focus on the interviews that mattered.
A 60-column tracker with an AI pre-screener at the top of the funnel.
Preisser Solutions built the full pipeline in Google Sheets with Apps Script automation. The master tracker is 60 columns wide and covers the entire hiring funnel — application intake, resume review, three interview rounds, references, and offer status. Apps Script handles automated decline emails (three stage-specific templates), status updates, and date-stamping on every state change.
Robin is the AI agent at the front of the pipeline. Robin reviews resumes in Gusto and stack-ranks candidates A, B, or C against weighted hiring criteria before a human ever looks. The combination of Robin and the tracker means the team spends time on the candidates most likely to move forward — not on triaging the full inbox.
Pipeline architecture.
Google Sheets master tracker with 60 columns covering the full funnel
Apps Script onEdit trigger automation
Robin AI pre-screener — stack-ranks resumes A/B/C against weighted criteria
Three auto-sent stage-specific decline email templates
Two manual invite email templates for interview rounds
Automatic status updates and date-stamping on every state change
Stages tracked
- Inbound application and resume review
- Robin pre-screen rank (A / B / C)
- Interview round 1
- Interview round 2
- Interview round 3
- References, offer, and final status
Automation surface
- Three decline email templates — application, post-interview, and post-final
- Two invite templates for interview round coordination
- onEdit triggers update statuses and timestamps automatically
- Robin reviews Gusto resumes and writes the rank back to the tracker
Outcomes the engagement actually produced.
The master tracker captures every state from inbound application through references and offer in a single sheet.
Robin reviews resumes in Gusto and assigns each candidate A, B, or C against the weighted hiring criteria before a human reviews.
Application, post-interview, and post-final decline emails fire automatically from Apps Script based on state changes.
The pipeline is live for R Squared AI's frontend developer hiring — the same pattern is replicable for any role family.
Related case studies
Contact Form → CRM → AI Pipeline
End-to-end automated lead pipeline, zero manual steps
AI Email Digest System
Daily executive briefing — every important email summarized
Agentic AI Coding Specialists
Specialized agentic coding agents tuned per build domain
Want an AI pre-screener at the top of your hiring funnel?
Preisser Solutions can deploy a Robin-style hiring pipeline for any role family — tracker, automations, and AI pre-screen included. Free 30-minute scoping call.