Real-time registration form tracking with Google Sheets and Gmail notifications

Name: Real-time registration form tracking with Google Sheets and Gmail notifications
Availability: InStock
Author: Gracewell

Real-time registration form tracking with Google Sheets and Gmail notifications preview

Open on n8n.io

$20/month : Unlimited workflows

2500 executions/month

Try free

THE #1 IN WEB SCRAPING

Scrape any website without limits

Try free

HOSTINGER

Early Deal
DISCOUNT 20%

Self-hosted n8n

Unlimited workflows - from $4.99/mo

Try free

#1 hub for scraping, AI & automation

6000+ actors - $5 credits/mo

Try free

Important notice

This workflow is provided as-is. Please review and test before using in production.

Overview

Title: Gracewell Automated Registration Tracker Suite

version: 1.0 tags: [education, automation, google-sheets, gmail, dashboard, form-tracking, workflow-suite]

category: Academic Automation

Description:

Automate the real-time tracking of Google Form submissions using Google Sheets and n8n.
This 3-workflow suite includes a live dashboard with submission statistics and two companion workflows
To send acknowledgement and reminder emails to students — all seamlessly connected through n8n webhooks.

🚀 Gracewell Automated Registration Tracker Suite

A fully automated, real-time monitoring system for student form submissions — built with Google Sheets, Gmail, and n8n.
The suite provides a live dashboard, auto-generated summary analytics, and instant messaging (email or WhatsApp) capabilities.

🧩 Workflow Suite Overview

Workflow	Purpose	Webhook	Output
1️⃣ Live Dashboard	Displays summary of submissions and includes trigger buttons	`/live-tracking`	HTML Dashboard
2️⃣ Send Acknowledgements	Sends thank-you emails to completed respondents	`/send-acknowledgements`	HTML Confirmation Page
3️⃣ Send Reminders	Sends personalized reminders to pending students	`/send-reminders`	HTML Confirmation Page

🧠 Who Is This For

Educators managing student registration or feedback
Department coordinators tracking submission completion
EdTech and training institutions handling digital enrolments
Universities automating exam registration or attendance forms

⚙️ Problem It Solves

Manual form tracking is slow, repetitive, and prone to error.
This workflow suite provides: ✅ Automated reconciliation of student vs. response data
✅ Instant calculation of pending and completed submissions
✅ One-click acknowledgement and reminder dispatch
✅ Web-based dashboard with summary visualization

📊 Workflow 1: Live Tracking Dashboard

Steps

Google Sheets – Student List → Reads master student sheet
Google Sheets – Form Responses → Reads live form entries
Code Node → Compares Register Nos. and generates HTML dashboard
Respond to Webhook → Displays HTML with summary and control buttons

Output

A clean web dashboard showing:

Total, Submitted, Pending, Completion %
✅ Completed list and ⚠️ Pending list
Two buttons:
- Send Acknowledgements
- Send Reminders

💌 Workflow 2: Send Acknowledgements

Steps

Webhook Trigger → /send-acknowledgements
Google Sheets – Student List & Form Responses
Merge Node → Combines matching rows
Code Node → Generates personalized thank-you emails
Gmail Node → Sends messages
Respond Node → Displays confirmation message

Email Template

> Subject: ✅ Thank You for Your Submission
> Body:
> Dear {{name}},
> Thank you for completing your form (Reg No: {{reg}}).
> We appreciate your prompt response.
> – Gracewell

⚠️ Workflow 3: Send Reminders

Steps

Webhook Trigger → /send-reminders
Google Sheets – Student List & Form Responses
Merge Node → Aligns both data sets
Code Node → Identifies pending students
Gmail Node → Sends customized reminder
Respond Node → Confirms completion

Email Template

> Subject: ⚠️ Reminder: Please Complete Your Form
> Body:
> Dear {{name}},
> You haven’t yet completed your form (Reg No: {{reg}}).
> Please complete it at the earliest.
> – Gracewell

🛠️ Setup Instructions

Step 1 – Connect Accounts

Connect Google Sheets (OAuth2)
Connect Gmail for sending messages

Step 2 – Prepare Sheets

Student List Sheet:
Columns → Register No., Student Name, Contact, Email
Form Response Sheet:
Columns → Timestamp, Reg No, Email Address

Step 3 – Deploy URLs

Workflow	Webhook Endpoint
Dashboard	`/live-tracking`
Acknowledgements	`/send-acknowledgements`
Reminders	`/send-reminders`

🎨 Optional Customizations

Add institution name/logo to dashboard HTML
Include charts (Chart.js) for submission visualization
Auto-refresh every 60 seconds
Integrate WhatsApp messaging via Twilio or Gupshup
Log emails into a “Mail Logs” sheet

🧩 Version Summary

Workflow	Version	Description
Live Dashboard	v3	Interactive HTML dashboard with controls
Send Acknowledgements	v1	Personalized thank-you email sender
Send Reminders	v1	Automated reminder email sender

Need help customizing?

✉️ Contact Me 💼 LinkedIn

✨ Credits

Developed by Dr. J. Jeffin Gracewell
Empowering education through intelligent automation 💡

We are open for and Customizing development

Gracewell

2 workflows

Nodes

n8n-nodes-base.googlesheets n8n-nodes-base.code n8n-nodes-base.merge n8n-nodes-base.respondtowebhook n8n-nodes-base.webhook n8n-nodes-base.gmail n8n-nodes-base.stickynote

Complexity

advanced

Published 14 Oct 2025

Likes 0

View on n8n.io Download Workflow

Install path: /data/workflows/9580/9580.json

Share Your Workflow

Have a useful automation to share? Publish it and help the community.

Submit Your Template How to Submit

Related Workflows

Notify on menu orders via ntfy and Home Assistant TTS with daily BAC tracking

# Notify on menu orders via ntfy and Home Assistant TTS with daily BAC tracking Receive instant push notifications on your phone and voice announcements on your Google Home every time someone orders from your intranet menu — with cumulative BAC tracking per person. > **Full documentation & step-by-step setup guides:** > [📖 Notion Documentation](https://paoloronco.notion.site/Documentation-Menu-Order-Push-Notifications-Home-Assistant-TTS-BAC-32ff0ba27c328075a886d89ebfbf5ce5) > [💻 GitHub Repository](https://github.com/paoloronco/n8n-templates/tree/main/free-templates/5%20v3%20online_menu-push_notifications-homeassistant-TTS-BACcalculation) --- ## What This Workflow Does Every time a customer submits an order from your intranet menu website, this workflow: 1. Receives the order via **Webhook** 2. Logs it to an **n8n DataTable** and reads all orders for that person today 3. Calculates the cumulative **BAC** (Blood Alcohol Content) using the Widmark formula 4. Sends a **push notification** via ntfy (with order history + BAC level) 5. Triggers a **Home Assistant script** → voice announcement on Google Home **No cloud TTS fees. No external AI services. Fully self-hosted.** --- ## Flow ``` Webhook → Prepare Order → DataTable (INSERT) → Read Today's Orders → BAC Calculator → ntfy Push Notification → Home Assistant TTS ``` --- ## Example Output **Push notification (ntfy app):** ``` 🛎 Order from Mario Mario: 1x Pizza, 2x Beer 33cl 🕐 12:30 📋 Ordered before: - 1x Prosecco 🕐 11:45 🍸 BAC ~0.54 g/L 🔴 ``` **Google Home voice announcement:** ``` Mario has ordered Pizza ``` --- ## Prerequisites Before importing this workflow, you need: - A running **n8n** instance (self-hosted or cloud) reachable from the internet - **Home Assistant** on your local network (e.g. `homeassistant.local:8123`) - At least one **Google Home** (or Chromecast-capable) device added to HA via the Google Cast integration - **ntfy** deployed via Docker (self-hosted push notification server) - A public HTTPS URL for ntfy — recommended via **Cloudflare Tunnel** (no open ports needed) - An Android or iOS device with the **ntfy app** installed --- ## Credentials Required | Credential | Used For | | ------------------------------------------------------ | ---------------------------------------- | | **Home Assistant** | Calling the `annuncia_ordine` TTS script | | **Header Auth** (`Authorization: Bearer <ntfy_token>`) | Sending authenticated requests to ntfy | --- ## n8n DataTable Schema Create a DataTable in **n8n → Data → Tables** with these columns: | Column | Type | Description | | -------------- | ------ | ------------------------------------------------------ | | `item` | Text | Full order string (e.g. "2x Negroni, 1x Messina 33cl") | | `person` | Text | Normalised person name | | `alcol_grammi` | Number | Total grams of alcohol for this order | | `data` | Text | ISO date (YYYY-MM-DD) | | `orario` | Text | Time string from the order | Copy the DataTable ID and paste it into the DataTable nodes inside the workflow. --- ## Webhook Payload Your menu website must POST this JSON to the Webhook Production URL: ```json { "name": "Mario", "time": "26/03/2026, 12:30:00", "order": [ { "section": "Food", "name": "Pizza", "details": "", "quantity": 1 }, { "section": "Drinks", "name": "Beer", "details": "33cl", "quantity": 2 } ], "total": 3 } ``` --- ## Setup Steps ### 1. Deploy ntfy (self-hosted push notifications) Add ntfy to your `docker-compose.yml`: ```yaml ntfy: image: binwiederhier/ntfy command: serve volumes: - ./ntfy/config:/etc/ntfy - ./ntfy/data:/var/lib/ntfy ports: - "8095:80" ``` In `server.yml`, set `auth-default-access: deny-all`. Then create an admin user and generate a token: ```bash docker exec -e NTFY_PASSWORD="your_password" ntfy ntfy user add --role=admin admin docker exec ntfy ntfy token add admin ``` ### 2. Expose ntfy over HTTPS (Cloudflare Tunnel) Add an ingress rule to your Cloudflare Tunnel config: ```yaml - hostname: ntfy.YOUR_DOMAIN.com service: http://localhost:8095 ``` ### 3. Configure Home Assistant TTS In HA, go to **Settings → Automations & Scenes → Scripts → Add script → Edit in YAML** and paste: ```yaml alias: annuncia_ordine sequence: - action: tts.speak target: entity_id: tts.google_translate_en_com data: media_player_entity_id: media_player.YOUR_GOOGLE_HOME_ENTITY message: "{{ message }}" language: it mode: single ``` > Replace `media_player.YOUR_GOOGLE_HOME_ENTITY` with your actual entity ID. Then go to your HA profile → **Security → Long-lived access tokens** → create and copy a token. ### 4. Import and configure the workflow 1. Import the workflow JSON into n8n 2. Create the **DataTable** (columns listed above) — copy its ID 3. Create the **Header Auth** credential for ntfy: - Header Name: `Authorization` - Header Value: `Bearer YOUR_NTFY_TOKEN` 4. Create the **Home Assistant** credential: - Host: `http://homeassistant.local:8123` - Access Token: your HA long-lived token 5. In the `ntfy notification` node, replace `YOUR_TOPIC` in the URL 6. In the `Home Assistant TTS` node, set the `message` attribute expression: ``` ={{ $('Webhook').item.json.body.nome }} has ordered {{ $('Webhook').item.json.body.ordine[0].nome }} ``` 7. Activate the workflow and copy the **Webhook Production URL** ### 5. Configure your menu website Set the webhook URL in your menu site config: ```js // menu-data.js "orderWebhook": "https://YOUR_N8N_DOMAIN/webhook/menu" ``` --- ## BAC Calculation (Widmark Formula) ``` BAC [g/L] = total_alcohol_grams_today / (70 × 0.68) ``` Assumes ~70 kg body weight. Italian legal driving limit: **0.5 g/L** | Emoji | Level | BAC | | ----- | ---------- | ------------- | | ⬜ | None | 0 g/L | | 🟢 | Low | < 0.2 g/L | | 🟡 | Warning | 0.2 – 0.5 g/L | | 🔴 | Over limit | > 0.5 g/L | BAC is **cumulative per day per person** and resets automatically the next day. --- ## Customization | What | How | | ----------------------------------------- | ------------------------------------------------------------ | | Change the TTS message | Edit the `message` expression in the HA TTS node | | Announce all ordered items | Use `$json.body.ordine.map(i => i.quantita + ' ' + i.nome).join(', ')` | | Change TTS language | Edit `language` in the `annuncia_ordine` HA script | | Announce on multiple Google Home devices | Add multiple `media_player_entity_id` entries to the HA script | | Disable TTS (keep only push notification) | Remove or deactivate the `Home Assistant TTS` node | --- ## Security | Layer | Mechanism | | -------------------- | ---------------------------------------------------- | | Transport (ntfy) | HTTPS via Cloudflare Tunnel | | ntfy access | `auth-default-access: deny-all` — no anonymous reads | | n8n → ntfy | Dedicated Bearer token (revokable, no expiry) | | n8n → Home Assistant | Long-lived access token | | Mobile app | Username/password on the ntfy server | --- ## Documentation & Source | | | | ------------------------ | ------------------------------------------------------------ | | 📖 **Full documentation** | [Notion — step-by-step setup guides](https://paoloronco.notion.site/Documentation-Menu-Order-Push-Notifications-Home-Assistant-TTS-BAC-32ff0ba27c328075a886d89ebfbf5ce5) | | 💻 **GitHub Repository** | [paoloronco/n8n-templates](https://github.com/paoloronco/n8n-templates/tree/main/free-templates/5%20v3%20online_menu-push_notifications-homeassistant-TTS-BACcalculation) | ## Related Resources - [ntfy.sh documentation](https://docs.ntfy.sh) - [Home Assistant TTS documentation](https://www.home-assistant.io/integrations/tts/) - [Home Assistant Scripts](https://www.home-assistant.io/integrations/script/) - [Google Cast integration](https://www.home-assistant.io/integrations/cast/) - [n8n Home Assistant node](https://docs.n8n.io/integrations/builtin/app-nodes/n8n-nodes-base.homeassistant/)

View

Validate QR tickets in real time with Google Forms and Sheets

## Automated QR Ticket Scanner & Validator This workflow is the perfect companion to the "Automated e-Ticket PDF Generator". It acts as a lightweight, automated check-in system for events. By pairing a simple Google Form with a mobile scanning app, it validates QR codes against your master database in real-time and logs the attendance status. ### How it works 1. **Trigger:** The workflow triggers instantly when a new response is submitted to a Google Form (which acts as your QR code scanner input). 2. **Data Extraction:** It isolates the scanned QR code string from the new Google Sheet row. 3. **Database Lookup:** It cross-references the scanned code with your Master Participant Database in Google Sheets. 4. **Validation (Switch):** A logic node checks if the scanned ticket exists and matches the database. 5. **Log Results:** - **VALID:** If matched, it logs the participant's details into a "Scan Results" sheet with a "VALID" status. - **INVALID:** If not matched, it logs the scanned code with an "INVALID" status, alerting you to an unregistered ticket. ### Field Setup (Pro-Tip) To make this work seamlessly at an actual event venue: 1. **Create a Google Form:** Make a simple form with one short-answer text input for the QR code. 2. **Use "Scan to Web" App:** Install the [Scan to Web](https://play.google.com/store/apps/details?id=com.berrywing.scantoweb) app (or a similar keyboard scanner app) on an Android smartphone. 3. **Scan Away:** Open your Google Form link on the phone, tap the text input field, and use the app to scan the attendee's physical or digital QR code. The app will automatically type the code and submit the form, triggering this n8n workflow instantly! ### Requirements - A Google Workspace account (Google Forms & Google Sheets). - A basic understanding of mapping Google Sheets columns in n8n. - An Android smartphone with the "Scan to Web" app installed for field scanning.

View

Read palm lines and send AI reports via LINE, Gemini, Gmail and Calendar

# Template description (paste this into the n8n Creator Dashboard) --- ## Who is this for This workflow is for anyone who wants to offer a fun, automated palm reading experience through LINE — Japan's dominant messaging app with over 90 million active users. It suits indie developers, wellness creators, fortune-telling services, or anyone curious about combining AI vision with multi-channel automation. ## What this workflow does When a user sends a photo of their palm via LINE, the workflow springs into action across five tools: 1. **LINE Messaging API** receives the image via webhook 2. **Google Gemini** analyzes the palm and produces three outputs: a short LINE-ready summary (under 100 characters), a full reading covering the life line, heart line, head line, and fate line, and three lucky day suggestions with reasons 3. **LINE reply** sends the short summary back to the user instantly 4. **Gmail** delivers a formatted HTML report with the complete reading to a specified address 5. **Google Calendar** registers the three lucky days as calendar events so the user never forgets them Non-image messages (text, stickers) are caught early and trigger a friendly prompt asking the user to send a palm photo instead. ## How to set up 1. Open the **Set config variables** node and fill in your `LINE_CHANNEL_ACCESS_TOKEN`, `GMAIL_FROM`, `GMAIL_TO`, and `GOOGLE_CALENDAR_ID` 2. Connect your **Google Gemini API** credential to the Google Gemini Chat Model node 3. Connect your **Gmail OAuth2** credential to the Gmail node 4. Connect your **Google Calendar OAuth2** credential to the Calendar node 5. Activate the workflow and copy the webhook URL 6. Paste the webhook URL into your LINE Developer Console under the Messaging API channel settings ## Requirements - LINE Developer account and a Messaging API channel (free) - Google Gemini API key (free tier available at Google AI Studio) - Gmail account with OAuth2 set up in n8n - Google Calendar with OAuth2 set up in n8n ## How to customize - **Change the reading language**: edit the prompt in the **Analyze palm lines with Gemini** node — swap English for Japanese, Spanish, or any language Gemini supports - **Adjust the report destination**: update `GMAIL_TO` in the config node to send the report to the user's own address (you could collect it via a prior LINE conversation) - **Change lucky day timing**: the Calendar node currently schedules events starting 7 days from now — adjust the `$now.plus()` expression to fit your use case - **Extend the AI prompt**: add astrology, tarot, or numerology sections to the Gemini prompt for a richer reading experience

View

Need Custom Automation?

Get help designing a custom n8n workflow that connects your stack and fits your process.

Real-time registration form tracking with Google Sheets and Gmail notifications

Workflow preview

Important notice

Overview

Title: Gracewell Automated Registration Tracker Suite

Description:

🚀 Gracewell Automated Registration Tracker Suite

🧩 Workflow Suite Overview

🧠 Who Is This For

⚙️ Problem It Solves

📊 Workflow 1: Live Tracking Dashboard

Steps

Output

💌 Workflow 2: Send Acknowledgements

Steps

Email Template

⚠️ Workflow 3: Send Reminders

Steps

Email Template

🛠️ Setup Instructions

Step 1 – Connect Accounts

Step 2 – Prepare Sheets

Step 3 – Deploy URLs

🎨 Optional Customizations

🧩 Version Summary

Need help customizing?

✨ Credits

We are open for and Customizing development