Email students their Google Forms quiz score
As soon as a student submits a Google Forms quiz, they get an email with their score and a link to review.
How it works
Trigger: Google Sheets — new quiz response
- Link your quiz to a Google Sheet (Responses › Link to Sheets).
- When a new response row appears, read the email and score.
- Send the student a short email with their score and your notes link.
Diagram
Trigger App
Build it
Pick your tool — same automation, step by step.
Copy and paste straight into an n8n canvas (Ctrl+V), or download and use Import from File. Then connect your own credentials and replace every YOUR_… placeholder.
Show code (91 lines)
{
"name": "Email students their Google Forms quiz score (Flowngn)",
"nodes": [
{
"parameters": {
"content": "## Email students their Google Forms quiz score\nAs soon as a student submits a Google Forms quiz, they get an email with their score and a link to review.\n\n**Setup**\n1. Open each node and connect your own credentials.\n2. Replace every YOUR_… placeholder.\n3. Test once, then activate.\n\nFree template from Flowngn",
"height": 260,
"width": 340
},
"id": "425c281e-b02f-4116-a065-ada79b4a5f74",
"name": "Setup notes",
"type": "n8n-nodes-base.stickyNote",
"typeVersion": 1,
"position": [
-420,
-60
]
},
{
"parameters": {
"pollTimes": {
"item": [
{
"mode": "everyMinute"
}
]
},
"documentId": {
"__rl": true,
"value": "YOUR_SPREADSHEET_ID",
"mode": "id"
},
"sheetName": {
"__rl": true,
"value": "Form Responses 1",
"mode": "name"
},
"event": "rowAdded",
"options": {}
},
"id": "425c281e-b02f-4116-a065-ada79b4a5f74",
"name": "New quiz response",
"type": "n8n-nodes-base.googleSheetsTrigger",
"typeVersion": 1,
"position": [
0,
0
]
},
{
"parameters": {
"sendTo": "={{ $json['Email Address'] }}",
"subject": "=Your quiz result: {{ $json.Score }}",
"emailType": "text",
"message": "=Hi {{ $json.Name || '' }},\n\nThanks for taking the quiz. Your score: {{ $json.Score }}.\n\nReview the lesson notes here: YOUR_NOTES_LINK\nQuestions? Just reply to this email.\n\nYOUR_NAME",
"options": {
"appendAttribution": false
}
},
"id": "425c281e-b02f-4116-a065-ada79b4a5f74",
"name": "Email the score",
"type": "n8n-nodes-base.gmail",
"typeVersion": 2.1,
"position": [
300,
0
]
}
],
"connections": {
"New quiz response": {
"main": [
[
{
"node": "Email the score",
"type": "main",
"index": 0
}
]
]
}
},
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"meta": {
"templateCredsSetupCompleted": false
},
"tags": []
}In Make, create a new scenario and add these modules in order:
- Google Sheets › Watch New Rows
- Gmail › Send an Email
- Every module run uses Make operations — the free plan includes a monthly quota.
- Module and step names can differ slightly as Make and Zapier update their apps.
In Zapier, create a new Zap and add these steps in order:
- Google Sheets — New Spreadsheet Row
- Gmail — Send Email
- Module and step names can differ slightly as Make and Zapier update their apps.
Tips
- Turn on "Collect email addresses" in the form settings.
Related flows
Education & TrainingEasy
Email certificates when a student finishes a course
Mark a student as completed in a sheet and they get a congratulations email with their certificate link.
Google Sheets → Gmail3h/mo
Education & TrainingEasy
Tell parents on WhatsApp when a student is absent
When a teacher marks a student absent in the attendance sheet, the parent gets a WhatsApp message right away.
Google Sheets → WhatsApp6h/mo
Education & TrainingEasy
Class reminders for tomorrow on WhatsApp
Every evening, remind students (or their parents) about tomorrow's class: course, time and place.
Google Sheets → WhatsApp5h/mo