Use cases
Show, don’t tell
Three mini demos with made-up data – this is how such systems run day to day.
A ticket that enriches itself
Zammad → n8n → ERP → Gemini- 1Ticket arrives (Zammad)
- 2Webhook starts the n8n flow
- 3n8n pulls data from the ERP (master data, contract, devices)
- 4Gemini summarizes and suggests a priority
- 5Enriched ticket reaches the agent
Sample data, no real customers.
One channel, many sources
Rocket.Chat / Google Chat# operations
Schedule changes, deployments, reminders, monitoring (Zabbix) and error reports (PostHog) land in the same channel – across time zones, too.
The ERP live in Google Sheets
NiFi → reporting DB → CSV endpoint → IMPORTDATA()ERP databaseLive data
Apache NiFiETL pipeline
Reporting DBBigQuery / SQL
CSV endpointToken · Google check · Cache
Google Sheet=IMPORTDATA()
Photo progress (demo)
FileEditViewInsertFormatDataToolsExtensionsHelp
fx
=IMPORTDATA("https://api.example.com/reporting/42/a1b2c3d4e5f6")| Row | A | B | C | D | E | F | G |
|---|---|---|---|---|---|---|---|
| 1 | id | captured_at | file_id | hash | project | unit | photo |
Each token maps to exactly one SQL query. Customers and staff only get their own data – without a BI license. All data and images are placeholders.