Send a weekly hiring pipeline report
Candidates per stage for each open job, new applicants, offers and stuck candidates, in one table.
- On a schedule: Every Monday at 8:30
What it does
The task
Open the pipeline of each open job in Greenhouse. For each job, count the candidates in each stage, the new applicants in the last 7 days, the offers and the hires. Calculate the days since the job opened and the conversion from each stage to the next. List the candidates who are in one stage for more than days days. Add the numbers as a new week in the Google Sheet sheet url, and send me a summary of at most 200 words.
- It works in Greenhouse and Google Sheets, in the workspace you pick, and signs in with passwords from your Cuiar vault.
- As a routine it runs every Monday at 8:30 (cron
30 8 * * 1).
What you give it
| Blank | What to give | Example |
|---|---|---|
| days | Days in one stage after which a candidate is stuck | 7 |
| sheet url | The Google Sheet with your hiring history | https://docs.google.com/spreadsheets/d/1HiringPipeline |
What you get back
An example run with the example values above. Your run uses your own data.
Hiring on 2 Nov: 5 open jobs, 2 offers out, 1 hire
| Job | Days open | New | Screen | Interview | Final | Offer |
|---|---|---|---|---|---|---|
| Senior Backend Engineer | 41 | 18 | 6 | 3 | 1 | 1 |
| Product Designer | 27 | 34 | 5 | 2 | 0 | 0 |
| Support Lead | 63 | 4 | 1 | 0 | 0 | 0 |
| Account Executive | 15 | 52 | 9 | 4 | 1 | 1 |
| Data Engineer | 8 | 11 | 2 | 0 | 0 | 0 |
Stuck for more than 7 days: 6 candidates, 4 of them in the Product Designer screen
Hired: Sam Ito, Ops Coordinator, started 2 Nov
Run it in Cuiar
- 01
Open it
Click Use in Cuiar on this page. The side panel opens with the task in the composer.
- 02
Fill in 2 blanks
Type days and sheet url. Tab moves to the next blank.
- 03
Run it, then repeat it
Run sends it once. To run it every Monday at 8:30, make a routine on cuiar.com/routines or with the CLI below.
As a routine, from the terminal
cuiar routines create "Send a weekly hiring pipeline report" --schedule "30 8 * * 1" --time-zone Europe/Berlin \
"Open the pipeline of each open job in Greenhouse. For each job, count the candidates in each stage, the new applicants in the last 7 days, the offers and the hires. Calculate the days since the job opened and the conversion from each stage to the next. List the candidates who are in one stage for more than 7 days. Add the numbers as a new week in the Google Sheet https://docs.google.com/spreadsheets/d/1HiringPipeline, and send me a summary of at most 200 words."Run it from your AI agent
Claude Code, Codex, Cursor and other MCP clients reach Cuiar at https://mcp.cuiar.com/mcp. Add the server one time, then ask for the task in plain words, or call create_routine yourself.
1. Add Cuiar to Claude Code
claude mcp add --transport http cuiar https://mcp.cuiar.com/mcp2. Ask your agent
Use the Cuiar tool create_routine to run my "Send a weekly hiring pipeline report" template with days = 7; sheet url = https://docs.google.com/spreadsheets/d/1HiringPipeline.Setup for other agents: AI agents.
The tool call
{
"name": "create_routine",
"arguments": {
"name": "Send a weekly hiring pipeline report",
"task": "Open the pipeline of each open job in Greenhouse. For each job, count the candidates in each stage, the new applicants in the last 7 days, the offers and the hires. Calculate the days since the job opened and the conversion from each stage to the next. List the candidates who are in one stage for more than 7 days. Add the numbers as a new week in the Google Sheet https://docs.google.com/spreadsheets/d/1HiringPipeline, and send me a summary of at most 200 words.",
"schedule": "30 8 * * 1",
"time_zone": "Europe/Berlin"
}
}Related templates
All recruiting templatesRecruitingAsks first
Write a job post and publish it on job boards
A clear post with the pay, duties and must-haves, created in your ATS and published after you approve it.
You start it: When you start it- Greenhouse
- LLinkedIn
- Indeed
Recruiting
Brief interviewers before each interview
A one-page brief from the candidate's resume and work samples, with the focus for this round.
On an event: Two hours before each interview in your calendar- Google Calendar
- Greenhouse
- GitHub
- +1 more: Google Docs
Recruiting
Summarize interview feedback for a hiring decision
All scorecards for one candidate on one page: ratings, evidence for and against, and open questions.
You start it: When you start it- Greenhouse
- Google Docs
Sales
Send a weekly sales pipeline report
New, moved, won and lost deals, and the forecast against quota, every Friday afternoon.
On a schedule: Every Friday at 16:00- HubSpot
- Google Sheets
Marketing
Get a weekly report on your Meta ads
Spend, cost per result and return for each campaign, the tired ads, and 2 tests for next week.
On a schedule: Every Monday at 8:00- Meta Ads Manager
- Google Sheets
MarketingAsks first
Schedule a week of posts from your sheet
Each approved post from your content sheet set up in its site's scheduler, after your OK.
On a schedule: Every Friday at 14:00- Google Sheets
- LLinkedIn
- +1 more: Instagram