As of 13 August 2026, AI can collect staff availability.
Most people should do this themselves; the prompt is on this page.
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 manual spreadsheet or existing rota system is the alternative; no price is stated in the supplied tool data.
If this goes wrong: an availability entry is copied incorrectly or left ambiguous, and you catch it by checking the source reply before using the list.
What to actually do
Do it yourself
The route this page recommends
A chat interface, chat-fluent skill, and roughly 15 minutes until you can act on the result.
How to actually do it
- Open a spreadsheet with columns for staff name, date, available times, unavailable times, preferences, constraints, source reply and unresolved questions.
- Set the date range, response deadline and availability rules, such as whether staff should give exact times or only whole-day availability.
- Send staff a form or message asking for availability, planned leave and shift preferences, and tell them not to include unnecessary health or personal information.
- Paste the replies into the prompt in a chatbot, or export the form responses and paste the exported text into the prompt.
- Ask the model to return one row per person and to flag missing, contradictory or ambiguous answers instead of filling gaps.
- Compare every drafted row with the original message or form response, then contact the named staff members about each unresolved question.
- Save the checked table as the availability record and use it as an input to your separate rota planning process.
Prompt
Create a staff availability collection workflow for [TEAM OR WORKPLACE] covering [DATES OR DATE RANGE]. Ask for each person's available and unavailable times, preferred shifts, maximum or minimum hours if relevant, planned leave, and any constraints they choose to disclose. Do not ask for unnecessary health or personal information. Use this response format for each person: name, date, available times, unavailable times, preferences, constraints, source reply, and unresolved questions. If I paste staff replies below, extract them without guessing, preserve uncertainty, flag contradictions, and produce a table plus a short list of people who need clarification. Do not assign shifts or decide who should work. Staff replies: [PASTE REPLIES HERE]
Open it prefilled in ChatGPT or Claude, or copy it into Gemini, which takes no prefill link.
Use a tool built for this
Second choiceHand 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 a vague answer such as "usually evenings" meets your staffing rules.
- AI cannot obtain genuine consent or make staff respond by the deadline.
- AI cannot resolve a conflict between a manager's instruction and a staff member's stated availability.
- AI cannot guarantee that sensitive information has been collected or stored in a suitable workplace system.
- AI does not take responsibility for an incorrect availability record or the rota built from it.
Even on a YES, the friction has a name: judgement under ambiguity, consent and privacy 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 | 2 |
| Verification | 2 |
| Liability | 2 |
| Effort delta | 2 |
| Total | 10 / 10 |
The methodology and its thresholds are published in full.
FAQ
- Can ChatGPT collect staff availability?
- Yes. It can turn pasted messages or form responses into a structured availability table and flag missing or contradictory answers. You still need to send the questions, check the table against the original replies and follow up with staff.
- What is the best way to collect staff availability with AI?
- Use a consistent form or message first, then give the responses to AI with fixed fields and an instruction not to guess. Ask it to preserve each source reply and list every answer that needs clarification.
- Can AI ask my staff when they are available?
- AI can help draft the questions and, in a suitable workplace workflow, organise incoming replies. It cannot replace your decisions about who should be contacted, what information is necessary or how staff consent to the process.
- Can AI use staff availability to make a rota?
- It can help with a separate rota-planning task, but collecting availability alone does not establish coverage, skills, working-time limits or fairness. Check the availability record first, then apply your workplace rules and approve the rota yourself.
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.