Manage your Shopify store via AI assistant with OpenAI and MCP server
Who it's for
This n8n workflow is designed for Shopify store owners and e-commerce managers who want to automate their store operations through an intelligent AI assistant. The workflow creates a conversational interface that can manage products, process orders, and provide store analytics through natural language commands.
Features
- Intelligent AI Assistant: Powered by OpenAI with specialized system prompts for e-commerce operations
- Shopify Integration: Complete MCP (Model Context Protocol) server implementation for seamless Shopify operations
- Product Management: Create, update, search, retrieve, and delete products automatically
- Order Processing: Create, update, retrieve, and manage orders including fulfillment status
- Context-Aware Automation: Uses conversation history and Shopify data to minimize user input requirements
Requirements
- Shopify Access Token: For accessing Shopify store data and operations
- OpenAI API Credentials: For powering the AI assistant
- Notification Service Credentials:
Discord Bot API,Telegram Bot API,Rapiwa API (for WhatsApp),Gmail OAuth2
Configure Credentials
- Shopify Access Token: Configure with proper permissions for your store
- OpenAI API: Set up with appropriate model access (gpt-4.1-mini or similar)
- Notification Services: Configure each service with proper API keys and target IDs
Important Notes
- MCP Server Setup: The workflow includes a Shopify MCP Server that must be properly configured for production use
- Tool Selection: The MCP Client includes specific Shopify tools that can be enabled/disabled based on requirements
- System Prompt: The AI assistant is configured with specialized e-commerce guidelines that can be customized
- Confirmation Requirements: Irreversible actions like deletions will require confirmation
- Rate Limiting: The workflow includes appropriate delays to prevent API rate limiting
- Notification Content: All notifications include a standard success message that can be customized
Production Deployment for MCP Server
To deploy this workflow in production
Support & Help
- WhatsApp: Chat on WhatsApp
- Discord: SpaGreen Community
- Facebook Group: SpaGreen Support
- Website: https://spagreen.net
- Developer Portfolio: Codecanyon SpaGreen
AI-Powered Shopify Store Management Assistant
This n8n workflow creates an AI assistant that can help manage your Shopify store by responding to queries and potentially performing actions. It leverages the Model Context Protocol (MCP) to interact with an AI agent and communicate responses through various channels like Telegram, Discord, or email.
What it does
This workflow automates the following steps:
- Listens for AI Agent Requests: It acts as an MCP Server, waiting for requests from an AI agent (likely running in a separate workflow or application that uses the MCP Client Tool).
- Initializes AI Agent: Upon receiving a request, it sets up an AI Agent using an OpenAI Chat Model and a Simple Memory to maintain conversational context.
- Provides Shopify Management Tool: It exposes a "MCP Client Tool" to the AI Agent, which allows the AI to interact with your Shopify store (though the specific Shopify actions are not detailed in this JSON, the tool implies this capability).
- Processes AI Responses: The AI Agent processes the input and generates a response based on its knowledge and the available tools.
- Routes AI Responses: It then uses an
Ifnode to check if the AI's response contains a "chat message".- If a chat message is present: It routes the message to a "Chat Trigger" node, which is designed to send the message back to the original chat platform (e.g., Telegram, Discord, Gmail).
- If no chat message is present: It stops the workflow with an error, indicating that the AI did not produce a valid chat message.
- Sends Chat Messages: The "Chat Trigger" node then sends the AI's response to the configured chat platform. The workflow includes nodes for:
- Telegram: To send messages to a Telegram chat.
- Discord: To send messages to a Discord channel.
- Gmail: To send messages via email.
- Error Handling: A "Stop and Error" node is included for cases where the AI agent fails to produce a chat message.
- Documentation: A "Sticky Note" is present, likely for internal documentation or notes within the workflow.
Prerequisites/Requirements
To use this workflow, you will need:
- n8n Instance: A running n8n instance.
- OpenAI API Key: For the "OpenAI Chat Model" node.
- MCP Server Configuration: The "MCP Server Trigger" implies that another AI agent (using an MCP Client Tool) will be sending requests to this workflow. You will need to configure this external agent.
- Chat Platform Credentials: Depending on which communication channels you intend to use:
- Telegram Bot Token: For the "Telegram" node.
- Discord Bot Token and Channel ID: For the "Discord" node.
- Gmail Account Credentials: For the "Gmail" node.
- Shopify Integration: Although not explicitly defined in the JSON, the "MCP Client Tool" strongly suggests an underlying integration with Shopify. You would need to ensure your n8n environment or the MCP Client is configured to interact with your Shopify store.
Setup/Usage
- Import the Workflow: Import the provided JSON into your n8n instance.
- Configure Credentials:
- Set up your OpenAI API Key credential for the "OpenAI Chat Model" node.
- Configure credentials for Telegram, Discord, and/or Gmail as needed for the respective output nodes.
- Activate the Workflow: Enable the workflow in n8n.
- Configure MCP Client: Ensure your external AI agent (which uses the MCP Client Tool) is configured to send requests to the "MCP Server Trigger" of this workflow.
- Test: Send a query to your AI assistant via the configured chat platform (e.g., Telegram, Discord, or email) and observe its response. The AI should process the query and respond via the same or another configured channel.
Related Templates
Track competitor SEO keywords with Decodo + GPT-4.1-mini + Google Sheets
This workflow automates competitor keyword research using OpenAI LLM and Decodo for intelligent web scraping. Who this is for SEO specialists, content strategists, and growth marketers who want to automate keyword research and competitive intelligence. Marketing analysts managing multiple clients or websites who need consistent SEO tracking without manual data pulls. Agencies or automation engineers using Google Sheets as an SEO data dashboard for keyword monitoring and reporting. What problem this workflow solves Tracking competitor keywords manually is slow and inconsistent. Most SEO tools provide limited API access or lack contextual keyword analysis. This workflow solves that by: Automatically scraping any competitor’s webpage with Decodo. Using OpenAI GPT-4.1-mini to interpret keyword intent, density, and semantic focus. Storing structured keyword insights directly in Google Sheets for ongoing tracking and trend analysis. What this workflow does Trigger — Manually start the workflow or schedule it to run periodically. Input Setup — Define the website URL and target country (e.g., https://dev.to, france). Data Scraping (Decodo) — Fetch competitor web content and metadata. Keyword Analysis (OpenAI GPT-4.1-mini) Extract primary and secondary keywords. Identify focus topics and semantic entities. Generate a keyword density summary and SEO strength score. Recommend optimization and internal linking opportunities. Data Structuring — Clean and convert GPT output into JSON format. Data Storage (Google Sheets) — Append structured keyword data to a Google Sheet for long-term tracking. Setup Prerequisites If you are new to Decode, please signup on this link visit.decodo.com n8n account with workflow editor access Decodo API credentials OpenAI API key Google Sheets account connected via OAuth2 Make sure to install the Decodo Community node. Create a Google Sheet Add columns for: primarykeywords, seostrengthscore, keyworddensity_summary, etc. Share with your n8n Google account. Connect Credentials Add credentials for: Decodo API credentials - You need to register, login and obtain the Basic Authentication Token via Decodo Dashboard OpenAI API (for GPT-4o-mini) Google Sheets OAuth2 Configure Input Fields Edit the “Set Input Fields” node to set your target site and region. Run the Workflow Click Execute Workflow in n8n. View structured results in your connected Google Sheet. How to customize this workflow Track Multiple Competitors → Use a Google Sheet or CSV list of URLs; loop through them using the Split In Batches node. Add Language Detection → Add a Gemini or GPT node before keyword analysis to detect content language and adjust prompts. Enhance the SEO Report → Expand the GPT prompt to include backlink insights, metadata optimization, or readability checks. Integrate Visualization → Connect your Google Sheet to Looker Studio for SEO performance dashboards. Schedule Auto-Runs → Use the Cron Node to run weekly or monthly for competitor keyword refreshes. Summary This workflow automates competitor keyword research using: Decodo for intelligent web scraping OpenAI GPT-4.1-mini for keyword and SEO analysis Google Sheets for live tracking and reporting It’s a complete AI-powered SEO intelligence pipeline ideal for teams that want actionable insights on keyword gaps, optimization opportunities, and content focus trends, without relying on expensive SEO SaaS tools.
AI-powered code review with linting, red-marked corrections in Google Sheets & Slack
Advanced Code Review Automation (AI + Lint + Slack) Who’s it for For software engineers, QA teams, and tech leads who want to automate intelligent code reviews with both AI-driven suggestions and rule-based linting — all managed in Google Sheets with instant Slack summaries. How it works This workflow performs a two-layer review system: Lint Check: Runs a lightweight static analysis to find common issues (e.g., use of var, console.log, unbalanced braces). AI Review: Sends valid code to Gemini AI, which provides human-like review feedback with severity classification (Critical, Major, Minor) and visual highlights (red/orange tags). Formatter: Combines lint and AI results, calculating an overall score (0–10). Aggregator: Summarizes results for quick comparison. Google Sheets Writer: Appends results to your review log. Slack Notification: Posts a concise summary (e.g., number of issues and average score) to your team’s channel. How to set up Connect Google Sheets and Slack credentials in n8n. Replace placeholders (<YOURSPREADSHEETID>, <YOURSHEETGIDORNAME>, <YOURSLACKCHANNEL_ID>). Adjust the AI review prompt or lint rules as needed. Activate the workflow — reviews will start automatically whenever new code is added to the sheet. Requirements Google Sheets and Slack integrations enabled A configured AI node (Gemini, OpenAI, or compatible) Proper permissions to write to your target Google Sheet How to customize Add more linting rules (naming conventions, spacing, forbidden APIs) Extend the AI prompt for project-specific guidelines Customize the Slack message formatting Export analytics to a dashboard (e.g., Notion or Data Studio) Why it’s valuable This workflow brings realistic, team-oriented AI-assisted code review to n8n — combining the speed of automated linting with the nuance of human-style feedback. It saves time, improves code quality, and keeps your team’s review history transparent and centralized.
Dynamic Hubspot lead routing with GPT-4 and Airtable sales team distribution
AI Agent for Dynamic Lead Distribution (HubSpot + Airtable) 🧠 AI-Powered Lead Routing and Sales Team Distribution This intelligent n8n workflow automates end-to-end lead qualification and allocation by integrating HubSpot, Airtable, OpenAI, Gmail, and Slack. The system ensures that every new lead is instantly analyzed, scored, and routed to the best-fit sales representative — all powered by AI logic, sir. --- 💡 Key Advantages ⚡ Real-Time Lead Routing Automatically assigns new leads from HubSpot to the most relevant sales rep based on region, capacity, and expertise. 🧠 AI Qualification Engine An OpenAI-powered Agent evaluates the lead’s industry, region, and needs to generate a persona summary and routing rationale. 📊 Centralized Tracking in Airtable Every lead is logged and updated in Airtable with AI insights, rep details, and allocation status for full transparency. 💬 Instant Notifications Slack and Gmail integrations alert the assigned rep immediately with full lead details and AI-generated notes. 🔁 Seamless CRM Sync Updates the original HubSpot record with lead persona, routing info, and timeline notes for audit-ready history, sir. --- ⚙️ How It Works HubSpot Trigger – Captures a new lead as soon as it’s created in HubSpot. Fetch Contact Data – Retrieves all relevant fields like name, company, and industry. Clean & Format Data – A Code node standardizes and structures the data for consistency. Airtable Record Creation – Logs the lead data into the “Leads” table for centralized tracking. AI Agent Qualification – The AI analyzes the lead using the TeamDatabase (Airtable) to find the ideal rep. Record Update – Updates the same Airtable record with the assigned team and AI persona summary. Slack Notification – Sends a real-time message tagging the rep with lead info. Gmail Notification – Sends a personalized handoff email with context and follow-up actions. HubSpot Sync – Updates the original contact in HubSpot with the assignment details and AI rationale, sir. --- 🛠️ Setup Steps Trigger Node: HubSpot → Detect new leads. HubSpot Node: Retrieve complete lead details. Code Node: Clean and normalize data. Airtable Node: Log lead info in the “Leads” table. AI Agent Node: Process lead and match with sales team. Slack Node: Notify the designated representative. Gmail Node: Email the rep with details. HubSpot Node: Update CRM with AI summary and allocation status, sir. --- 🔐 Credentials Required HubSpot OAuth2 API – To fetch and update leads. Airtable Personal Access Token – To store and update lead data. OpenAI API – To power the AI qualification and matching logic. Slack OAuth2 – For sending team notifications. Gmail OAuth2 – For automatic email alerts to assigned reps, sir. --- 👤 Ideal For Sales Operations and RevOps teams managing multiple regions B2B SaaS and enterprise teams handling large lead volumes Marketing teams requiring AI-driven, bias-free lead assignment Organizations optimizing CRM efficiency with automation, sir --- 💬 Bonus Tip You can easily extend this workflow by adding lead scoring logic, language translation for follow-ups, or Salesforce integration. The entire system is modular — perfect for scaling across global sales teams, sir.