As of 13 August 2026, AI can only partly build a shift schedule from staff availability.
Most people should hand this to a purpose-built tool.
Can you do it?
15 minutesto a draft.
30 minutesto something you’d act on.
Cost, all in£0
Skill neededchat-fluent
Who has to check ita colleague
What the alternative costsThe supplied tool data gives no price for a staff-rotas alternative.
If this goes wrong, a shift can be left uncovered, a worker can be scheduled when unavailable, or the manager can spend time repairing the rota.
What to actually do
Use a tool built for this
The route this page recommends
Do it yourself
Second choiceA chat interface, chat-fluent skill, and roughly 30 minutes until you can act on the result.
How to actually do it
- Open a blank spreadsheet and create separate sections for shift requirements, staff roles, availability, leave, limits and preferences.
- Gather the rota period, every shift time, required headcount, required roles and locations from the manager or current operating plan.
- Paste each worker's availability, role, leave, fixed commitments and any agreed limits into the relevant spreadsheet section.
- Copy the completed information into the prompt under the matching headings and paste it into a chatbot.
- Copy the drafted table into the spreadsheet and compare every assignment with the worker's availability, role, leave and stated limits.
- Ask the chatbot to list uncovered shifts and conflicts, then resolve each flagged item with the manager rather than accepting a guess.
- Send the checked rota to the responsible manager for approval before publishing it to staff.
Prompt
Build a staff shift schedule from the information below. Create a table with one row per shift and these columns: date, shift time, location, required role, assigned person and notes. Use only the information supplied. Do not invent availability, qualifications, preferences or staffing requirements. Do not assign anyone to a shift if they are unavailable or if their role does not match the requirement. First list any missing information, contradictions or uncovered shifts. If there is more than one valid option, choose the fairest option using the stated preferences and explain the choice briefly. If fairness criteria are not supplied, do not pretend to optimise fairness. Flag any rule that needs a manager's decision rather than guessing. After the table, provide three checks: shifts with no assigned person, people assigned outside their availability, and any person assigned more often than the stated limit. Keep the schedule easy to paste into a spreadsheet. Business and rota period: [business or team name and period] Opening hours or shift times: [details] Required coverage by shift and role: [details] Staff and roles: [name or staff ID, role, and any stated limits] Staff availability: [each person's available and unavailable times] Leave or fixed commitments: [details] Maximum or minimum shifts, rest requirements, or other rules: [details] Preferences and fairness rules: [details] Locations or other constraints: [details]
Open it prefilled in ChatGPT or Claude, or copy it into Gemini, which takes no prefill link.
Hand it to a person
The distant thirdA person who owns the outcome does this end to end, worth it when the failure is dear.
What it gets wrong
- AI cannot know whether an informal availability arrangement or manager preference is still current.
- It cannot decide how to resolve competing preferences or what counts as a fair allocation unless you define the rule.
- It cannot reliably understand operational context such as which combination of people works well together or who can handle an unexpected responsibility.
- It does not carry responsibility for an uncovered shift, an unsuitable assignment or a dispute about the rota.
- It cannot replace the manager's approval before the rota is published.
What caps this at PARTLY: judgement under ambiguity, stakes of error and context depth.
How we scored this
Five axes, each scored nought to two by hand: ten means AI carries the task cleanly, and the thresholds that turn a total into YES, PARTLY or NO are published in the methodology. Each axis name links to its definition.
| Axis | Score (0–2) |
|---|---|
| Output | 2 |
| Inputs | 1 |
| Verification | 1 |
| Liability | 1 |
| Effort delta | 2 |
| Total | 7 / 10 |
The methodology and its thresholds are published in full.
FAQ
- Can ChatGPT make a staff rota?
- Yes, it can produce a draft rota from availability, shift requirements and staffing rules. You still need to check every assignment and have the responsible manager approve it before publication.
- Can AI schedule shifts around staff availability?
- Partly. AI can match stated availability to shifts, but it cannot fill gaps in missing information or know whether an informal arrangement is still valid. Give it roles, leave, coverage needs and limits as well as availability.
- Is it safe to let AI create my work rota?
- Use it to create a draft, not as the final decision-maker. A wrong rota can leave a shift uncovered or assign someone to work outside their agreed availability, and the employer or manager remains responsible.
- What information does AI need to make a shift schedule?
- Provide the rota period, shift times, required coverage, staff roles, availability, leave, fixed commitments, limits, locations and any fairness rules. If you omit these, the model may produce a tidy table that does not work in practice.
Nearby answers
Assessed by gpt-5.6-luna (gpt-5.6-luna) on 2026-08-13, second-checked by an independent model. Wrong somewhere? Email [email protected] and it gets re-checked.
The newsletter
AI news, new answers and product picks, straight to your inbox.