Home · Business · Operations & Logistics · Scheduling & rotas

YES

As of 13 August 2026, AI can collect staff availability for a rota.

Most people should hand this to a purpose-built tool.

Can you do it?

5 minutesto a draft.

15 minutesto something you’d act on.

Cost, all in£0

Skill neededchat-fluent

Who has to check ityou

What the alternative costsA spreadsheet or rota manager can collect the same information; no price for that alternative is supplied here.

If this goes wrong: a missed restriction or incorrect availability leaves a shift understaffed or assigns someone when they cannot work.

What to actually do

  1. Use a tool built for this

    The route this page recommends

  2. Do it yourself

    Second choice

    A chat interface, chat-fluent skill, and roughly 15 minutes until you can act on the result.

    How to actually do it

    1. Open a chatbot and paste the prompt, replacing each bracketed slot with the rota period, staff group, shifts, response deadline and rules.
    2. Check the drafted message against your actual rota period, shift times, response deadline and workplace rules, then send it through the channel your staff normally use.
    3. Collect the replies in one document or spreadsheet, keeping each person's original response and the date received.
    4. Paste the responses into the chatbot without adding information that staff did not provide, and ask it to fill the table, mark missing answers and list conflicts or unclear wording.
    5. Compare every row in the generated table with the corresponding original response, correcting names, dates, shifts, restrictions and response status.
    6. Send targeted follow-up questions to staff whose answers are missing, ambiguous or conflicting, then update the table with their confirmed replies.
    7. Use the checked availability table as an input to the rota and keep the original responses with it for later queries.

    Prompt

    Help me collect staff availability for a work rota. The rota period is [START DATE] to [END DATE]. The staff group is [TEAM OR ROLE]. The shifts or working windows are [LIST SHIFTS, DAYS AND TIMES]. The response deadline is [DATE AND TIME]. The rules are [FOR EXAMPLE, MINIMUM NOTICE, MAXIMUM HOURS OR REQUIRED COVER].

Create:
1. A short message I can send to staff asking for availability.
2. A simple response format that asks for available, unavailable and preferred times for each relevant shift or working window.
3. A table layout for consolidating replies, with columns for staff member, date, shift, availability, restrictions, notes and response status.
4. A checklist of missing or unclear answers to follow up.

Use plain UK English. Do not invent staff names, dates, shifts, rules or availability. Do not infer availability from silence or from previous rotas. Ask staff to report changes and to share only the information needed for scheduling. Mark unanswered, conflicting or ambiguous responses for me to confirm. Keep each person's response separate from the consolidated table so I can check the table against the original replies.

    Open it prefilled in ChatGPT or Claude, or copy it into Gemini, which takes no prefill link.

  3. Hand it to a person

    The distant third

    A person who owns the outcome does this end to end, worth it when the failure is dear.

What it gets wrong

  • Cannot know whether a staff member has given truthful or complete availability.
  • Cannot obtain missing replies or resolve an ambiguous answer without contacting the person.
  • Cannot decide how to handle confidential staff circumstances or consent beyond the instructions you provide.
  • Cannot guarantee that a consolidated table preserves every date, restriction or qualification from the original responses.
  • Cannot take responsibility for understaffing or for assigning someone to a shift they cannot work.

Even on a YES, the friction has a name: consent and privacy and stakes of error.

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.

AxisScore (0–2)
Output2
Inputs2
Verification2
Liability1
Effort delta2
Total9 / 10

The methodology and its thresholds are published in full.

FAQ

Can ChatGPT collect staff availability?
Yes. It can draft the request, structure replies and consolidate them into a table, but you still need to send the request and check the table against the original responses.
What should I ask staff when collecting availability?
Ask for availability for each named date or shift, any restrictions or preferred times, and a clear response deadline. Do not treat silence as availability, and ask follow-up questions where an answer is unclear.
Can AI put staff availability into a spreadsheet?
Yes, if you provide the replies in a consistent format or paste them into the chat. Check every generated row against the original message because the model can misread dates, times or restrictions.
Is it safe to give AI staff availability?
Use only the information needed for scheduling and follow your workplace's privacy and access rules. Remove unnecessary personal details, keep the source replies secure and do not assume the tool has permission to share staff information.

Nearby answers

All Scheduling & rotas rulings

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.