Workflows
Data processing, spreadsheets, databases and analytics
Most SMEs run on a fragile Excel and CSV spaghetti: exports from the webshop, invoicing tool, CRM and bank are copied, cleaned and VLOOKUP-ed by hand for hours, and someone tries to conjure a management report on Sunday night. AI data ops automates intake, cleaning and cross-system sync, and lets managers talk to their own data in plain Hungarian.
- Anomaly guard reacts within hours: e.g. cart abandonment jumping from 45% to 88% because the card gateway broke
- Every Monday 7:00 the full analysis runs across finance, marketing, stock and sales with zero manual minutes
Recipes in this category
- 01
Autonomous data cleaning, normalisation and deduplication
CSV and Excel from different sources with different formats (+3630…, 06-30…, 30/…; 2026.03.19, 19/03/2026, March 19). The AI fixes encoding (ISO-8859-2 mangled ő and ű), standardises addresses, tax numbers, IBANs and names, and fuzzy-matches 'Kovács és Társa Kft.', 'Kovács & Társa Kft' and 'Kovacs es Tarsa Kft.' as one partner, merging histories in the CRM and mailing lists.
Claude · n8n · Supabase
- 02
Supplier price-list and catalogue harmoniser
For traders, webshops and manufacturers receiving 5–10 wholesalers' price lists daily or weekly in wildly different Excel, CSV or XML. The AI maps columns without rules (cikkszam = sku = Part Number), detects price changes ('supplier raised copper pipe 15%, four products now sell at a loss'), and updates Shopify, WooCommerce, Unas, Shoprenter or the ERP by your margin rules.
n8n · Claude · Shopify · WooCommerce · Unas
- 03
Natural-language database and Excel search (text-to-SQL)
No more dependence on a programmer or the Excel guru. The manager types in Slack, Teams or an internal form: 'Which service made the most profit in the last six months, and who bought at least three times but has been inactive 60 days?' The AI writes the exact SQL or Python in the background, runs it read-only against PostgreSQL, MySQL, Supabase, Airtable or Google Sheets, and returns the numbers, an interactive chart and a three-sentence explanation in seconds.
Claude · DuckDB · Supabase · Slack
- 04
Cross-system ETL and central data warehouse
Ends data silos: customer in the CRM, order in the shop, finances in Billingo/Számlázz.hu, bank transfers at OTP/Wise. Continuous background sync (n8n + Supabase/PostgreSQL) pulls every new transaction into one 360-degree customer record, the single source of truth.
n8n · Supabase · PostgreSQL · Airbyte
- 05
Real-time anomaly detection and business alarm (AI anomaly guard)
24/7 data patrol on your KPIs. Revenue drop: 'Cart abandonment jumped from 45% to 88% in the last four hours, probably the card gateway is down.' Pricing error: a product set to 1,500 Ft instead of 15,000 on import is suspended instantly.
n8n · Supabase · Slack · Telegram
- 06
Self-generating weekly and monthly executive reports
Every Monday 7:00 the AI runs the full analysis across finance, marketing, stock and sales. Instead of a 40-column table it writes the point: 'Net revenue grew 14% week on week, driven by B2B maintenance contracts (+2.1M Ft).
Claude · Metabase · APITemplate.io · Google Slides
- 07
Predictive modelling: LTV and churn prediction
Who is about to leave? The AI watches order frequency and login habits; a monthly buyer silent for 45 days moves to the 'at risk' segment and a personal outreach task goes to sales. RFM segmentation (recency, frequency, monetary) finds the top 10% most valuable customers and dedicates VIP offers and loyalty discounts to them automatically.
Supabase · Claude · HubSpot
Recommended stack
| Role | Tools | Why |
|---|---|---|
| Code-generating and analysis AI | Claude, code-interpreter models | Flawless Python, SQL and pandas; charts |
| Warehouse and database | Supabase (PostgreSQL), DuckDB, Airtable | Fast relational storage, real-time sync, API and webhook support |
| Data movement and ETL | n8n, Make, Airbyte | Connects dozens of tools and formats: CSV, XLSX, XML, JSON |
| Dashboards and BI | Metabase, Google Looker Studio, Streamlit | Live KPI dashboards on a real data connection |
| Document and report generation | APITemplate.io, Placid, WeasyPrint | Branded weekly executive PDFs |
Source: AI Automation Market Report and Practical Guide (2025–2026)
Have a process like this? Tell us about it.
Book a call