Workbranch › Guides

Guide

How 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.

Updated 13 November 2026

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:

  1. Opening hours and shifts, with start and end times, such as Early 07:00–15:00 and Late 14:00–22:00.
  2. Cover per shift: the minimum number of people, and any skill required, such as one keyholder or one first aider on every shift.
  3. 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.
  4. 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.
  5. 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:

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.

  1. Copy the table from ChatGPT's answer and paste it into Google Sheets or Excel. Paste the hours check into a second tab.
  2. 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.
  3. 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:

Use your country's official labour guidance, your contracts and any collective agreement as the reference, not the chat.

Good to know

If it doesn't work

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

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.