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.

Easy Saves ~2 hours/month Education & TrainingBy Flowngn team

Works with n8n · Make · Zapier

How it works

Trigger: Google Sheets — new quiz response
  1. Link your quiz to a Google Sheet (Responses › Link to Sheets).
  2. When a new response row appears, read the email and score.
  3. Send the student a short email with their score and your notes link.

Diagram

GNew quiz responseGoogle Sheets TriggerGEmail the scoreGmail
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.

Workflow JSON
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": []
}

Open in the playground to edit →

Tips

  • Turn on "Collect email addresses" in the form settings.

Related flows