← 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.
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.
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.
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.
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.
Start a manual webhook test and submit one sample order. Confirm the notification and inserted table row, then the speaker announcement.