← Documentation: Menu Order Push Notifications + Home Assistant TTS + BAC


This guide connects the menu website to your ntfy topic and Home Assistant script. Use the English-named payload below; it matches the published JSON.

1. Import and connect ntfy

Import the JSON from this workflow's GitHub resources and leave it inactive. Create Header Auth with header Authorization and value Bearer YOUR_NTFY_TOKEN.

In Send Ntfy Notification, select that credential and set the URL to http://ntfy/YOUR_TOPIC on a shared Docker network, or your public HTTPS server and topic.

Keep the supplied raw text/plain body. Its expressions format the order into a notification.

2. Connect the order table

Create an n8n Data Table with these exact columns:

Column Type Purpose
item Text Formatted order
person Text Normalized customer name
alcohol_grams Number Alcohol grams submitted for this order
date Text UTC date, YYYY-MM-DD
order_time Text Submitted display time

Select the same table in Log Order to Database and Read Today's Orders. The read filters use the normalized person and UTC date.

3. Connect voice announcements

Complete 04 - Setup Home Assistant TTS. In Announce Order with Home Assistant, select the Home Assistant credential and use resource Service, operation Call, domain script and service announce_order.

Keep the message service attribute from the JSON. It references When Order Received and announces the first item. Use the TTS guide to customize that text.

4. Match the website payload

The website must POST JSON to the webhook. Example alcohol values are illustrative inputs; the workflow does not infer them from product names:

{
  "name": "Mario",
  "time": "12:30",
  "items": [
    {
      "name": "Pizza",
      "detail": "",
      "quantity": 1,
      "alcohol_grams": 0
    },
    {
      "name": "Beer",
      "detail": "33cl",
      "quantity": 2,
      "alcohol_grams": 13
    }
  ],
  "total": 3
}

Supply numeric alcohol_grams per item unit and numeric quantity. Missing alcohol values contribute zero in the supplied calculation.

5. Test and connect devices

Start a manual webhook test and submit one sample order. Confirm the notification and inserted table row, then the speaker announcement.