Track Student Attendance with Mobile App, Google Sheets, and Email Alerts โ€” n8n ์›Œํฌํ”Œ๋กœ

๋‚ฎ์Œ ๋ณต์žก๋„๐Ÿ”— Webhook5๊ฐœ์˜ ๋…ธ๋“œ๐Ÿท๏ธ Miscellaneous์ž‘์„ฑ์ž: Oneclick AI Squad

๊ฐœ์š”

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.

๐ŸŽฏ What This Does

Students check in using a mobile app or QR code Their data is formatted and saved to a Google Sheet A notification email is sent to the class teacher in real time

๐Ÿ”ง Workflow Steps

| Step | Description | | -----------------------

์‚ฌ์šฉ๋œ ๋…ธ๋“œ

Send EmailGoogle Sheets

์›Œํฌํ”Œ๋กœ ๋ฏธ๋ฆฌ๋ณด๊ธฐ

Triggered via POST request from mobile app or
Saves student check-in data into Google Sheet
Sends formatted check-in email to the class t
Returns a confirmation response to the mobile
Cleans and prepares incoming JSON into struct
โšก
S
Student Check-in
F
Format Data
Email Teacher
โšก
S
Success Response
Append or update row in โ€ฆ
5 nodes4 edges

์ž‘๋™ ์›๋ฆฌ

  1. 1

    ํŠธ๋ฆฌ๊ฑฐ

    ์›Œํฌํ”Œ๋กœ๋Š” webhook ํŠธ๋ฆฌ๊ฑฐ๋กœ ์‹œ์ž‘ํ•ฉ๋‹ˆ๋‹ค.

  2. 2

    ์ฒ˜๋ฆฌ

    ๋ฐ์ดํ„ฐ๊ฐ€ 5๊ฐœ์˜ ๋…ธ๋“œ๋ฅผ ํ†ตํ•ด ํ๋ฆ…๋‹ˆ๋‹ค, connecting emailsend, googlesheets, respondtowebhook.

  3. 3

    ์ถœ๋ ฅ

    ์›Œํฌํ”Œ๋กœ๊ฐ€ ์ž๋™ํ™”๋ฅผ ์™„๋ฃŒํ•˜๊ณ  ๊ตฌ์„ฑ๋œ ๋Œ€์ƒ์— ๊ฒฐ๊ณผ๋ฅผ ์ „๋‹ฌํ•ฉ๋‹ˆ๋‹ค.

๋…ธ๋“œ ์„ธ๋ถ€ ์ •๋ณด (5)

SE

Send Email

emailSend

#1
GO

Google Sheets

googleSheets

#2

์ด ์›Œํฌํ”Œ๋กœ ๊ฐ€์ ธ์˜ค๋Š” ๋ฐฉ๋ฒ•

  1. 1์˜ค๋ฅธ์ชฝ์˜ JSON ๋‹ค์šด๋กœ๋“œ ๋ฒ„ํŠผ์„ ํด๋ฆญํ•˜์—ฌ ์›Œํฌํ”Œ๋กœ ํŒŒ์ผ์„ ์ €์žฅํ•ฉ๋‹ˆ๋‹ค.
  2. 2n8n ์ธ์Šคํ„ด์Šค๋ฅผ ์—ด๊ณ  ์›Œํฌํ”Œ๋กœ โ†’ ์ƒˆ๋กœ ๋งŒ๋“ค๊ธฐ โ†’ ํŒŒ์ผ์—์„œ ๊ฐ€์ ธ์˜ค๊ธฐ๋กœ ์ด๋™ํ•ฉ๋‹ˆ๋‹ค.
  3. 3๋‹ค์šด๋กœ๋“œ๋œ track-student-attendance-with-mobile-app-google-sheets-and-email-alerts ํŒŒ์ผ์„ ์„ ํƒํ•˜๊ณ  ๊ฐ€์ ธ์˜ค๊ธฐ๋ฅผ ํด๋ฆญํ•ฉ๋‹ˆ๋‹ค.
  4. 4๊ฐ ์„œ๋น„์Šค ๋…ธ๋“œ์— ๋Œ€ํ•œ ์ž๊ฒฉ ์ฆ๋ช…๏ผˆAPI ํ‚ค, OAuth ๋“ฑ๏ผ‰์„ ์„ค์ •ํ•ฉ๋‹ˆ๋‹ค.
  5. 5์›Œํฌํ”Œ๋กœ ํ…Œ์ŠคํŠธ๋ฅผ ํด๋ฆญํ•˜์—ฌ ๋ชจ๋“  ๊ฒƒ์ด ์ž‘๋™ํ•˜๋Š”์ง€ ํ™•์ธํ•œ ํ›„ ํ™œ์„ฑํ™”ํ•ฉ๋‹ˆ๋‹ค.

๋˜๋Š” n8n โ†’ JSON์—์„œ ๊ฐ€์ ธ์˜ค๊ธฐ์— ์ง์ ‘ ๋ถ™์—ฌ๋„ฃ๊ธฐ:

{ "name": "Track Student Attendance with Mobile App, Google Sheets, and Email Alerts", "nodes": [...], ...}

ํ†ตํ•ฉ

emailsendgooglesheetsrespondtowebhooksetwebhook

์ด ์›Œํฌํ”Œ๋กœ ๊ฐ€์ ธ์˜ค๊ธฐ

ํ•œ ๋ฒˆ์˜ ํด๋ฆญ์œผ๋กœ ๋‹ค์šด๋กœ๋“œ ๋ฐ ๊ฐ€์ ธ์˜ค๊ธฐ

JSON ๋‹ค์šด๋กœ๋“œn8n.io์—์„œ ๋ณด๊ธฐ
๋…ธ๋“œ5
๋ณต์žก๋„low
ํŠธ๋ฆฌ๊ฑฐwebhook
์นดํ…Œ๊ณ ๋ฆฌMiscellaneous

์ œ์ž‘์ž

Oneclick AI Squad

Oneclick AI Squad

@oneclick-ai

ํƒœ๊ทธ

emailsendgooglesheetsrespondtowebhooksetwebhook
โšก

n8n์„ ์ฒ˜์Œ ์‚ฌ์šฉํ•˜์‹œ๋‚˜์š”?

n8n์€ ๋ฌด๋ฃŒ ์˜คํ”ˆ์†Œ์Šค ์›Œํฌํ”Œ๋กœ ์ž๋™ํ™” ๋„๊ตฌ์ž…๋‹ˆ๋‹ค. ์ž์ฒด ํ˜ธ์ŠคํŒ…ํ•˜๊ฑฐ๋‚˜ ํด๋ผ์šฐ๋“œ ๋ฒ„์ „์„ ์‚ฌ์šฉํ•˜์„ธ์š”.

n8n ๋ฌด๋ฃŒ๋กœ ์‹œ์ž‘ํ•˜๊ธฐ โ†’

Related Miscellaneous Workflows