Zapier Lead Router dynamic availability with Google Calendar
This Zap will run on a scheduled time every day and check sales reps' Google Calendar availability.
Workflow preview:
Overview
Employee availability shouldn’t break your routing — your system should adapt in real time
Most sales teams know that speed-to-lead and fair routing matter. But rep availability is often managed manually — in calendars, Slack statuses, spreadsheets, or not at all. Reps go out of office and still receive leads. Managers manually reassign or miss opportunities entirely. Routing logic stays static while real-world availability constantly changes.
This workflow turns availability into a dynamic, automated signal that directly controls how leads are distributed. It continuously checks each rep’s calendar (or any system you choose), uses AI to determine whether they’re active today, and updates their routing status automatically — globally or per queue. The result: no more sending leads into a black hole, and no manual toggling required.
Before this workflow
- Sales reps go out of office but continue receiving leads
- Managers manually toggle availability or forget to update it entirely
- Routing logic doesn’t reflect real-time rep availability
- Leads get assigned to inactive reps and sit untouched
- Teams waste time reassigning or recovering missed opportunities
After this workflow
- Every sales rep’s availability is checked automatically on a schedule
- Calendar events (like out-of-office) dynamically control routing eligibility
- AI determines whether each rep should be active or inactive today
- Rep status updates instantly — globally or at the queue level
- Inactive reps stay in queues but receive 0% of leads until they return
How it works
The system runs on a scheduled Zap that continuously evaluates rep availability and updates routing behavior in real time:
1. Scheduled availability check
On a daily schedule (or however often you choose), the Zap triggers and begins evaluating your team. This ensures availability is always up to date without any manual input.
2. Find and prepare sales reps
The Zap searches your sales rep system (like a Zapier Table) and pulls in all relevant reps. You can filter this list however you want — by team, region, or email domain. Results are returned as line items so each rep can be processed individually.
3. Loop through each rep
A looping step takes each rep’s ID and email and evaluates them one at a time. This allows the system to scale across any number of reps without added complexity.
4. Check calendar availability
For each rep, the Zap looks at their calendar (e.g., Google Calendar) and searches for out-of-office events. It identifies upcoming or current OOO blocks and returns structured availability data.
5. AI determines active vs inactive
An AI step analyzes the calendar output alongside today’s date. Instead of relying on brittle logic, it interprets whether the rep is actually availabletodayand returns a clear status: active or inactive.
6. Update rep status globally
Using the rep ID, the Zap updates their status in your system. If inactive, the rep remains in all routing queues but is effectively disabled — they receive no leads while preserving their weighting and structure.
7. Optional: update queue-specific availability
If you want more granular control, you can also update availability at the queue level. This allows a rep to stay active globally but be excluded from specific regions, teams, or workflows.
What’s included
- 1 Zap handling scheduled availability checks, rep lookup, looping, calendar evaluation, AI classification, and status updates
- 1 AI step determining real-time availability based on calendar context
- 1 Sales Rep data source like a Zapier Table to manage rep lifecycle and status
- Optional queue-level controlusing Update Queue Membership for granular routing logic
Who this is for
- RevOps and sales operations teams who want routing logic to reflect real-world rep availability automatically
- Sales leaders managing distributed teams where out-of-office time is frequent and hard to track manually
- GTM teams looking to improve speed-to-lead and eliminate missed opportunities due to inactive reps
- Zapier builders who want to extend routing logic with dynamic, AI-driven signals