TriggerEvery day at 07:00 AM UTC, check each sales rep's Google Calendar for an out-of-office event or a day with no free slot left.
02
Custom stepDecide Available or Away for today.
03Go
Google SheetsWrite it into that rep's existing row on the Google Sheets spreadsheet id and tab name you choose in setup, overwriting today's value instead of adding another row, so lead assignment only picks reps who can take a lead.
04
OutputFinish
How it runs
This is the brief Whenever builds from. Change any of it in plain words before you publish.
When
Every day at 07:00 AM UTC, check each sales rep's Google Calendar for an out-of-office event or a day with no free slot left.
Then
Decide Available or Away for today.
Write it into that rep's existing row on the Google Sheets spreadsheet id and tab name you choose in setup, overwriting today's value instead of adding another row, so lead assignment only picks reps who can take a lead.