Automating weekly recruiting KPIs
TL;DR
Ryan Taft, Recruiting Lead at Serval, built an automated workflow that delivers leadership a detailed progress report ahead of weekly engineering hiring meetings. It reads a live headcount plan from Google Sheets, pulls hiring statuses and real-time pass-through rates from Ashby, compiles the top candidates in the pipeline, and delivers a summary directly through Slack and email.
The problem
Serval is hiring many engineers on a very short timeline. Each week, leadership needs to know if the funnel is on pace, and if not, which stage is behind and how many more interviews or referrals it takes to catch up. "[At past companies], I’d pull this data essentially every week from a bunch of different sources and have to manually stitch it all together," Taft says.
The build
Ryan worked with Catalyst to build a single scheduled workflow that generates the report. Because the workflow connects to live applications instead of reading static data, the report updates in real time as hires are made or plan changes.
1. Connected Google Workspace so the workflow can read the finance-approved headcount sheet in real-time.
2. Connected Ashby to pull, per function and role, the last three months of pass-through rates at each stage, hires made, and every candidate currently in the pipeline with their stage and source.
3. Defined the key inputs and data sources, working with Catalyst to figure out the right places to pull data from each system, only looking at the info that matters most (like headcount targets, candidate counts by funnel stage, and priority roles)
4. Defined the KPIs from these inputs. Each metric is computed in code with a fixed definition, so funnel conversion is calculated the same way every time. Catalyst also suggested new metrics along the way (like number of recruiting screens or referrals needed per week to hit the goal).
5. Test the output against live data to confirm the report shows that leadership needs.
6. Deliver an executive summary in Slack and detailed findings directly to each attendee’s inbox, exactly 90 minutes before the weekly meeting.
Results
Remove manual work. Completed automated reporting every week.
Make staffing plans concrete. Assign limited talent resources based on screens and interviewers for each role to stay on plan.
Surface hiring problems quickly. See weekly stages for every role to see where candidates are getting stuck and fix it.
Flag promising candidates early. Report marks candidates with referrals and strong-yes scores, so recruiters and hiring managers know who to prioritize.
How a self-service help desk resolves IT requests at scale
Freshservice alternatives for IT teams that have outgrown it
Access provisioning: The foundation of secure user access
Beyond the queue: A guide to enterprise IT management tools
Security automation: 6 tools to scale your defense strategy
Business process automation examples: How real teams eliminate repetitive work
What is information technology governance?
Beyond Jira Service Management: 8 alternatives for IT teams
What’s an enterprise knowledge management system?
The service management lifecycle: ITIL stages and tips
The best workflow automation software for IT teams
Automated approval workflows: Eliminate bottlenecks and enforce compliance
Reduce routine tickets: How to automate password resets
Automated employee onboarding: Key considerations for IT teams
Just-in-time privileged access management: Benefits and tips
How to calculate and maximize IT automation ROI
AI automation ticketing systems: A guide for IT teams
AI agents for IT: Types, examples, and design practices
Eesel and Siit alternatives for enterprise IT: Serval vs. Monday.com
Switching ITSM platforms: ITSM migration and implementation guide
SOC 2 compliant ITSM with automated audit trails for HIPAA and IT governance
How to quantify IT automation ROI and build a business case for IT automation
Natural language workflow automation for enterprise IT teams
Moving off Moveworks: what enterprise IT teams are choosing instead
Just-in-time access provisioning: architecture that automates from the help desk
IT asset management without spreadsheets: a practical guide for enterprise teams
The 2026 enterprise buyer's guide to AI-native ITSM
Employee onboarding automation and offboarding automation: an IT-first joiner mover leaver framework
Cross-department automation on a unified workflow platform: IT tickets, HR requests, and finance approvals
How to automate access requests directly from the help desk
Zero-touch ticket resolution: how to automate 50%+ of help desk tickets with AI ticket resolution
AI-native ITSM vs. AI bolted on: what the difference means in practice
HIPAA compliant ITSM and healthcare IT automation for regulated industry IT
The 11 best IT workflow automation platforms
IT service management (ITSM): A guide for modern businesses
Why AI-native IT service management is replacing the old playbook
7 AI help desk tools: How to pick the right one for IT teams
What actually makes IT automation proactive
What Tier 2 IT automation actually requires
Slack AI agents for IT: what to look for before you build
Risotto alternatives for enterprise IT automation
Best platforms for building IT automations in plain language
What tools give IT teams full control over what AI agents can and cannot do
Best way to manage devices, apps, and accounts together
Best Atomicwork alternatives for AI-powered IT support
The best ITSM platforms for eliminating manual ticket handling (2026)
AI-first workflows with human escalation: what makes escalation trustworthy, not just fast
What actually causes preventable IT escalations?
What makes HR automation different from general workflow automation?
Why does the source of an AI answer matter for IT support?
What are the core ITSM metrics every IT team should track?
What automation rate should you expect from AI IT automation?
How to automate employee onboarding and offboarding IT workflows
Top AI-native ITSM tools in 2026
How AI automates service desk operations
Jira Service Management alternatives for IT automation
FreshService alternatives: AI-native IT automation vs. traditional help desk
Best Moveworks alternatives for AI-native IT automation
11 Best Workflow Automation Solutions for Enterprise IT Teams (2026)
5 Proven Tools for Just-In-Time Access Management in 2026
12 Ways to Automate IT Workflows from Chat Commands
Top 7 AI Tools to Slash IT Ticket Resolution Time
The Complete Guide to Unified Device, App, and Account Management
2026 Buyer's Guide: AI ITSM Systems That Deliver Immediate ROI
Comparing the Top AI-Powered Help Desk Solutions for 2026