Start with absence reporting, then standard parent letters, enquiry replies, trip paperwork and, last, a handbook-based parent FAQ chatbot. Four of the five can be built for $0 to $35 a month in tools and one to six hours of set-up each. The chatbot is the only one that needs real preparation, because it speaks for the school in public.
The order matters more than the tools. Jobs that repeat daily, use short structured answers and never touch safeguarding judgements pay back fastest. Jobs where a wrong sentence reaches every parent at once, such as a chatbot answering from an out-of-date handbook, need a person checking first. Every figure below is an illustration of a small school, not a quote.
The yardstick: minutes saved against risk carried
Picture a 220-pupil primary school with two people in the office. They do not have time to evaluate software, so the sensible test for each job has three questions. How many minutes does it eat in a typical week? What is the worst thing a wrong output could do? And can a person see the output before it leaves the building?
| Job | Office minutes a week (illustrative) | Worst case if wrong | Human check before it goes out |
|---|---|---|---|
| Absence reports | 150 to 250 | A missed unexplained absence | Register reconciliation each morning |
| Standard letters | 60 to 120 | A wrong date in a letter to every family | Office manager reads before sending |
| Enquiry replies | 45 to 90 | A promise about places or fees | Draft only, a person presses send |
| Trip paperwork | 90 to 180 per trip | Missing consent on the day | Return tracker checked the day before |
| Parent FAQ chatbot | 30 to 60 | A confident wrong answer, published | Test questions plus a weekly log review |
The minute figures are an example of how one imagined office might split its week, so replace them with a count from your own diary. Ask the office to tally interruptions for one week; the real numbers are often higher than anyone guessed and tell you where to begin.
1. Absence reporting: a form, a sheet and a reply
Absence reporting is the strongest first job because the information is tiny and always the same: pupil name, class, date, reason, who is reporting. The cheapest build skips voice AI altogether. A parent opens a short web form from a link on the website or a text message, and the answer lands in a spreadsheet that the office checks against the register before the morning deadline.
Tools. Google Forms (free) feeds a Google Sheet. An automation step in Zapier or Make then sends an acknowledgement text and flags any reason containing a keyword such as "hospital" or "contagious" for a person to read. Zapier's Free plan allows 100 tasks a month and only two-step Zaps, which is not enough for a school with 14 reports a day. Its Professional plan is listed at $19.99 a month billed annually ($29.99 monthly) for 750 tasks. Make's Free plan lists 1,000 credits a month, but Make bills each module action in credits and some AI steps use more than one, so test your real flow before trusting that allowance.
Set-up time. About three to four hours the first time: write the form, build the sheet with a "checked against register" column, connect the text message, and write the one-page fallback.
Monthly cost. $0 to $30 for the tools, plus the text-message provider's per-message charge. Texts longer than 160 characters are split and billed per segment, and a single curly apostrophe or emoji can cut a segment to 70 characters, so keep the acknowledgement short and typed with straight quotes.
An acknowledgement that works within one segment:
Thanks, we have your absence report for [first name] on [date]. If anything changes, reply to this message or call the office.Where does AI come in at all? One place, and it is modest: a step that reads the free-text reason and sorts it into "illness", "appointment", "family" or "unclear", so the office reviews the unclear ones first. If you would rather let parents ring and talk, the costs and call rules for that are in the tutorial on an AI answering service for a school office.
Watch-out. A form is only as good as the register check behind it. A flow that texts "thanks" to a parent does not tell you the child is safe. Keep the morning reconciliation as a human job and treat the automation as the tidy inbox, not the safeguard.
The Complete Excel Course with AI Integration
From formulas and pivot tables to Power Query, DAX, VBA and AI with Copilot, ChatGPT and Claude — hands-on from the first lesson.
By Sagnik Bhattacharya and Virginia Thorn, Primetime Emmy Award winner
Buy now2. Standard letters: one bank of approved wording
Most of what the office sends home is a variation on about a dozen letters: non-uniform day, parents' evening booking, a case of head lice, a closure notice, an end-of-term reminder. The automation here is a letter bank plus a chat assistant that fills in the gaps, followed by a mail-merge from the family spreadsheet.
Tools. A paid chat assistant seat if the office has one (ChatGPT Plus and Claude Pro are $20 a month each on monthly billing; the business versions, ChatGPT Business and Claude Team, list a standard seat at $20 a month billed annually or $25 monthly, and keep your content out of model training by default). The cheaper route is Gemini inside Google Docs and Gmail, which is included on Google Workspace Business plans from Starter (about $7 per user a month on annual billing) with Docs access from Standard (about $14). School accounts are priced differently, so check your own; the tutorial on whether Gemini is free for schools covers it.
Set-up time. Two hours to collect last year's letters, strip every name and date, and save them as a "letter bank" document with a one-line instruction at the top.
Monthly cost. $0 to $25 per user.
A prompt that keeps the assistant inside the school's own voice:
You are drafting a letter for a primary school office. Use only the approved letters below as your model for tone, length and layout. Plain English, no exclamation marks, reading age about 11. Do not invent dates, fees, names or policies: where I have not given one, write [CHECK] in square brackets.
Task: a letter telling parents that Year 4 swimming moves from Tuesday to Thursday for the next three weeks. Pickup times are unchanged.
Approved letters:
[paste three or four from the letter bank]A realistic output keeps to four short paragraphs and ends with "Please contact the school office if the new day causes a problem." Look for two things before sending: any date the assistant filled in without your telling it, and any sentence that makes a promise the school has not made, such as "no extra cost". The [CHECK] markers exist to make the omission visible, and in practice they catch more errors than careful reading does.
Before and after. Before: the office manager opens last year's letter, changes four details, forgets one date and sends 220 families a letter naming the wrong week. After: the assistant drafts from the bank, [CHECK] flags the unconfirmed date, the manager fills it in and the merge sends individual emails with the pupil's name already in the subject line. A letter now takes ten minutes, and its blank spaces are visible.
3. Enquiry replies: drafts, not auto-sends
Admissions and general enquiries arrive by email and web form: do you have places in Reception, when are open mornings, what is the uniform policy. The questions repeat, the answers sit in the prospectus, and the danger is the reply that promises a place or a fee waiver.
Tools. The same assistant as above, with a saved set of instructions (a project or equivalent) holding the prospectus, term dates and the five standard replies. Gemini in Gmail can draft into the reply box on the plans mentioned earlier. Do not connect it to send automatically.
Set-up time. Two hours, most of it deciding what the assistant must never say.
Monthly cost. $0 to $25, usually covered by the seat already bought for letters.
Draft a reply to the enquiry below using only the attached prospectus and term dates.
Rules: never state whether a place is available, never quote a fee, never give a view on a particular child's needs. For those, say the head or admissions lead will reply within two working days. Sign off as "The School Office".
Enquiry:
[paste enquiry with the sender's name replaced by "the parent"]An illustrative output answers the open-morning and uniform questions in two short paragraphs, then writes: "For places in Reception, our admissions lead will reply within two working days." That is the right behaviour. If the draft ever says "we have spaces", the instruction needs tightening, and the person pressing send is the safety net that caught it.
Watch-out. Pasting a parent's email with a child's name and special-needs details into a consumer chat tool is the common mistake. Replace names with "the parent" and "the child" first, and never paste anything about health, behaviour or home circumstances. The wider mechanics of fast replies are in the tutorial on replying to every enquiry in under five minutes.
4. Trip paperwork: the tracker does the chasing
A school trip generates a letter, a consent form, a risk assessment, a payment list, a medical-needs list and a lot of chasing. The paperwork is where time goes, and the part worth automating is the chase, not the risk assessment.
Tools. A Google Form for consent and emergency contact, a sheet with one row per pupil and a "consent received" column, and an automation that emails a reminder to families still missing at day five and day two. The Free tier of Zapier cannot do multi-step reminders, so plan on Professional ($19.99 a month annual) or send the reminders yourself from a filtered list of the rows still missing consent, which costs nothing but ten minutes.
Set-up time. Three hours for the first trip, about 45 minutes for each after, because the form and tracker are copied.
Monthly cost. $0 to $20, and only in months with trips.
Where AI helps is the first draft of the letter and the risk-assessment skeleton. Give it the trip brief, not the pupil list:
Draft a parent letter for a Year 5 visit to a local farm on [date]. Departure 9:15, return 15:00, cost [CHECK], packed lunch, waterproofs and sturdy shoes. Include a consent deadline of [date]. Then list, as bullet points only, the ten hazards a teacher should consider on a farm visit, for me to review. Do not write the risk assessment itself.The hazard list is a prompt for the teacher's own thinking, not a substitute for it, and anything in the final risk assessment is the trip leader's responsibility. Medical needs, allergies and special arrangements stay in the school's management system. Do not put them in an AI tool.
A realistic mistake. A school automated reminders but built the tracker from a class list that was a week out of date. Two pupils who had joined recently never received the consent link and nobody noticed until the day before. The fix is a rule: the tracker row count must match the register count the afternoon before sending, and a person ticks it off.
5. The parent FAQ chatbot: last, and only from the handbook
A chatbot on the website answers the questions that otherwise become calls: what time do gates open, what is the lateness procedure, where do I find the term dates. It is the most visible automation on this list and the only one where a wrong answer is published to anyone who asks.
Tools and costs. The free allowances are small. Tidio gives the first 50 AI conversations free, with its Lyro AI agent listed from $32.50 a month billed yearly. Botpress's free plan shows 100 conversations, and its Plus plan is $150 a month billed annually for 250 conversations a month, with extra packs of 100 for $65. Chatbase has no free plan: Hobby is $32 a month billed yearly ($40 monthly) for 700 message credits. For a school with 220 pupils, the free allowances can be used up in a few busy days after a newsletter, so estimate the conversations before choosing.
Set-up time. Four to six hours, of which perhaps three are cleaning the handbook so that each policy has one clear, current version.
Monthly cost. $0 on a free allowance in quiet months, up to roughly $40 to $150 once traffic outgrows it.
The full step-by-step, including the test questions and the office hand-over, is in the tutorial on a school website chatbot built from the handbook. The principle is short: the handbook is the only source, no pupil data goes in, and every answer ends with a way to reach a person.
What the five cost together
Here is a combined, illustrative bill for the imagined 220-pupil school, using list prices at the time of writing and annual billing where stated. Treat it as a range and confirm current prices on each vendor's page.
| Job | Set-up hours | Tools monthly | Ongoing office time |
|---|---|---|---|
| Absence reporting | 3 to 4 | $0 to $30 | 10 minutes a day on the exceptions |
| Standard letters | 2 | $0 to $25 | 10 to 15 minutes a letter |
| Enquiry replies | 2 | $0 to $25 (same seat) | 3 to 5 minutes a reply |
| Trip paperwork | 3, then under 1 | $0 to $20 | 20 minutes a week before a trip |
| Parent FAQ chatbot | 4 to 6 | $0 to $40, more if busy | 20 minutes a week on the log |
Add it up and the build is 14 to 17 hours of office time across a term, and the tools come to somewhere between nothing and about $115 a month depending on which tiers you need. Because the letter and enquiry jobs share one assistant seat, the real figure for many schools is under $50. Set that against the first table: in the imagined school these five jobs take roughly 6 to 12 hours of office time in a week with a trip on, and only your own before-and-after count will show how much of that comes back. The useful number for governors is hours returned, not dollars saved.
Turning the minutes into a plan for a term
A sequence that keeps the office from taking on too much at once:
- Weeks 1 to 2. Build absence reporting. Run it alongside the existing phone line for two weeks, so nothing depends on it yet.
- Weeks 3 to 4. Create the letter bank and the enquiry instructions. Use them on real letters, with the [CHECK] habit.
- Weeks 5 to 6. Build the trip tracker, ideally for a trip already planned, so the first run is real.
- Weeks 7 to 10. Clean the handbook and launch the chatbot on a quiet page first. Read every conversation for the first fortnight.
- Weeks 11 to 12. Review hours, errors and complaints. Retire any flow that creates more work than it removes.
The tutorial on a one-term AI plan for a small school expands the same idea for a head, with governors and staff briefings included.
Where pupil data must stay out
A simple boundary makes this safe enough for a small office to run. Names and contact details may sit in the form, the sheet and the email system the school already uses. They do not go into chat prompts. Medical, behaviour, safeguarding and special-needs information goes into none of these tools. If a free AI tool asks you to accept terms for "education" use, find out who owns the data and how long it is kept before any child's information goes near it; the tutorial on free AI tools for schools shows what to look for. Your data-protection lead, and the governors, should see the list of tools and what each touches before it goes live.
A good test is to imagine a parent asking to see everything the school's AI tools hold about their child. If the honest answer is "nothing, it is all in the school's own systems", you have the design right.
How to tell it is working
Pick three numbers before launch and measure them again after six weeks. Count the phone calls about absence at 8:30 a.m. on a Monday. Time how long one standard letter takes from request to send. Count the questions the chatbot answered that previously reached the office. If a number has not moved, the job was probably the wrong one or the build is not being used, and either is useful to learn early.
Also keep a one-page "when it breaks" note: who owns each flow, where the failure email goes, how to run the job by hand. Automation tools do fail quietly, so a weekly two-minute look at the run history is cheap insurance. If you would rather map the five jobs with someone who has seen how these builds behave in practice, that is what my AI implementation consultation covers.
Questions school offices ask before automating
Can the office automate without putting pupil data into an AI tool?
Yes, and for most of these jobs it is the better design. Absence forms, trip consent and letters can run on forms, spreadsheets and templates, with AI used only on text that carries no names, medical details or safeguarding notes. Where a name has to travel, keep it in the form or sheet and let the AI see a placeholder.
Which of the five should a school automate first?
Start with the job that costs the office the most repeated minutes and carries the least risk. For most schools that is absence reporting, because the answers are short and structured. Parent letters come second. Leave the chatbot until the handbook has been cleaned, since it publishes your answers to the public.
Do we need a developer?
Not for any of these. Everything here uses forms, spreadsheets, a no-code automation tool and a chat assistant. The skill needed is closer to writing clear office procedures than to coding. A bursar or office manager who is comfortable with spreadsheets can build and run all five.
What happens when the automation breaks over a holiday?
Give every flow a named owner and a manual fallback written on one page. Most no-code tools email the account owner when a run fails, so use a shared office address that is checked daily rather than one person's inbox. Test the fallback at the start of each term.
Further reads
- AI Consultant for Schools: Role, Cost and How to Brief One — What an outside adviser costs if the office wants help building.
- When Should an AI Chatbot Hand Over to a Human? — When the chatbot should pass a parent to the office.
- How to Automate Holiday Requests and Absence Tracking — The staff-side version of absence tracking.
- Email Newsletter QA Checklist Before You Hit Send — A final check for letters and newsletters before sending.
- How to Write a Customer Newsletter With AI in 30 Minutes — Drafting a regular newsletter in about 30 minutes.
- AI Automation for Education: Five Workflows, Tools and Costs — The same question for tutors, nurseries and training firms.
- AI Training for School Staff: Session Plan, Tasks and Handout — A ready-to-run one-hour AI session for school staff, with timings, a live demo, data red lines, practice prompts and a handout.
- Can AI Draft a Headteacher Report to Governors From Your Data? — Turn anonymised attendance, progress and finance tables into a governors' report draft, with a figure-by-figure accuracy check before it goes out.
- Can AI Write School Attendance Letters? A Three-Stage Sequence — A three-stage attendance letter ladder written by AI with placeholders only, merged from the register by your office, and signed off by the head.
- School Trip Letter to Parents: The Whole Pack, Drafted by AI — One trip brief in, four documents out: parent letter, consent slip, medical form and kit list, with voluntary-contribution wording and a leader checklist.
- AI for Private Schools: Admissions, Fees and Parent Communication — An office-side map of the private school jobs AI can do, from enquiry follow-up and offer letters to fee reminders, and where a person must decide.
- AI Tools and AI Development: The Complete 2026 Guide — the AI hub, including every tutorial in the AI-for-business series.
Sources: Zapier, Make, Tidio, Botpress, Chatbase, ChatGPT, Claude and Google Workspace pricing and help pages; Twilio SMS segment documentation; Google Forms help pages.