Professional Services and Consulting

<aside> 💼

For professional consulting, tailored solutions, or collaboration opportunities, feel free to get in touch.

Email: [email protected] Website: paoloronco.it

</aside>

Workflow resources

<aside> 📦

Gumroad →

Template files.

</aside>

<aside> 💻

GitHub →

Source files.

</aside>

Overview

Receive menu orders, keep a daily history and send push notifications with an illustrative alcohol estimate. Home Assistant announces each order on the configured speaker.

How it works

The webhook receives English-named order fields. n8n normalizes the customer name, totals the submitted alcohol grams and saves the order. It reads that person's rows for the same UTC date, builds the history and estimate, sends ntfy and calls the Home Assistant script.

The estimate uses fixed assumptions and order data; it does not measure blood alcohol or account for elimination over time. Do not use its value or color for driving decisions. NHTSA explains why BAC and impairment are difficult to assess.

Before you begin

You need n8n, a self-hosted ntfy server, HTTPS access for remote mobile devices and the ntfy app. The supplied deployment uses Docker and Cloudflare Tunnel; an equivalent HTTPS proxy can be used.

Prepare Home Assistant with a working TTS integration and Google Cast speaker reachable on your network. Voice availability and costs depend on the chosen integration.

Configure your own Data Table and service credentials. Use the matching menu payload; the standard notification example uses different field names.

Documentation

01 - Setup ntfy.sh (Self-Hosted)

Deploy ntfy and configure topic authentication.

02 - Expose ntfy with Cloudflare Tunnel

Make ntfy reachable over HTTPS and verify topic access.

03 - Setup the n8n Workflow

Connect the workflow, order table and website.