Automation Recipe: From Observation Form to Feedback Draft Automatically

What This Builds

Instead of manually pasting observation notes into ChatGPT and copying the feedback into an email, this automation does it for you: you fill out your observation form on your phone during or after a classroom visit → Zapier detects the new form submission → sends it to the ChatGPT API → generates a coaching feedback draft → emails it to you ready to edit and forward. Every observation triggers a feedback draft in your inbox within 2 minutes — no manual steps.

Prerequisites

• A Google Forms observation form you already use (or will create)
• A Zapier account — free tier ({{tool:Zapier.free_tier}}) allows 5 automations
• A ChatGPT API key — requires an OpenAI account with API access (different from a Plus subscription; pay-per-use, typically under $1/month for a coach's usage)
• Your school email address (Gmail or Google Workspace)
• Comfortable with ChatGPT for coaching feedback (Level 3)

The Concept

This is a three-piece assembly line: Form (captures your observation) → Zapier (detects new submission and connects the pieces) → ChatGPT API (generates the feedback draft) → Gmail (delivers it to your inbox). You set it up once, and then every form submission triggers the whole chain automatically.

Think of Zapier as the "glue" between apps. It watches your Google Form for new responses — and when one arrives, it runs a series of steps you've configured: pull the form data, format a prompt, send to ChatGPT, receive the response, compose an email, and send it to you.

Build It Step by Step

Part 1: Build Your Google Observation Form

1. Go to forms.google.com and click Blank form
2. Name it: "Classroom Observation Notes"
3. Add these fields (matching how you actually take notes):

   • Teacher Name (short answer)
   • Grade Level (dropdown: K, 1st, 2nd... 8th)
   • Subject Area (short answer)
   • Date of Observation (date)
   • Observation Notes (paragraph — this is where you type or speak your notes)
   • Coaching Focus (short answer — optional: what specific goal you're working on with this teacher)
4. Click Settings → turn off "Collect email addresses" (you'll get the data via Zapier, not Google's email summary)
5. Click the Share icon → copy the link and save it somewhere easy to access from your phone

What you should see: A clean form you can access from mobile. Test it by submitting one fake response.

Part 2: Create a Zapier Account and Connect Google Forms

1. Go to zapier.com and create a free account
2. Click Create Zap (a "Zap" is one automation recipe)
3. Step 1 — Trigger: Search for Google Forms → select New Response in Spreadsheet

   • Connect your Google account when prompted
   • Select the observation form you just created
   • Select the response spreadsheet (Google Forms auto-creates one in your Drive)
4. Click Test trigger to verify Zapier can see your form submissions

What you should see: Zapier shows your test form submission data, confirming the connection works.

Part 3: Add the ChatGPT API Step

1. In your Zap, click Add Action
2. Search for OpenAI (ChatGPT) in the Zapier app search
3. Select Send Chat Message or Create Completion as the action
4. Connect your OpenAI API key:

   • Go to platform.openai.com → API Keys → Create new key
   • Copy the key and paste it into Zapier's connection setup
5. In the Message field, build your coaching prompt using Zapier's variable system (click "+" to insert form data):

You are an instructional coaching assistant. Write a 2-paragraph coaching feedback summary for a classroom observation.

Teacher: [insert Teacher Name from form]
Grade Level: [insert Grade Level from form]
Subject: [insert Subject Area from form]
Coaching Focus (if any): [insert Coaching Focus from form]
Observation Notes: [insert Observation Notes from form]

Format:
- Paragraph 1: A specific strength observed, with a concrete detail from the notes
- Paragraph 2: One growth area and one specific next step the teacher can try in their next lesson

Tone: warm, collaborative, non-evaluative coaching voice. Do not use the word "however."

1. Set the Model to gpt-4o-mini (cheaper and fast enough for this task; change to gpt-4o if you want higher quality)

What you should see: A test output showing a coaching feedback draft based on your sample form submission.

Part 4: Add the Gmail Send Step

1. Add another action step to your Zap
2. Search for Gmail → select Send Email
3. Connect your Google account
4. Configure:

   • To: your school email address
   • Subject: Coaching Feedback Draft — [Teacher Name] [Date] (use Zapier variables)
   • Body: paste in [ChatGPT output from previous step] → followed by a divider → followed by the original observation notes (for reference)
5. Click Test action — check your inbox for the draft email

What you should see: An email in your inbox with "Coaching Feedback Draft — [Teacher Name]" as the subject, containing the AI-generated feedback and your original notes below it.

Part 5: Activate and Test the Full Automation

1. Click Turn Zap on (toggle at the top of the Zap editor)
2. Submit a real observation through your Google Form on your phone
3. Within 1-3 minutes, check your inbox — the feedback draft email should arrive automatically
4. Read the draft, make any needed edits, then forward it to the teacher or paste into your coaching documentation system

What you should see: The complete feedback email arrives in your inbox automatically after every form submission.

Real Example: Full Workflow in Action

Setup: Your Zap has been running for 3 weeks.

During observation: You open your Google Form link on your phone. During the debrief walk between classrooms, you type your notes into the Observation Notes field and hit Submit — takes 3 minutes.

2 minutes later: An email arrives in your inbox:

What you do next: Read the draft in Gmail, edit 2 sentences to add your voice, and forward it directly to the teacher. Total time from observation to feedback sent: under 10 minutes.

Time saved per observation: 25-35 minutes. At 4 observations per week over 38 weeks: 63-88 hours per year.

What to Do When It Breaks

• Form submission doesn't trigger the Zap → Check that the Zap is turned on and that you're submitting the form (not just opening it). Zapier may take up to 15 minutes on the free tier.
• ChatGPT output is generic → Your prompt may not be pulling the observation notes correctly — check that the form field variable is mapping to the right field in Zapier
• OpenAI API error → Check your OpenAI account billing settings — the API requires a payment method on file even for minimal usage
• Email doesn't arrive → Check Gmail's spam folder; also verify the Gmail connection in Zapier is still authorized

Variations

• Simpler version: Skip the API step entirely — use Zapier to email you your observation form data formatted as a prompt, then paste it manually into ChatGPT. Saves setup complexity, just requires one manual step.
• Extended version: Add a fourth step where Zapier also logs the observation in a Google Sheet (teacher name, date, coaching focus) so you have a running coaching log without any additional manual entry.
• Alternate routing: Instead of emailing yourself, have Zapier add the feedback draft directly to a Google Doc in a folder per teacher — your documentation writes itself.

What to Do Next

• This week: Build the Google Form and submit 3-5 test observations to get the automation working correctly
• This month: Refine your ChatGPT prompt based on the first 10-15 outputs — add specifics that improve quality
• Advanced: Add a second Zap that triggers a calendar reminder to send the actual feedback to the teacher 24 hours after each observation — so the draft sits in your inbox for review, then you're reminded to send it

Advanced guide for instructional coach professionals. These techniques use more sophisticated AI features that may require paid subscriptions.