Tell us about your class
💡 Students will see your course and project name on the evaluation form.
Set up your Google Apps Script
This is the engine that receives student ratings and saves them to a Google Sheet you own. Takes about 5 minutes.
1
Open Google Apps Script
Click the button below. Sign in with your school Google account.
👉 Open Google Apps Script
2
Create a new project
Click "+ New project" in the top left corner.
3
Paste the script code
Select all existing code (Ctrl+A), delete it, then paste the code from
google-apps-script.js included in your download package.4
Create a Google Sheet & get its ID
Go to sheets.google.com, create a blank sheet, name it anything. Copy the ID from the URL:
Your sheet URL:
docs.google.com/spreadsheets/d/1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgVE2upms/edit
In the script, replace line 1:
const SPREADSHEET_ID = "YOUR-ID-HERE";5
Return to Google Apps Script — Run setupSheets, then Deploy
Go back to script.google.com (you left it open in Step 2).
Select setupSheets from the function dropdown → click ▶ Run (authorize when asked).
Then deploy:
Select setupSheets from the function dropdown → click ▶ Run (authorize when asked).
Then deploy:
Deploy→
New deployment→
⚙️ Web app→
Execute as: Me+
Anyone→
Deploy
⚠️ Google will ask you to authorize — click Advanced → Go to project → Allow. This is normal and safe.
6
Publish your Sheet as CSV
In your Google Sheet:
File→
Share→
Publish to web→
Submissions→
CSV→
Publish
Copy the long URL it gives you — you'll need it in the next step.
Paste your two URLs
We'll test both connections before finishing. Both must show ✓ Connected to continue.
Google Apps Script URL
The /exec URL you got after deploying in Step 2.
Not tested yet
Google Sheet CSV URL
From File → Share → Publish to web → Submissions → CSV.
Not tested yet
🎉
You're All Set!
Your peer evaluation app is live. Bookmark your links below and share the student form with your class!
Your Links — Bookmark These!
First Day Checklist
1
Open the Teacher Dashboard & change your password
Default password is
eval2026 — change it in ⚙️ Settings tab.2
Paste your Script URL and CSV URL in ⚙️ Settings
This saves your connection so you never have to enter it again on this browser.
3
Create a Class Session for each period
Dashboard → 🗂 Class Sessions → + New Session → add project names → 🚀 Publish
4
Share the Class Day Form with students
Make a QR code at qr.io and put it on the projector. Students scan → enter code → rate!
✅ You're done! Students submit → results appear live on your dashboard.