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
💻 GitHub Repository

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

n8n DataTable Schema

Create a DataTable in n8n → Data → Tables with these columns:

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:

{
  "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:

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:

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:

- 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:

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:

// 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

BAC is cumulative per day per person and resets automatically the next day.

Customization

Security

Documentation & Source

Related Resources

• ntfy.sh documentation
• Home Assistant TTS documentation
• Home Assistant Scripts
• Google Cast integration
• n8n Home Assistant node