6
Prompt 6 of 6
Student & Parent Feedback Form
What This Creates
A feedback form built via Google Apps Script that captures how your students and parents feel about your programme — surfacing testimonials, referral intent, and improvement ideas automatically every term.
Form Fields
1
How likely are you to tell your friends about us? (1–10 rating)2
One area of improvement3
What did we do well?4
What other support do you need?💡
Send this at the end of every term or programme
Anyone who scores 9 or 10 is your warmest testimonial candidate. The "other support" field regularly surfaces your next programme idea.
⚙️
How to run the Apps Script
Go to script.google.com → New Project → paste the script Claude gives you → click Run. The form is created instantly in your Google Drive. Need a walkthrough? See the Google Forms page ↗ for the tutorial video.
📋 Your Claude Prompt — Copy Everything Below
Please write a complete Google Apps Script that automatically creates a feedback form for parents and students currently in my tutoring or coaching programme.
The form should collect the following:
1. How likely are you to tell your friends about us? (linear scale 1–10, required)
Label 1 as "Not likely" and 10 as "Extremely likely"
2. One area where we could improve (paragraph, required)
3. What did we do well? (paragraph, required)
4. What other support do you need? (paragraph, optional)
5. Your name (short answer, optional — label it "Your name (optional)")
Script requirements:
- Create the entire form programmatically using Google Apps Script
- Set the form title to: "Share Your Feedback"
- Set the form description to: "Your feedback helps us improve. This takes less than 2 minutes and means a lot to us."
- Set the confirmation message to: "Thank you so much — we really appreciate you taking the time!"
- Link the form to a new Google Sheet to collect responses automatically
- Name the Google Sheet: "Feedback"
After the script, please also give me:
1. Step-by-step instructions: how to open Google Apps Script, paste the code, and run it
2. How to view responses in the connected Google Sheet
3. A short, warm WhatsApp message I can send to parents asking them to fill in the feedback form (keep it friendly, not corporate)