AI workflow automation for an e-commerce platform, with conversational assistants supporting product enrichment, analytics, marketing, and logistics operations.
For the Prigado e-commerce platform at Inspark Connect, I developed AI-powered workflows and assistants. The work included n8n routing, intent extraction, JSON sanitization, structured SQL aggregation, Gemini integrations, and automated email flows connected to a Laravel and Vue.js product.
Multi-path workflow handling add product, query product, and general help intents with price enrichment, category suggestion, tag generation, and MySQL insertion.
AI Router & Intent Extraction
Strict intent routing with JSON guardrails, sanitized AI outputs, and consistent payload structures across all workflow branches.
SQL Aggregation for AI
Aggregate nodes consolidate relational SQL rows into structured arrays, ensuring AI agents receive clean, readable inputs for accurate responses.
Business-Ready Outputs
Reports, recommendations, and campaign content delivered in formats ready for decision-makers without manual processing.
02Insights & Operations2 capabilities
Boost — Marketing & Sales
Automated email campaigns, sales reports by seller, bundle suggestions, and social post generation based on business data.
Logistics Intelligence
Peak activity prediction, trending product ranking, and customer risk classification using order history and delivery patterns.
03 /System design
How the pieces connect.
System workflow
Prigado automation flow
A structured request is routed through guarded n8n branches that combine platform data, Gemini, and business integrations into usable commerce outputs.
Intent-to-business-output path
Product request
Conversational inputProduct, marketing or logistics request
Intent and parameters
Guarded orchestration
n8n AI routerSelects a specialized workflow branch
JSON sanitizerNormalizes model output for downstream nodes
Routed branch
Specialized automation
Product creationEnrichment, categorization and insertion
Prigado BoostCampaigns, reports and social content
Logistics intelligencePeak, trend and customer-risk analysis
Structured result
Business outputs
Product and support responseStructured results returned to the platform
Reports and campaignsDecision-ready analytics and communication
01System Architecture
AI assistants sit on top of the Prigado Laravel+Vue.js stack, orchestrating MySQL, Gemini, and external APIs through n8n workflows.
Conversational inputProduct, marketing or logistics request
n8n AI routerSelects a specialized workflow branch
Product creationEnrichment, categorization and insertion
Prigado BoostCampaigns, reports and social content
Logistics intelligencePeak, trend and customer-risk analysis
Product and support responseStructured results returned to the platform
Reports and campaignsDecision-ready analytics and communication
