Track Student Attendance with Mobile App, Google Sheets, and Email Alerts

The workflow JSON

Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →

{
  "id": "a8uJNRiJqvwakhCu",
  "meta": {
    "templateCredsSetupCompleted": true
  },
  "name": "No-Code Student Attendance Tracker with Mobile App Integration",
  "tags": [],
  "nodes": [
    {
      "id": "fc6e8424-031c-4a4e-b564-c8eabf3c2da2",
      "name": "Student Check-in",
      "type": "n8n-nodes-base.webhook",
      "position": [
        -620,
        -180
      ],
      "parameters": {
        "path": "student-checkin",
        "options": {},
        "httpMethod": "POST",
        "responseMode": "responseNode"
      },
      "typeVersion": 1
    },
    {
      "id": "01dd529b-05c7-4376-8fcc-5e0ed7865e1c",
      "name": "Format Data",
      "type": "n8n-nodes-base.set",
      "position": [
        -400,
        -180
      ],
      "parameters": {
        "values": {
          "string": [
            {
              "name": "student_name",
              "value": "={{ $json.body.student_name }}"
            },
            {
              "name": "student_id",
              "value": "={{ $json.body.student_id }}"
            },
            {
              "name": "class_name",
              "value": "={{ $json.body.class_name }}"
            },
            {
              "name": "date",
              "value": "={{ $now.format('yyyy-MM-dd') }}"
            },
            {
              "name": "time",
              "value": "={{ $now.format('HH:mm') }}"
            },
            {
              "name": "status",
              "value": "present"
            }
          ]
        },
        "options": {}
      },
      "typeVersion": 1
    },
    {
      "id": "1860ea4e-c141-4845-b703-d2e2530d8690",
      "name": "Email Teacher",
      "type": "n8n-nodes-base.emailSend",
      "position": [
        40,
        -180
      ],
      "parameters": {
        "text": "Please check attendance sheet",
        "options": {},
        "subject": "Student Check-in Alert",
        "toEmail": "user@example.com",
        "fromEmail": "user@example.com"
      },
      "credentials": {
        "smtp": {
          "name": "<your credential>"
        }
      },
      "typeVersion": 2
    },
    {
      "id": "f431b734-e704-4142-b22d-3a5ee91ef305",
      "name": "Success Response",
      "type": "n8n-nodes-base.respondToWebhook",
      "position": [
        260,
        -180
      ],
      "parameters": {
        "options": {},
        "respondWith": "json",
        "responseBody": "={\n  \"success\": true,\n  \"message\": \"{{ $('Format Data').item.json.student_name }} checked in successfully\",\n  \"time\": \"{{ $('Format Data').item.json.time }}\"\n}"
      },
      "typeVersion": 1
    },
    {
      "id": "5d4f05fa-a580-4fc0-b715-3f2d63b529b3",
      "name": "Append or update row in sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -180,
        -180
      ],
      "parameters": {
        "columns": {
          "value": {},
          "schema": [],
          "mappingMode": "autoMapInputData",
          "matchingColumns": [],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "appendOrUpdate",
        "sheetName": {
          "__rl": true,
          "mode": "id",
          "value": "=mjuy6543edrfgh"
        },
        "documentId": {
          "__rl": true,
          "mode": "id",
          "value": "3456yujh"
        },
        "authentication": "serviceAccount"
      },
      "credentials": {
        "googleApi": {
          "name": "<your credential>"
        }
      },
      "typeVersion": 4.6
    },
    {
      "id": "abe207d1-a3ee-4209-bc80-3517f73b8fae",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -660,
        -340
      ],
      "parameters": {
        "color": 4,
        "width": 180,
        "height": 300,
        "content": "Triggered via POST request from mobile app or QR scanner\n"
      },
      "typeVersion": 1
    },
    {
      "id": "7b901d5f-78bd-4f45-9402-14d6fcf78cf8",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -220,
        -340
      ],
      "parameters": {
        "color": 6,
        "width": 180,
        "height": 300,
        "content": "Saves student check-in data into Google Sheets\n"
      },
      "typeVersion": 1
    },
    {
      "id": "745e0462-46eb-46b7-a63e-34ea860d8c07",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        0,
        -340
      ],
      "parameters": {
        "color": 3,
        "width": 180,
        "height": 300,
        "content": "Sends formatted check-in email to the class teacher\n"
      },
      "typeVersion": 1
    },
    {
      "id": "02d30801-5e9e-4a35-9d24-61975e94b71b",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        220,
        -340
      ],
      "parameters": {
        "color": 5,
        "width": 180,
        "height": 300,
        "content": "Returns a confirmation response to the mobile app or system\n\n"
      },
      "typeVersion": 1
    },
    {
      "id": "c6900d6a-06ad-4ab5-9991-58654a907016",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -440,
        -340
      ],
      "parameters": {
        "width": 180,
        "height": 300,
        "content": "Cleans and prepares incoming JSON into structured format\n"
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "dde13cc8-d7ec-4091-99bb-79474db5a8e9",
  "connections": {
    "Format Data": {
      "main": [
        [
          {
            "node": "Append or update row in sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Email Teacher": {
      "main": [
        [
          {
            "node": "Success Response",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Student Check-in": {
      "main": [
        [
          {
            "node": "Format Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Append or update row in sheet": {
      "main": [
        [
          {
            "node": "Email Teacher",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}

Credentials you'll need

Each integration node will prompt for credentials when you import. We strip credential IDs before publishing — you'll add your own.

• googleApi
• smtp

About this workflow

A lightweight no-code workflow that captures student check-in data via a mobile app or webhook, stores it in a Google Sheet, and instantly notifies the class teacher via email.

Source: https://n8n.io/workflows/7043/ — original creator credit. Request a take-down →

More Data & Sheets workflows → · Browse all categories →

Related workflows

Workflows that share integrations, category, or trigger type with this one. All free to copy and import.