Workbranch › Guides
GuideHow to make a work schedule with ChatGPT
Building a weekly rota by hand means juggling availability, contracted hours and cover for every shift. ChatGPT can produce a first draft in a minute, but it will happily break a rule you forgot to mention. This guide gives you the inputs to collect, a prompt that returns a usable table, how to get it into a spreadsheet, and what you must check yourself.
Quick answer: give ChatGPT a list of staff with their contracted hours and availability, the shifts and how many people each needs, and your rules (maximum hours, rest between shifts, skills per shift). Ask for a table with one row per person and one column per day, plus a check that lists each person's total hours and any rule it couldn't meet. Copy the table into a spreadsheet, then check every shift against your contracts and local labour rules yourself.
ChatGPT features below were checked against OpenAI's help pages as of November 2026.
Step 1: Collect the inputs
OpenAI's prompting advice is to be clear, specific and give enough context. For a rota, that means writing down everything a good manager keeps in their head:
- Opening hours and shifts, with start and end times, such as Early 07:00–15:00 and Late 14:00–22:00.
- Cover per shift: the minimum number of people, and any skill required, such as one keyholder or one first aider on every shift.
- Staff: first name or initials, role, contracted or maximum weekly hours, and days or times they can't work. Leave out anything sensitive, such as reasons for absence.
- Rules: minimum rest between shifts, maximum consecutive days, breaks, rules for under-18s, and anything in your contracts. You decide these; the AI shouldn't.
- Preferences: fair weekend rotation, people who want more hours, pairs who shouldn't both be off.
If availability already lives in a spreadsheet, upload it instead of typing. ChatGPT reads XLSX, XLS and CSV files; OpenAI recommends headers in the first row, one record per row and no blank rows splitting the data. In the prompt area, select +, then Add photos & files.
Step 2: Run the rota prompt
"Create a staff rota for the week of [date] using only the information below. Shifts: [list]. Cover needed: [list]. Staff: [list]. Rules that must never be broken: [list]. Preferences, to meet where possible: [list]. Output a table with one row per person and one column per day, showing the shift code or OFF. Under it, add a second table with each person's total scheduled hours next to their contracted hours, and a third with each shift's headcount next to the minimum. Then list every rule or preference you couldn't meet and why. Don't invent staff, shifts or rules."
Why it's built this way:
- Separating rules from preferences tells ChatGPT what it may bend and what it may not.
- The hours and headcount tables make mistakes visible at a glance, instead of hidden in the grid.
- The list of unmet rules forces it to admit gaps rather than quietly break something.
Then refine: "Swap Sam's Saturday with someone who has hours left", or "Nobody should work Late followed by Early". OpenAI's guidance treats prompting as iterative, so change one thing per message and ask for the full table again.
To double-check the totals, ask: "Recalculate everyone's hours from the table using data analysis and show the calculation." When ChatGPT runs Python for this, OpenAI suggests reviewing the code and assumptions before relying on the result.
Step 3: Move it into a spreadsheet
The spreadsheet, not the chat, should be the version staff see.
- Copy the table from ChatGPT's answer and paste it into Google Sheets or Excel. Paste the hours check into a second tab.
- Add a formula for the totals in the sheet itself, so later manual swaps update the hours automatically instead of trusting the AI's numbers.
- Or let ChatGPT create the file. As of November 2026, ChatGPT Work can create spreadsheet files, and native Google Sheets when the Google Workspace app is connected; availability depends on your plan and workspace settings. Name the sheets, columns and formulas you want, and review the formulas before sharing.
With other assistants: Claude can create an Excel file to download when Code execution and file creation is on in Settings → Capabilities, and Gemini shows Export to Sheets at the bottom right of a table, which saves a new spreadsheet in Google Drive.
Step 4: Check it against labour rules yourself
OpenAI's help center says plainly that ChatGPT can be wrong while sounding sure, and recommends verifying important information from reliable sources. A rota is exactly that: an error can mean an unlawful shift or an unpaid overtime claim. Before publishing, check:
- Rest between shifts, especially a late finish followed by an early start.
- Weekly hours against each contract and any legal maximum or opt-out that applies to you.
- Breaks on long shifts, and stricter rules for young workers.
- Days off in a row and weekly rest days.
- Cover and skills on every shift, including holidays you didn't mention.
- Fairness: weekends and unpopular shifts spread the way you promised.
Use your country's official labour guidance, your contracts and any collective agreement as the reference, not the chat.
Good to know
- Reuse the setup. Select New project in the sidebar, add the staff list and rules as files, and put your fixed instructions in Project settings under the ••• menu. Project instructions apply only inside that project.
- Upload limits. Free accounts can upload 3 files a day; other plans can upload up to 80 files every 3 hours. Spreadsheets can be about 50 MB.
- Staff privacy. On personal Free, Plus and Pro accounts, chats can be used to train models while Improve the model for everyone is on (Settings → Data controls). OpenAI doesn't use content from business offerings such as ChatGPT Enterprise for training. First names or initials are enough for a rota.
If it doesn't work
- The hours don't add up. Ask for the recalculation with data analysis, and rely on your spreadsheet formula in the end.
- It breaks a rule after a change. Repeat the "never break" rules in your follow-up, or start a new chat with the corrected inputs.
- It says a rule can't be met. That's useful: you may need another person or a shorter shift. Ask for two options and their trade-offs.
- Your availability spreadsheet is misread. Remove merged cells and extra tables so there's one row per person.
Track the open items
A rota rarely ends with the table: there are swaps to confirm and gaps to fill. In Workbranch, answers come from Google Gemini and each point becomes a checklist item with progress, and you can flag the chat with a due date and a reminder for publishing next week's rota. There's a 3-day free trial. For a broader weekly routine, see how to plan your week with AI.
Sources
- Prompt engineering best practices for ChatGPT (OpenAI Help Center, checked 13 November 2026)
- Data analysis with ChatGPT (OpenAI Help Center, checked 13 November 2026)
- Uploading files and audio to ChatGPT (OpenAI Help Center, checked 13 November 2026)
- Creating and editing documents, spreadsheets, and presentations with ChatGPT Work (OpenAI Help Center, checked 13 November 2026)
- Does ChatGPT tell the truth? (OpenAI Help Center, checked 13 November 2026)
- Projects in ChatGPT (OpenAI Help Center, checked 13 November 2026)
- Data controls in ChatGPT (OpenAI Help Center, checked 13 November 2026)
- Create and edit files with Claude (Claude Help Center, checked 13 November 2026)
- Export responses from Gemini Apps (Gemini Apps Help, checked 13 November 2026)
Frequently asked questions
Does ChatGPT know the working-time laws in my country?
Don't rely on it. OpenAI's own help center warns that answers can be wrong while sounding confident, and rules on breaks, rest and young workers vary by country, sector and contract. Write the rules into the prompt yourself and check the result against official guidance or your HR adviser.
Can ChatGPT keep the rota up to date every week?
Not on its own. Keep the inputs and rules in a project, then each week paste the new availability and ask for next week's rota. The spreadsheet stays the version you publish to staff.
Can I use Claude or Gemini instead?
Yes, the same prompt works. Claude can create an Excel file you download from the chat, and Gemini has an Export to Sheets button below tables in its answers.