LIVE AUTOMATION 14
E-commerce Sales Assistant — Real Catalog
A live product assistant that reads a Google Sheets catalog, matches an in-stock product to the shopper’s question, logs the inquiry, and emails the recommendation.
BUSINESS PROBLEM
The manual work this replaces
Customers ask product questions in natural language, while staff manually search the catalog, check price and stock, suggest alternatives, record the inquiry, and reply.
LIVE WORKFLOW
What happens after one submission
Visitor asks a safe sample product question → PHP gateway validates it → n8n reads the live Google Sheets catalog → detects shopping intent, category, and budget → filters active in-stock products → ranks relevant matches → logs the inquiry → emails the customer recommendation → returns the best match and relevant alternatives.
REAL EXTERNAL ACTIONS
Proof beyond the browser screen
Real Google Sheets catalog read; real stock and price lookup from the connected Sheet; real inquiry log; real recommendation email.
VERIFIED TEST
What the final test proved
The final verified Audio request under PKR 7,000 matched SonicAir Lite Wireless Headphones at PKR 6,990 with 18 units in stock, returned PowerBeat X2 Wireless Earbuds as the relevant alternative, logged ECOM-20260817-6Q0LAF, and sent the customer email.
BUSINESS VALUE
Why a business would use it
Replaces manual catalog checking, price lookup, stock lookup, first-pass product recommendation, inquiry logging, and customer reply preparation.
SAFE BOUNDARIES
What remains under human or client control
The Google Sheet is a real live data source, while its portfolio product rows are controlled sample inventory. A client version can replace it with Shopify, WooCommerce, ERP, database, or other production inventory APIs.
ARCHITECTURE
How the portfolio test reaches the workflow
Browser form → same-domain PHP gateway → authenticated published n8n workflow → business logic and external actions → structured response → live portfolio result. Private workflow URLs and authentication secrets remain server-side.
NEED A VERSION FOR YOUR BUSINESS?
The portfolio flow is designed to be replaced with your real systems and rules.
Client implementations can connect your website, CRM, inbox, database, team, APIs, and operating process while keeping the same automation architecture.