Gaps were hidden in the sheet
Tomorrow's rows could still have empty staff columns, but the team had to manually scan for them.
ClientShiftwise Staffing
Shiftwise Staffing ran part-time teams without the nightly spreadsheet chase.
The pain point
A missing shift should not require another round of manual checking.
The team kept the roster in Google Sheets, but the operational work still depended on someone checking tomorrow's date, spotting empty staff slots, reading nearby availability rows, and turning that into a follow-up message.
Availability needed context
Finding one open date was not enough. The scheduler needed the nearby availability pattern before asking staff.
Summary work repeated
Each check had to become a readable note before a manager or another automation could act on it.
The Flow2 solution
Turn the roster sheet into a daily gap-finder.
Flow2 structured the Make.com blueprint as a reusable subscenario. It filters tomorrow's roster rows, checks whether key staff slots are still empty, pulls the relevant availability range, aggregates the candidate names, and returns one clean text output to the parent workflow.
Find tomorrow's open shifts
The scenario filters for the next roster date and only keeps rows where the staff assignment columns are still blank.
Pull the nearby schedule window
The workflow reads the matching row plus the next few rows so the team can see availability context.
Send back one clean summary
The output is a compact text block that can feed a notification, AI message draft, or manager review step.
The workflow checks the roster, reads availability, then returns a staffing summary.
This is a business-readable view of the blueprint. Sensitive spreadsheet IDs and account details are intentionally excluded from the case study.
Hover or focus a node to see how the part-time staffing automation works.
What the automation checks
The blueprint is small, but the decision rule is specific.
This workflow is useful because it does not try to automate the whole staffing operation at once. It automates one repeatable check: which upcoming roster rows still need people, and who may be available for those dates.
Date match
The filter looks for the next calendar date in the roster sheet.
Empty slots
Rows only matter when the main staff assignment fields have not been filled.
Sheet window
The scenario reads the matching row plus nearby rows for availability context.
Readable output
The result is returned as a short staff availability summary, not raw spreadsheet data.
The outcome
A small automation gives the team a cleaner daily handoff.
The final asset is not a full workforce management system. It is a practical scheduling assistant that removes a repeated spreadsheet check and prepares the information needed for the next follow-up step.
Less manual scanning
The team no longer needs to hunt through the roster sheet just to find tomorrow's unfilled shifts.
Better follow-up context
Availability data is pulled together before the scheduler contacts part-time staff.
Reusable subscenario
The output can feed a WhatsApp reminder, email alert, AI draft, or manager approval workflow later.