AI Sales Insights Integration

The task is to connect my existing MySQL database—which holds our sales data—to ChatGPT through an n8n workflow so that end-users receive clear, actionable suggestions each time they interact with our platform. I will provide database credentials, example queries, and a test environment; you’ll design the automation that fetches the latest records, frames the prompt for ChatGPT, parses the response, and returns the suggestions back to the front-end endpoint I expose.

Because the records include order values, product IDs, and time-stamped transactions, the AI must reliably summarise trends, spot anomalies, and recommend next steps without exposing raw customer details. Please structure prompts to keep the model on topic and add guardrails that limit tokens and strip sensitive fields.

We are working with:
• MySQL
• n8n self-hosted
• OpenAI GPT-4 API

I’d like the first working pass inside two weeks and final polishing within the full month window. If you’ve built similar data-driven GPT integrations, share a quick note about your approach so we can hit the ground running.