Automated Copy/Paste Flow with Copilot
If you work in a school, chances are you spend far too much time on repetitive admin: copying parent survey responses, collating trip permission details, tracking CPD feedback, or reformatting student check-ins from Microsoft Forms into emails and spreadsheets.
It is tedious, time-consuming work that pulls focus away from where it matters most: the classroom and your colleagues.
In this practical, step-by-step video guide, we look at how to connect Microsoft Forms directly to Copilot to handle that legwork for you. You don’t need any coding knowledge or technical background to follow along. We take things at a calm, manageable pace and build the whole process together from scratch.
Throughout the guide, we stick to a simple guiding rule: Logic over luck. Rather than hoping an AI tool guesses what you want, we will:
- Set up simple, structured forms that collect clean, useful information from the start.
- Give Copilot clear, straightforward instructions so its summaries and drafts are reliable and consistent every single time.
- Keep you firmly in the driving seat (Human-in-the-Loop), ensuring every piece of output is checked, verified, and safe before it goes anywhere.
More AI Inspiration from Stephen:
Gemini Gems to Skills Migration Guide
Google has announced that Gemini Gems are transitioning to modular Skills across Workspace and Education domains. In this briefing, Stephen Wiles breaks down the official transition deadlines, demystifies the SKILL.md folder packaging protocol, and explains how to update your Google Workspace Studio flows without losing a single line of pedagogical work.
The Adaptive Classroom Engine
Stop spending your evenings manually reading and sorting qualitative submissions[cite: 2, 5]. Discover how to build an Asynchronous Diagnostic Engine using Google Workspace Studio, custom Gemini Gems, and the Extract tool to triage raw feedback, from student exit slips to staff CPD, into visual dashboards and targeted support briefings automatically.
Start the Flow
Moving data manually between intake forms, spreadsheets, and email inboxes isn’t system design—it’s administrative friction. Discover how to build a domain-safe, event-driven automation workflow that triages inquiries, updates your master database, and drafts human-in-the-loop responses in under three seconds.
Single Source Truth
Stop chasing lost emails and repeating basic policy rules. Learn how to use Gemini Notebook to build a secure, centralised “Institutional Knowledge Base” and create a clear Matrix of Responsibility for your entire school community.
The Academic Bridge
Stop drowning parents in “Teacher-speak.” Discover how to safely use NotebookLM as a pedagogical architecture tool to turn dense, complex departmental handbooks into clear, actionable study guides and audio briefings for your school community.
The Policy Translator
Schools are in the business of policy, but those 10-page “legalese” PDFs are often a barrier to parent engagement. In this video, I demonstrate The Policy Translator, a source-grounded workflow using NotebookLM that transforms dry, statutory documents into warm, parent-friendly FAQs in seconds. Stop being a ‘Policy Publisher’ and start being a ‘Policy Communicator’. Discover how to turn your static Staff or Parent Handbooks into a dynamic conversation while keeping a strict ‘Human-in-the-Loop’ on your school’s unique voice and professional standards.
The Gap Finder Protocol
Stop assuming your strategy is complete. Discover the ‘Gap Finder Protocol’—a professional interrogation workflow using NotebookLM to cross-reference your SIP. Learn to ‘Red Team’ your school on a Tuesday afternoon to find hidden risks before the auditors arrive on Wednesday morning. Don’t just be informed; be prepared.
Steerable Audio Protocol
Stop letting statutory updates steal your Sundays. Most school leaders treat the NotebookLM Audio Overview as a generic podcast; the ‘Steerable Audio Protocol’ turns it into a bespoke executive briefing. Reclaim your morning commute and learn how to ‘read’ a 50-page DfE update in just 10 minutes.
Institutional Intelligence Hub
Information in schools is often “liquid”; it flows through emails, PDFs, and spreadsheets, but rarely settles where we need it most. As school leaders, we don’t need more data – we need synthesis.