8
n8n 中文网amn8n.com

无代码学生考勤跟踪器与移动应用集成

中级

这是一个Miscellaneous领域的自动化工作流，包含 10 个节点。主要使用 Set, Webhook, EmailSend, GoogleSheets, RespondToWebhook 等节点。 使用移动应用、Google Sheets和邮件提醒跟踪学生考勤

前置要求
  • •HTTP Webhook 端点（n8n 会自动生成）
  • •Google Sheets API 凭证

使用的节点 (10)

Set
Webhook
EmailSend
StickyNote
GoogleSheets
RespondToWebhook

分类

杂项
工作流预览
可视化展示节点连接关系，支持缩放和平移
React Flow
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
  "id": "a8uJNRiJqvwakhCu",
  "meta": {
    "instanceId": "dd69efaf8212c74ad206700d104739d3329588a6f3f8381a46a481f34c9cc281",
    "templateCredsSetupCompleted": true
  },
  "name": "无代码学生考勤跟踪器与移动应用集成",
  "tags": [],
  "nodes": [
    {
      "id": "fc6e8424-031c-4a4e-b564-c8eabf3c2da2",
      "name": "学生签到",
      "type": "n8n-nodes-base.webhook",
      "position": [
        -620,
        -180
      ],
      "webhookId": "cfea4cea-4fa3-4629-9e1a-6102b68e4cf5",
      "parameters": {
        "path": "student-checkin",
        "options": {},
        "httpMethod": "POST",
        "responseMode": "responseNode"
      },
      "typeVersion": 1
    },
    {
      "id": "01dd529b-05c7-4376-8fcc-5e0ed7865e1c",
      "name": "格式化数据",
      "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": "邮件通知教师",
      "type": "n8n-nodes-base.emailSend",
      "position": [
        40,
        -180
      ],
      "webhookId": "c0d9da5a-707b-4275-9bc3-5277df3e96ee",
      "parameters": {
        "text": "Please check attendance sheet",
        "options": {},
        "subject": "Student Check-in Alert",
        "toEmail": "teachers@google.com",
        "fromEmail": "admin@google.com"
      },
      "credentials": {
        "smtp": {
          "id": "G1kyF8cSWTZ4vouN",
          "name": "SMTP -test"
        }
      },
      "typeVersion": 2
    },
    {
      "id": "f431b734-e704-4142-b22d-3a5ee91ef305",
      "name": "**结果：** 整理好的商家电子邮件数据库，准备用于外联",
      "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": "在表格中追加或更新行",
      "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": {
          "id": "ScSS2KxGQULuPtdy",
          "name": "Google Sheets- test"
        }
      },
      "typeVersion": 4.6
    },
    {
      "id": "abe207d1-a3ee-4209-bc80-3517f73b8fae",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -660,
        -340
      ],
      "parameters": {
        "color": 4,
        "width": 180,
        "height": 300,
        "content": "通过移动应用或二维码扫描器的POST请求触发"
      },
      "typeVersion": 1
    },
    {
      "id": "7b901d5f-78bd-4f45-9402-14d6fcf78cf8",
      "name": "便签1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -220,
        -340
      ],
      "parameters": {
        "color": 6,
        "width": 180,
        "height": 300,
        "content": "将学生签到数据保存到Google Sheets"
      },
      "typeVersion": 1
    },
    {
      "id": "745e0462-46eb-46b7-a63e-34ea860d8c07",
      "name": "便签 2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        0,
        -340
      ],
      "parameters": {
        "color": 3,
        "width": 180,
        "height": 300,
        "content": "向班级教师发送格式化的签到邮件"
      },
      "typeVersion": 1
    },
    {
      "id": "02d30801-5e9e-4a35-9d24-61975e94b71b",
      "name": "便签 3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        220,
        -340
      ],
      "parameters": {
        "color": 5,
        "width": 180,
        "height": 300,
        "content": "向移动应用或系统返回确认响应"
      },
      "typeVersion": 1
    },
    {
      "id": "c6900d6a-06ad-4ab5-9991-58654a907016",
      "name": "便签 4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -440,
        -340
      ],
      "parameters": {
        "width": 180,
        "height": 300,
        "content": "清理并准备传入的JSON为结构化格式"
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "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
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流？

复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。

这个工作流适合什么场景？

中级 - 杂项

需要付费吗？

本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。

相关工作流推荐

通过iOS自动化的地理围栏学生活动跟踪器
使用iOS自动化、Google Sheets和邮件提醒跟踪学生到达情况
If
Set
Webhook
+4
15 节点Oneclick AI Squad
杂项
实时参会者参与度和反馈分析器
使用情绪分析、Google Sheets、Slack和邮件分析活动反馈
If
Set
Slack
+6
14 节点Oneclick AI Squad
市场调研
通过多平台爬取和邮件报告实现酒店价格自动比对
通过多平台爬取和邮件报告自动化酒店价格比较
If
Set
Code
+6
19 节点Oneclick AI Squad
市场调研
自动化航班价格比较
跨多个预订平台比较航班价格，并生成邮件报告
If
Ssh
Code
+4
19 节点Oneclick AI Squad
杂项
动态座位与场地布局规划器
使用Google表格创建动态座位与场地布局规划
Code
Webhook
Google Sheets
+2
18 节点Oneclick AI Squad
杂项
AI驱动的演讲者与场次推荐引擎
使用Claude AI和Google Sheets生成活动演讲者推荐
If
Code
Webhook
+5
20 节点Oneclick AI Squad
杂项
工作流信息
难度等级
中级
节点数量10
分类1
节点类型6
难度说明

适合有一定经验的用户，包含 6-15 个节点的中等复杂度工作流

作者
Oneclick AI Squad

Oneclick AI Squad

@oneclick-ai

The AI Squad Initiative is a pioneering effort to build, automate and scale AI-powered workflows using n8n.io. Our mission is to help individuals and businesses integrate AI agents seamlessly into their daily operations from automating tasks and enhancing productivity to creating innovative, intelligent solutions. We design modular, reusable AI workflow templates that empower creators, developers and teams to supercharge their automation with minimal effort and maximum impact.

外部链接
在 n8n.io 查看 →

分享此工作流