HTTP Request and Shopify integration

This n8n workflow orchestrates a powerful suite of AI Agents and automations to manage and optimize various aspects of an e-commerce operation, particularly for platforms like Shopify. It leverages Langchain AI Agents powered by OpenAI, along with a variety of integrated services, to handle customer support, product recommendations, abandoned cart recovery, inventory management, post-purchase engagement, review monitoring, marketing campaigns, and operational alerts. Tools & Services Used n8n:** Core automation and orchestration platform. Langchain AI Agents:** For intelligent decision-making, task execution, and natural language processing across multiple modules. OpenAI (e.g., GPT-4o Mini):** Powers the AI Agents and direct LLM calls for tasks like sentiment analysis and content generation. Shopify (Conceptual - requires specific API/Webhook setup):** For triggers (abandoned cart, order delivered) and actions (fetching products/inventory, creating discounts). Google Sheets:** Used as a data store for FAQs, logging low stock, review databases, and campaign outcomes. Slack:** For internal team notifications (escalations, low stock, negative reviews). Twilio (or similar SMS service):** For sending SMS alerts (cart recovery, restock notifications). Email (Generic SMTP/API):** For sending various emails (AI responses, recovery emails, review requests, campaign emails). Notion:** For logging customer interactions. HTTP Request Nodes:** For generic API interactions (fetching customer info, product search, CRM, campaign tracking). Webhook Nodes:** For receiving external triggers (incoming messages, product inquiries, review submissions, restock signals). Cron Nodes:** For scheduled tasks (hourly inventory checks, daily campaigns). Workflow Overview This workflow is a collection of interconnected sub-workflows, each designed to automate a specific e-commerce process: Customer Support & Escalation Handles incoming customer messages, attempts to answer with FAQs or order status using an AI Agent, and escalates to a human agent via Slack if necessary. Logs interactions to Notion. Product Inquiry & Recommendation Processes product inquiries, searches a product catalog, filters/sorts results, uses an AI Agent for selection refinement, and can build a product carousel for user response. Abandoned Cart Recovery Detects abandoned carts, fetches customer data, uses an AI Agent to strategize recovery (e.g., offer discounts), and sends follow-up communications via email/SMS. Inventory Management (Low Stock Alert) Periodically checks inventory levels, identifies low-stock items, uses an AI Agent to format reports, and notifies relevant teams via Slack/email, logging to Google Sheets. Post-Purchase Review Request After a set period post-delivery, an AI Agent drafts and initiates sending a personalized product review request email to the customer. Review Monitoring & Flagging Listens for new product reviews, uses an AI model for sentiment analysis, alerts a support team for negative reviews via Slack, and logs all reviews. Scheduled Marketing Campaigns Fetches target audiences, segments them, uses AI Agents to generate tailored email content, sends campaigns, tracks basic metrics, and employs another AI Agent to suggest campaign adjustments. Manual Restock Alert & Logging Allows triggering a restock notification via webhook, sends an SMS alert, and uses an LLM to log the event. Prerequisites Ensure you have active accounts and necessary API keys/credentials for: OpenAI Shopify (or your e-commerce platform API) Google Cloud (for Google Sheets API) Slack (Bot Token) Twilio (Account SID, Auth Token, From Number) Your Email Sending Service (SMTP details or API key) Notion (Integration Token) Any other external APIs used (e.g., CRM, Product Search, Customer Info, Campaign Tracking) How to Use This Template Step 1: Import the Template Open your n8n instance. Go to “Workflows” > “Create Workflow”. Click the three dots (…) > “Import from File”. Upload the downloaded JSON file of this workflow. Step 2: Configure Critical Nodes & Credentials This is the most crucial step. Systematically go through each of the 8 sections outlined in the Sticky Notes within the workflow and configure the relevant nodes: SECTION 1 (Customer Support):** Get FAQs Data (Google Sheets): Set sheetId to YOUR_SHEET_ID_HERE and configure Google API credentials. Lookup Order API (HTTP Request): Set url to YOUR_ORDER_LOOKUP_API_ENDPOINT_HERE. Notify Human Agent (Slack): Configure Slack API credentials and channel. Send AI Response to Customer (HTTP Request): Set url to YOUR_CUSTOMER_RESPONSE_API_ENDPOINT_HERE. Store to Notion (Notion): Set pageId (Database ID) to YOUR_NOTION_DATABASE_URL_OR_ID_HERE and Notion API credentials. SECTION 2 (Product Inquiry):** Search Products API (HTTP Request): Set url to YOUR_PRODUCT_SEARCH_API_ENDPOINT_HERE. Build Product Carousel (Function): Update YOUR_DEFAULT_PRODUCT_IMAGE_URL_HERE and YOUR_FALLBACK_PRODUCT_URL_HERE. Respond to User with Carousel (HTTP Request): Set url for sending carousel data. SECTION 3 (Abandoned Cart):** Detect Abandoned Cart (Shopify Trigger): Configure Shopify credentials and ensure the correct trigger event. Fetch Customer Info (HTTP Request): Set url to YOUR_CUSTOMER_INFO_API_ENDPOINT_HERE. Create Discount (if applicable) (Shopify): Configure Shopify credentials and review discount creation parameters. Send Recovery Email (HTTP Request/Email Send): Set email API endpoint or SMTP credentials. Send SMS Reminder (Twilio): Configure Twilio credentials and from number (YOUR_TWILIO_PHONE_NUMBER_HERE). SECTION 4 (Low Stock Alerts):** Fetch Inventory (Shopify): Configure Shopify credentials. Notify Slack (Low Stock) (Slack): Configure Slack API credentials and channel. Generate Email Report (Low Stock) (Email Send): Configure SMTP/email credentials and to address. Export to Sheets (Low Stock Log) (Google Sheets): Set sheetId to YOUR_INVENTORY_LOG_SHEET_ID_HERE and Google API credentials. SECTION 5 (Review Request):** Order Delivered Trigger (Shopify Trigger): Configure Shopify credentials. Fetch Customer Data (for Review) (HTTP Request): Set url to YOUR_CUSTOMER_INFO_API_ENDPOINT_HERE. DraftReviewRequestEmail (Tool): Update YOUR_PRODUCT_PAGE_URL_BASE_HERE and YOUR_WEBSITE_URL_HERE. Send Review Request Email (Email Send): Configure SMTP/email credentials. SECTION 6 (Review Monitoring):** OpenAI node (currently Assistant Create): IMPORTANT: For sentiment analysis, change this node type to @n8n/n8n-nodes-langchain.lmChatOpenAi. Then configure its prompt for sentiment analysis (e.g., System: "Analyze sentiment. Respond with positive, negative, or neutral." User: "Review: {{ $('Listen for Review Webhook').first().json.body.review_text }}"). Set OpenAI credentials. Notify Support Team (Negative Review) (Slack): Configure Slack API credentials and channel. Add Review to Database (Google Sheets): Set sheetId to YOUR_REVIEWS_DATABASE_SHEET_ID_HERE and Google API credentials. SECTION 7 (Marketing Campaigns):** Fetch Target Audience API (HTTP Request): Set url to YOUR_CRM_API_FOR_AUDIENCE_HERE. GenerateCampaignEmailVariant (Tool): Update YOUR_CAMPAIGN_LANDING_PAGE_HERE. Send Campaign Email (Email Send): Configure SMTP/email credentials. Track Campaign Metrics API (HTTP Request): Set url for YOUR_CAMPAIGN_TRACKING_API_ENDPOINT_HERE. Log Campaign Outcome & Adjustments (Google Sheets): Set sheetId to YOUR_CAMPAIGN_LOG_SHEET_ID_HERE and Google API credentials. SECTION 8 (Manual Restock):** Send SMS Alert (Restock) (Twilio): Configure Twilio credentials, from number (YOUR_TWILIO_PHONE_NUMBER_HERE), and to (WAREHOUSE_MANAGER_PHONE_NUMBER_HERE). OpenAI Chat Model (for Basic LLM Chain): Configure OpenAI credentials. Send restock Request Email1 (Email Send): Configure SMTP/email credentials and to address. Step 3: Implement Tool Logic Go into each @n8n/n8n-nodes-langchain.toolCode node (e.g., SearchFAQs, RefineProductSelection, DetermineDiscount, etc.). The current JavaScript is placeholder. You MUST replace this with actual JavaScript logic that performs the intended action for each tool, often by making API calls or processing data based on the agent's input. Step 4: Review AI Agent Prompts & Tool Connections Carefully review the systemMessage for each AI Agent node to ensure it accurately reflects its role and how it should use its tools. CRITICAL:** Verify the index for tools connected to each AI Agent. Each tool connected to a single agent must have a unique, sequential index (0, 1, 2, ...). AI Agent (ID cd71629d-... in your JSON): SearchFAQs tool should be index: 0, LookupOrderStatus tool should be index: 1. (Please double-check and correct the connection indices in your actual workflow file if they are still both pointing to index 0). AI Agent6 (ID 4c24879b-... in your JSON): AnalyzeCampaignPerformance tool should be index: 0, SuggestCampaignAdjustments tool should be index: 1. (Please double-check and correct the connection indices in your actual workflow file if they are still both pointing to index 0). Initial Test Run Disable most of the workflow sections initially. Focus on one section at a time (e.g., Section 1: Customer Support). Manually trigger the first node (e.g., simulate an incoming webhook). Execute node by node, checking the output and debugging configurations and tool logic. For time-based triggers (Cron, Wait nodes), temporarily shorten the durations for faster testing. Once a section is working, move to the next. Use Cases E-commerce Businesses (Shopify, etc.):** To automate customer service, marketing, sales recovery, and operations. Digital Marketing Agencies:** To offer advanced automation services to e-commerce clients. Freelancers & Consultants:** To build and deploy sophisticated AI-driven e-commerce solutions. n8n Developers:** As a comprehensive template and learning resource for building complex multi-agent systems.

Overview Stop struggling with content creation for your e-commerce store. This workflow acts as your automated AI Content Marketer, instantly transforming your Shopify product details into high-quality, SEO-optimized blog posts. It handles everything from reading product data to writing the article and uploading it directly to your store as a draft. What this workflow does Fetches Product Data: Automatically pulls product titles and descriptions directly from your Shopify store (configurable limit). Data Logging: Backs up the raw product data into Google Sheets for record-keeping before processing. AI SEO Writing: Uses a powerful LLM (via OpenRouter/DeepSeek) to write a complete, engaging blog post based on the product's features. It generates an SEO-friendly title and formats the body content in clean HTML (headings, bullet points, etc.). Smart Parsing: A custom Code node ensures the AI's output is strictly formatted as JSON, separating the Blog Title from the Blog Content to prevent errors. Auto-Drafting in Shopify: Uploads the generated article directly to your specific Shopify Blog ID as a "Draft" (so you can review it before publishing). Email Notification: Sends a confirmation email via Gmail to let you know your new blog posts are ready for review. Setup Requirements To run this workflow, you will need to set up credentials in n8n for the following services: Shopify Admin API: To fetch products and create articles. (You will need your Shop Name and an Access Token). OpenRouter (or OpenAI): To power the AI Agent. The template is configured for DeepSeek via OpenRouter, but can be swapped for OpenAI. Google Sheets: To log product data and generated blog content. Gmail: To send the completion notification. How to use Configure Variables: Double-click the "Variables" node (Set node) at the start of the workflow. Enter your shop name (e.g., my-store from my-store.myshopify.com) and your blogId (found in the URL when viewing your blog in Shopify Admin). Connect Google Sheets: Open the Google Sheets nodes and map them to a sheet in your Drive. Ensure your sheet has columns for ID, Title, and Description. Select AI Model: In the Chat Model node, ensure your API key is connected (OpenRouter is used by default for cost-efficiency). Run: Execute the workflow. It will process your products and populate your Shopify Blog with new drafts automatically. Video Tutorial Watch the full setup guide here: Guide

Multi-Platform Review Collector for n8n: Trustpilot + Google + Facebook Automation How it works The schedule triggers daily review collection from configured platforms and connects to multiple review platform APIs to download latest reviews. The workflow normalizes review data into consistent format with rating, text, date, source, and customer name. It removes duplicates and stores centralized database in Google Sheets creating comprehensive review repository for analysis and response management. Trigger: Daily schedule (10 AM) Output: Updated review database Timing: Daily sync Frequency: Once per day Data Flow: Trustpilot → API call → Raw reviews Google Reviews → API call → Raw reviews Facebook → API call → Raw reviews ↓ Normalize format → Remove duplicates ↓ Google Sheets → Centralized database Set up instructions Set up Shopify credentials in n8n: API Key, Password, Shop Subdomain, and Shared Secret Obtain API credentials for each review platform you want to monitor (Trustpilot, Google Reviews, Facebook) Configure HTTP Request nodes with proper API endpoints and authentication headers for each platform Set up Google Sheets credentials and create a spreadsheet with columns: Source, Rating, Review Text, Customer Name, Date, Product ID, Review ID The schedule trigger runs daily at 10 AM but feel free to adjust frequency based on review volume Update the Code node with proper data mapping for each review platform's API response format Test API connections individually before running the full workflow to ensure all platforms return data correctly

🧨 VIP Radar: Instantly Spot & Summarize High-Value Shopify Orders with AI + Slack Alerts Automatically detect when a new Shopify order exceeds $200, fetch the customer’s purchase history, generate an AI-powered summary, and alert your team in Slack—so no VIP goes unnoticed. 🛠️ Workflow Overview | Feature | Description | |------------------------|-----------------------------------------------------------------------------| | Trigger | Shopify “New Order” webhook | | Conditional Check | Filters for orders > $200 | | Data Enrichment | Pulls full order history for the customer from Shopify | | AI Summary | Uses OpenAI to summarize buying behavior | | Notification | Sends detailed alert to Slack with name, order total, and customer insights | | Fallback | Ignores low-value orders and terminates flow | 📘 What This Workflow Does This automation monitors your Shopify store and reacts to any high-value order (over $200). When triggered: It fetches all past orders of that customer, Summarizes the history using OpenAI, Sends a full alert with context to your Slack channel. No more guessing who’s worth a closer look. Your team gets instant insights, and your VIPs get the attention they deserve. 🧩 Node-by-Node Breakdown 🔔 1. Trigger: New Shopify Order Type**: Shopify Trigger Event**: orders/create Purpose**: Starts workflow on new order Pulls**: Order total, customer ID, name, etc. 🔣 2. Set: Convert Order Total to Number Ensures the total_price is treated as a number for comparison. ❓ 3. If: Is Order > $200? Condition**: $json.total_price > 200 Yes** → Continue No** → End workflow 🔗 4. HTTP: Fetch Customer Order History Uses the Shopify Admin API to retrieve all orders from this customer. Requires your Shopify access token. 🧾 5. Set: Convert Orders Array to String Formats the order data so it's prompt-friendly for OpenAI. 🧠 6. LangChain Agent: Summarize Order History Prompt**: "Summarize the customer's order history for Slack. Here is their order data: {{ $json.orders }}" Model**: GPT-4o Mini (customizable) 📨 7. Slack: Send VIP Alert Sends a rich message to a Slack channel. Includes: Customer name Order value Summary of past behavior 🧱 8. No-Op (Optional) Used to safely end workflow if the order is not high-value. 🔧 How to Customize | What | How | |--------------------------|----------------------------------------------------------------------| | Order threshold | Change 200 in the If node | | Slack channel | Update channelId in the Slack node | | AI prompt style | Edit text in LangChain Agent node | | Shopify auth token | Replace shpat_abc123xyz... with your actual private token | 🚀 Setup Instructions Open n8n editor. Go to Workflows → Import → Paste JSON. Paste this workflow JSON. Replace your Shopify token and Slack credentials. Save and activate. Place a test order in Shopify to watch it work. 💡 Real-World Use Cases 🎯 Notify sales team when a potential VIP buys 🛎️ Prep support reps with customer history 📈 Detect repeat buyers and upsell opportunities 🔗 Resources & Support 👨‍💻 Creator: Yaron Been 📺 YouTube: NoFluff with Yaron Been 🌐 Website: https://nofluff.online 📩 Contact: [email protected] 🏷️ Tags #shopify, #openai, #slack, #vip-customers, #automation, #n8n, #workflow, #ecommerce, #customer-insights, #ai-summaries, #gpt4o

This workflow automates the Mark as Fulfilled action in Shopify for each order, ensuring a seamless fulfillment process without manual intervention. How It Works This workflow retrieves all unfulfilled orders and processes their fulfillment automatically. Since Shopify requires a Fulfillment Order ID (not Order ID) to trigger fulfillment, the workflow follows these steps: 1️⃣ Get all unfulfilled orders using the Shopify node. 2️⃣ Retrieve the Fulfillment Order ID using the "List Fulfillment Orders" action. 3️⃣ Create a fulfillment request using "Mark fulfillment order as fulfilled." 4️⃣ Handle edge cases, such as partially fulfilled orders or API errors. This ensures that every valid order is marked as fulfilled efficiently. 🔗 Ongoing discussions on this topic: Relevant Shopify API Discussion Step-by-step The workflow can be run as requested or on schedule You can adjust these parameters within the Shopify and filter nodes: Shopify Admin URL – A Global node to customize the Shopify store URL. To find your Shopify store ID, login into your Shopify admin, then look at the URL in your browser's address bar, the subdomain portion (e.g., example_store_id.myshopify.com) is your store ID (in this case: example_store_id) Order Filtering – Ensures only valid orders are fulfilled, particularly useful if: You sell digital downloads or gift cards exclusively. You use third-party fulfillment services for all products. Credentials To run this workflow, you'll need: Shopify API Key – Required for authentication. Who Is This For? Shopify store owners looking to automate their fulfillment process. Merchants selling digital or personalized products who need instant fulfillment. Explore More Templates 👉 Check out my other n8n templates

This workflow contains community nodes that are only compatible with the self-hosted version of n8n. AI Blog Automation for Shopify is a n8n workflow that automatically transforms your Shopify products into engaging, problem-focused blog posts. Say goodbye to spending 5+ hours per article – this workflow generates SEO-optimized content that addresses customer pain points, not just product features. 🎯 Who is this for? E-commerce store owners** wanting consistent content marketing without the time investment. Dropshipping entrepreneurs** with frequent product launches needing automated blog content. Shopify merchants** who know blogging drives traffic but lack writing resources. Content marketers** seeking scalable, cost-effective blog automation. 🚨 Problem Solved Creating quality blog content is time-consuming and expensive. Most store owners either skip blogging entirely or burn out after a few posts. This workflow solves it by: Automatically generating problem-first content (not salesy product descriptions). Creating stunning AI-generated hero images for each post. Publishing directly to your Shopify blog with proper SEO formatting. Costing only $0.05-0.15 per post vs. $200+ for professional writers. ⚙️ What This Workflow Does | Feature | Description | |---------|-------------| | Triggers | - Manual execution for existing products- Automatic trigger when new products are created | | Analyzes Products | Uses LangChain + OpenAI to:- Identify core problems the product solves- Analyze customer pain points- Generate problem-focused angles | | Creates Content | GPT-4o-mini generates 1000-1500 word articles:- Problem-first approach (not product-first)- SEO-optimized structure- Natural product integration- Soft call-to-actions | | Generates Images | DALL-E 3 creates blog hero images:- Matches blog theme (not just product)- Brand-consistent styling- Mobile-optimized dimensions | | Hosts Images | Uploads to ImgBB (free CDN):- No expiration- Fast global delivery- Direct URL integration | | Publishes | Posts directly to Shopify blog:- Proper HTML formatting- SEO meta descriptions- Relevant tags- Mobile-responsive images | 🚀 Setup Instructions 🔐 Credentials Needed Shopify Access Token API** (with read_products, write_content, read_content scopes) OpenAI API** (for content + image generation) ImgBB API** (free image hosting) 🔧 Shopify Configuration Create private app in Shopify admin Enable required API scopes: read_products - Read product data write_content - Create blog posts read_content - Access blog configuration Copy access token (starts with shpat_) 🧩 Node Setup Manual Trigger** — For on-demand execution Shopify Trigger** — Auto-runs on product creation Shopify Node** — Fetches product data LangChain + OpenAI** — Generates problem-focused content Structured Output Parser** — Formats AI response HTTP Request** — Retrieves blog configuration DALL-E Node** — Creates hero images ImgBB Upload** — Hosts images on free CDN GraphQL Mutation** — Publishes to Shopify blog 🛠️ Customization Tips | Feature | How to Customize | |---------|------------------| | Content Length | Adjust word count in AI Content Generator prompt | | Image Style | Modify DALL-E prompt for brand colors/aesthetics | | Author Name | Change author field in Publish Blog Article node | | Blog Selection | Update blog ID to target specific Shopify blog | | Publishing | Set isPublished: false to save as drafts | | Brand Voice | Customize tone and style in content prompts | 📦 Pre-Requirements n8n instance (Cloud or self-hosted)** (Cloud/Self-hosted) Install: @n8n/n8n-nodes-langchain Shopify private app** with proper scopes OpenAI account** with billing enabled ImgBB account** (free) 🔧 Nodes Used Manual Trigger Shopify Trigger Shopify LangChain LLM OpenAI Chat Model Structured Output Parser HTTP Request OpenAI (DALL-E) Wait ✅ Test the Workflow Import workflow and configure all credentials. Update store URLs and API tokens. Run manually or add a new product to trigger automatically. Check your Shopify blog for the new problem-focused post! 💰 Expected Results Time Saved**: 5+ hours per blog post Cost**: $0.10-0.20 per post (vs. $200+ for writers) Traffic**: 40-60% increase within 3 months (typical) Content Quality**: Problem-focused, not salesy Made by: Khaisa Studio Tags: shopify, blog, automation, ai, content-marketing, seo Category: E-commerce Automation, Content Marketing Need customization? contact me on LinkedIn or Web

Who is this for? This template is ideal for solo store owners, eCommerce marketers, automation beginners, or anyone using Shopify and Gmail who wants to recover lost revenue without coding. What problem does this solve? Customers often leave items in their cart without completing the purchase. Manually chasing those sales is inefficient and inconsistent. This workflow automates the recovery process by sending emails (and optionally SMS) based on Shopify checkout activity. What this workflow does: ✅ Detects when a Shopify checkout is created but not completed, ⏳ Waits 1 hour, then checks if the cart was abandoned, 🧾 Pulls cart contents and applies a fallback discount, 📧 Sends a recovery email via Gmail, 🕓 After 24 hours, you can optionally send an SMS or WhatsApp reminder via Twilio, 📊 Logs each interaction to Google Sheets for tracking. Setup: Create Shopify, Gmail, Google Sheets, and Twilio credentials in your n8n instance, Import the JSON workflow file Replace the Shopify trigger with your store's webhook (set to “Checkout Create”), Set your wait time (default: 1 hour), Link your Gmail account and customize the email message, (Optional) Link Twilio to add a multi-channel reminder, Update the Google Sheets node with your own Sheet ID and headers. 🗒 Color-coded workflow notes: To make customization easier, this template includes a visual sticky note system inside the n8n canvas. You’ll find: 🟩 Green Notes → Main Steps Clear, essential stages of the automation (e.g. wait, check cart status, send email), 🟦 Blue Notes → Personalization Tips Small tweaks you can make to match your tone, store brand, or logic (e.g. email copy, discount logic), 🟨 Yellow Notes → Optional / Advanced Features that you can explore setting up: Twilio SMS, Airtable logging, human approval steps, etc. 👉 Look around each key node for quick tips, setup instructions, and TO-DO items. This system helps you understand and modify the workflow at a glance — whether you're a beginner or scaling a pro setup. How to customize this workflow? 🎯 Swap Shopify for WooCommerce or Stripe by replacing the trigger and cart-check logic, 💬 Localize and personalize each email message or add multilingual support via AI, 📈 Upgrade logging from Google Sheets to Airtable for CRM-style features, 🤝 Add manual approval steps for high-value discounts, 💡 Want a one-time unique code per user? Let us build that logic for you → [email protected] Final notes This template was designed by Velebit from Innovatio. External links in the workflow (e.g. support or upgrade options) are optional and purely informative, while only leading to the official company webiste with no affiliate or similar links included in the template itself. A separate license applies to the paid version on Gumroad, which includes additional modules and commercial use rights.

Who is this for E-commerce store owners and sales managers who want AI-powered insights from their Shopify data without manually crunching numbers every week. What it does This workflow automatically analyzes your Shopify sales performance every Monday morning and delivers intelligent insights via Slack and email. It pulls the last 7 days of orders, calculates key metrics (revenue, order count, average order value), and sends the data to Gemini AI for trend analysis and actionable recommendations. The AI identifies patterns in your sales data and provides specific suggestions for improving performance. All metrics are logged to Google Sheets for historical tracking, and the team receives instant alerts when revenue drops more than 20% compared to the previous week. How to set up Connect your Shopify store with order read permissions Add your Gemini API key for AI analysis Set up Slack integration and choose your target channels (#sales and #alerts) Configure Gmail credentials for stakeholder email reports Create a Google Sheets document with a "Weekly Metrics" tab for data tracking Update the email recipients and spreadsheet ID in the respective nodes Requirements Shopify store with API access Google Gemini API key Slack workspace Gmail account Google Sheets access How to customize Adjust the revenue drop threshold in the IF node (default: 20%), modify the schedule frequency, customize Gemini prompts for different analysis types, or add additional Slack channels for department-specific reports.

Who Is This For? This workflow is perfect for e-commerce store owners using Shopify who want to automatically announce new products to their customer base through personalized WhatsApp messages. It's ideal for businesses looking to increase product visibility and drive sales without manual outreach efforts. What This Workflow Does This workflow automatically sends WhatsApp product announcements whenever a new product is added to your Shopify store. It processes product data by extracting images, generating product links, and converting HTML descriptions into clean, bullet-point feature lists using OpenAI. Customer data is pulled from Shopify, formatted, and phone numbers are verified on WhatsApp via the Rapiwa API. Personalized messages with product images, features, and purchase links are sent only to verified numbers. All verification and messaging activity is logged in Google Sheets, clearly tracking which contacts were verified and successfully reached. Features Shopify Integration** that triggers automatically when new products are created Image Processing** to extract and filter valid product images from Shopify Product URL Generation** to create direct links to new products AI-Powered Description Conversion** using OpenAI to transform HTML descriptions into concise bullet points Customer Data Retrieval** from Shopify store via API WhatsApp Number Verification** using Rapiwa to check if customer numbers are valid WhatsApp accounts Personalized WhatsApp Messaging** with product details, features, and images Dual-Path Logging** to Google Sheets, tracking both verified (sent) and unverified (not sent) messages Batch Processing** to handle multiple customers efficiently Rate Limiting** with wait steps to avoid API restrictions Requirements Shopify Access Token API credentials** for accessing product and customer data OpenAI API credentials** for converting HTML descriptions to bullet points Rapiwa API credentials** for WhatsApp number verification and messaging Google Sheets OAuth2 credentials** for logging message delivery status Support & Help WhatsApp**: Chat on WhatsApp Discord**: SpaGreen Community Facebook Group**: SpaGreen Support Website**: https://spagreen.net Developer Portfolio**: Codecanyon SpaGreen

Who it's for This n8n workflow is designed for Shopify store owners, e-commerce managers, and digital marketers who want to automate their product promotion across multiple platforms. The workflow automatically creates promotional content for new products and distributes them across various social media and content management platforms. Key Features Automatically detects new Shopify products AI converts product descriptions into clear bullet points Optimizes images for each platform Publishes formatted posts to WordPress Shares content across multiple social platforms Sends notifications after successful posts Requirements Shopify Access Token**: For detecting new products in your store OpenAI API Credentials**: For enhancing product descriptions WordPress API Credentials**: For creating posts and uploading media Social Media Platform Credentials**: Facebook Graph API Telegram Bot API LinkedIn OAuth2 API Discord Bot API Notification Service Credentials**: Gmail OAuth2 Rapiwa API (for WhatsApp) Workflow Steps Shopify Trigger: Detects when a new product is created in your Shopify store Image Processing: Extracts and processes product images from the Shopify data Content Enhancement: Uses OpenAI to convert HTML product descriptions into concise, customer-friendly bullet points WordPress Integration: Creates a blog post on your WordPress site with the product information Multi-Platform Sharing: Automatically shares the product on: Facebook page, Telegram channel, LinkedIn profile and page, Discord channel, Instagram Notification System: Sends completion notifications through multiple channels (Telegram, Gmail, Discord, WhatsApp) Support & Help WhatsApp**: Chat on WhatsApp Discord**: SpaGreen Community Facebook Group**: SpaGreen Support Website**: https://spagreen.net Developer Portfolio**: Codecanyon SpaGreen

Order Fulfillment & Shipping Notification System Automatically notify customers via WhatsApp when their orders ship, with intelligent phone validation, multi-country support, and bilingual messaging including complete tracking information. What does this workflow do? When you fulfill an order in Shopify, this workflow instantly updates your database, validates the customer's phone number across 23+ countries, and sends a professional WhatsApp notification with full tracking details in their preferred language. Key features: 🌍 23+ Country Phone Validation - Automatically detects and formats phone numbers for GCC, MENA, and international customers 📦 Complete Tracking Info - Includes tracking number, courier name, and clickable tracking URL 🌐 Smart Bilingual Messaging - Arabic and English with luxury brand tone 💾 Real-time Database Sync - Updates order status and shipping details instantly 🔒 Test Number Protection - Blocks notifications to development phone numbers ✨ Personalized Messages - Addresses customers by first name ⏱️ Delivery Expectations - Communicates clear 7-12 business day timeline 🎯 International Format - Handles phone numbers with automatic country code detection Setup Requirements Integrations Needed: Shopify - For order fulfillment webhooks PostgreSQL - For order and customer data storage WhatsApp Business API - For sending notifications via Facebook Graph API Credentials Required: Shopify Access Token (with fulfillment webhook permissions) PostgreSQL database credentials WhatsApp Business API Bearer Token (Facebook Graph API v18.0) How to Use Import the workflow into your n8n instance Configure credentials: Add your Shopify store access token Connect your PostgreSQL database Add your WhatsApp Business API credentials Update test phone numbers in filter nodes (If10 and If11) with your actual test numbers Customize brand name in WhatsApp message templates if needed (currently "" / "") Activate the workflow to start sending shipping notifications Workflow Structure Trigger (Shopify Webhook) Listens for fulfillments/create events when orders are marked as shipped in Shopify Update Order Status Updates PostgreSQL database with: Status changed to 'shipped' Shipping company name Tracking number Customer Lookup Retrieves customer record from database using phone number from fulfillment data Phone Validator (Code Node) Intelligent phone number formatting: Detects country from shipping address Validates and cleans phone number Adds appropriate country code if missing Supports 23 countries across GCC, MENA, and international markets Ensures proper international format (+CountryCode) Get Customer Preferences Retrieves language preference and first name for personalization Language Detection Routes workflow based on customer's preferred language (Arabic vs. English) Test Number Filter Prevents notifications to internal/development phone numbers WhatsApp Notification Sends comprehensive shipping notification with tracking details in customer's language Supported Countries & Codes GCC Region: 🇴🇲 Oman (968) 🇦🇪 UAE (971) 🇸🇦 Saudi Arabia (966) 🇰🇼 Kuwait (965) 🇶🇦 Qatar (974) 🇧🇭 Bahrain (973) MENA Region: 🇯🇴 Jordan (962) 🇪🇬 Egypt (20) 🇮🇶 Iraq (964) 🇱🇧 Lebanon (961) 🇸🇾 Syria (963) 🇵🇸 Palestine (970) 🇾🇪 Yemen (967) International: 🇺🇸 USA (1) 🇬🇧 UK (44) 🇩🇪 Germany (49) 🇫🇷 France (33) 🇮🇹 Italy (39) 🇪🇸 Spain (34) 🇹🇷 Turkey (90) 🇮🇳 India (91) 🇵🇰 Pakistan (92) Message Templates Arabic Message (عربي): مرحبًا [الاسم]، يسرّنا إعلامكم بأنه تم شحن طلبكم بنجاح. رقم الطلب: [order_id] رقم التتبع: [tracking_number] شركة الشحن: [courier_name] رابط التتبع: [tracking_url] المدة المتوقعة للتوصيل: من 7 إلى 12 يوم عمل. يمكنكم متابعة حالة الشحنة عبر رقم التتبع، وسنحرص على إبقائكم على اطلاع حتى استلام الطلب. مع أطيب التحيات، English Message: Hello [Name], We are pleased to inform you that your order has been shipped successfully. Order No: [order_id] Tracking No: [tracking_number] Courier Company: [courier_name] Tracking URL: [tracking_url] Estimated delivery time: 7–12 business days. You may track your shipment using the tracking number provided. We will continue to keep you informed until your order is delivered. Kind regards, Database Schema Requirements Orders Table: CREATE TABLE orders ( order_id VARCHAR PRIMARY KEY, -- Shopify order number status VARCHAR, -- Order status ('open', 'shipped', 'delivered', 'canceled') shipping_company VARCHAR, -- Courier service name tracking_number VARCHAR, -- Package tracking ID customer_id INTEGER -- Foreign key to customers table ); Customers Table: CREATE TABLE customers ( id SERIAL PRIMARY KEY, website_id INTEGER, -- Shopify customer ID phone VARCHAR, -- Customer phone number language VARCHAR(2), -- Preferred language ('ar' or 'en') first_name VARCHAR, -- Customer first name last_name VARCHAR -- Customer last name ); Phone Validator Logic The Phone Validator node intelligently handles phone numbers: Extracts phone from fulfillment data (checks destination.phone, shipping_address.phone, or root phone) Detects country from destination.country_code (defaults to 'OM' if not provided) Cleans number by removing whitespace and non-numeric characters (except +) Validates length (minimum 5 digits required) Checks for country code in the number Adds country code automatically if missing based on shipping country Ensures + prefix for international format Returns: phone: Formatted number with country code (+XXX) original_phone: Raw input for reference country_code: ISO country code validation_status: 'success' or 'empty_or_invalid' Customization Tips Add more countries**: Extend the countryCodes object in Phone Validator node Change brand name**: Update "" / "" in WhatsApp message nodes Adjust delivery time**: Modify "7–12 business days" to match your actual shipping times Add more languages**: Create additional language detection branches (e.g., French, Spanish) Include product details**: Extend database query to fetch order items and include in message Add delivery date estimates**: Calculate and include specific delivery date ranges Email notifications**: Add email nodes for customers who prefer email SMS fallback**: Add SMS nodes for customers without WhatsApp Use Cases E-commerce stores shipping to multiple countries Luxury brands requiring premium communication Businesses with Arabic and English speaking customers International retailers with GCC and MENA presence Multi-channel sellers needing unified shipping notifications Stores using various courier services (DHL, FedEx, Aramex, etc.) Error Handling Empty phone numbers**: Workflow marks as 'empty_or_invalid' and skips notification Invalid formats**: Phone validator attempts to fix common issues Missing data**: Uses fallback values (e.g., 'OM' for country, 'en' for language) SQL injection protection**: Single quotes escaped in database queries Test number blocking**: Prevents accidental notifications during testing Performance Notes Execution time**: ~2-3 seconds per order Database queries**: 3 total (1 UPDATE, 2 SELECT) API calls**: 1 WhatsApp message per order Scalability**: Handles concurrent fulfillments independently Rate limits**: WhatsApp Business API applies standard rate limits Technical Notes WhatsApp API Version: v18.0 Phone API format: Country code without '+' (e.g., 962798087441) Database: PostgreSQL with prepared statements Default country: Oman (+968) Default language: English if not specified Workflow processes one fulfillment at a time (runOnceForEachItem) Tags: #shopify #whatsapp #fulfillment #shipping #tracking #bilingual #arabic #english #phone-validation #ecommerce #notifications #international

Shopify Collections to AI Blog Automation Pipeline This Shopify AI automation is an advanced n8n-powered workflow that transforms Shopify product collections into SEO-optimized blog articles with images, while maintaining full visibility and control through Google Sheets. It combines Shopify APIs, Google Sheets, AI research agents, AI content generation, and AI image creation to automate the entire collection-to-content lifecycle — from detecting collections to publishing blogs. Built for scalable ecommerce content automation, this workflow is ideal for stores with large or growing catalogs that want consistent, high-quality SEO content without manual effort. 🚀 Features 🗂️ Automatic Collection Tracking — Captures both existing and newly created Shopify collections 📊 Google Sheets as Control Center — Centralized tracking with clear statuses for every collection 🧠 AI-Powered Collection Research — Buyer intent, pain points, use cases, and SEO insights ✍️ Long-Form Blog Generation — Conversion-focused, structured blog articles in HTML 🖼️ AI Image Generation — Creates and uploads collection-specific images to Shopify 🛍️ Automated Blog Publishing — Publishes articles to Shopify and stores live URLs 🔁 Fully Auditable Workflow — Every step is logged and updated back into Google Sheets 🧩 Workflow Preparation Before running the workflow: Ensure Shopify Admin API access is enabled Prepare a Google Sheet with required columns (id, title, handle, description, status, etc.) Decide your content workflow statuses (pending, generated, sent for approval, posted) Create or identify the Shopify blog where articles will be published This setup allows both manual control and fully automated execution. ⚙️ How It Works The workflow supports multiple triggers and follows a structured, production-safe pipeline. Notes: You can run this workflow manually, schedule it, or let it react automatically to new Shopify collections. 🔄 Step-by-Step Process Step 1: Collect Shopify Collection Data Fetches all existing collections via Shopify GraphQL Listens for newly created collections via Shopify trigger Normalizes collection data (ID, title, handle, description, updated time) Stores everything in Google Sheets with clear type labels Step 2: Select Pending Collections Filters collections marked as pending Processes items in controlled batches to avoid API limits Ensures safe and repeatable execution Step 3: AI Research & Buyer Intent Analysis AI analyzes each collection from a buyer and SEO perspective Identifies problems, motivations, objections, and search intent Outputs structured research JSON for downstream use Step 4: AI Blog Content Generation Converts research into long-form, conversion-focused blog articles Generates titles, sections, FAQs, tags, and image prompts Outputs Shopify-ready HTML content Step 5: AI Image Generation & Shopify Upload Generates collection images using AI Uploads images to Shopify using staged uploads Retrieves CDN URLs and maps them back to content Step 6: Publish Blog & Update Sheet Publishes the final article to the Shopify blog Writes the live article URL back to Google Sheets Updates status to reflect completion 🛠️ n8n Nodes Used Manual Trigger / Schedule Trigger / Shopify Trigger Shopify (GraphQL + REST via HTTP Request) Google Sheets AI Agent Nodes (Research, Writing, Image Generation) IF / Switch Nodes (Status & logic handling) Split In Batches (Controlled processing) Code Nodes (HTML structuring and replacements) 🔐 Credentials Required Before running the workflow, configure the following credentials in n8n: Shopify Admin API Access Token Google Sheets OAuth Google Gemini API (text + image models) 👤 Ideal For This workflow is ideal for: Shopify stores with many product collections Ecommerce teams scaling SEO content production Agencies building Shopify content automation systems Businesses replacing manual blog writing with AI-driven workflows 💬 Extensibility This workflow is modular and easy to extend. You can add: Multi-language blog generation Internal linking automation Category-specific content logic Approval workflows before publishing Social or email promotion triggers after publishing 🔑 Keywords shopify ai workflow shopify blog automation shopify marketing automation shopify automation ecommerce automation how to automate shopify blog 📌 Notes No AI fine-tuning required Research-driven, not promotional AI writing Designed for accuracy, traceability, and scale Safe for production ecommerce environments

Import products from Faire to Shopify using BrowserAct, Gemini and Telegram This workflow acts as an automated dropshipping assistant. It allows you to send product links from Faire.com to a Telegram bot, which then scrapes the product data, rewrites it for SEO using AI, and imports it directly into your Shopify store—handling images, pricing, and descriptions automatically. Target Audience Dropshippers, e-commerce store owners, and inventory managers sourcing products from Faire. How it works Receive Link: You send a Faire product URL to your Telegram bot. Analyze Input: An AI Agent classifies your message to determine if it's a product import request or just a chat. Scrape Product: BrowserAct executes a background task to scrape the product's title, description, price, and images from the provided URL. Human Verification (CAPTCHA): If the scraper hits a CAPTCHA, the workflow pauses and alerts you on Telegram. Once you solve it, the workflow resumes automatically. AI Enhancement: A second AI Agent (using Google Gemini) rewrites the product title and description to be SEO-friendly and sales-oriented, formatting it in HTML. Sync to Shopify: The workflow creates the product in Shopify, adds the correct variant pricing/SKU, and uploads all scraped images. How to set up Configure Credentials: Connect your Telegram, Shopify, BrowserAct, and Google Gemini accounts in n8n. Prepare BrowserAct: Ensure the Product Importer Bot for Shopify template is saved in your BrowserAct account. Configure Telegram: Ensure your bot is created via BotFather and the API token is added to the Telegram credentials. Activate: Turn on the workflow. Test: Send a Faire product link to your bot to start the import process. Requirements BrowserAct* account with the Product Importer Bot for Shopify* template. Shopify** account (Access Token with write_products permission). Telegram** account (Bot Token). Google Gemini** account. How to customize the workflow Change Pricing Logic: Add a Set node before the "Add Price" node to increase the scraped price by a percentage (markup) before importing. Translate Content: Modify the system prompt in the Analyzing Products agent to translate the description into another language during the rewrite. Add More Fields: Update the Analyzing Products agent to extract additional data like "Material" or "Dimensions" and map them to Shopify Metafields. Need Help? How to Find Your BrowserAct API Key & Workflow ID How to Connect n8n to BrowserAct How to Use & Customize BrowserAct Templates Workflow Guidance and Showcase Video How to Build a Shopify Product Importer with n8n & BrowserAct (No-Code)

How It Works Consolidates daily revenue from Stripe, PayPal, Shopify, and bank feeds into a single system. The workflow automatically normalizes data across payment sources, uses AI to categorize income transactions, calculates reporting-period totals, and generates tax-compliant CSV and XML submissions. Designed for e-commerce businesses, SaaS companies, and multi-channel retailers managing complex revenue streams, it eliminates manual reconciliation, reduces filing errors, and speeds up financial reporting by automating the entire pipeline from data collection to government submission. Setup Steps Connect Stripe/PayPal/Shopify accounts with API keys to respective nodes. Configure bank feed authentication Set OpenAI credentials for AI Income Categorizer node. Link Google Drive and Gmail Add government tax API endpoint and authentication credentials. Prerequisites Stripe, PayPal, Shopify, or bank APIs; OpenAI account; Google Workspace; Use Cases Quarterly tax preparation for e-commerce; multi-channel revenue reconciliation; Customization Modify normalization rules per jurisdiction; add expense categories to AI prompt; Benefits Eliminates manual reconciliation; reduces tax filing time by 80%; improves accuracy;

How It Works This workflow automates monthly revenue aggregation from multiple financial sources, including Stripe, PayPal, Shopify, and bank feeds, while delivering intelligent tax forecasting through GPT-4–based structured analysis. It systematically retrieves revenue data, consolidates disparate datasets into a unified view, and applies GPT-4 to predict upcoming tax obligations with greater accuracy. The system then generates clearly formatted, audit-ready reports and automatically distributes tax projections to designated agents via Gmail, while securely storing all outputs in Google Sheets to maintain traceable audit trails. Designed for tax professionals, accounting firms, and finance teams, it enables accurate predictive tax planning and supports a proactive compliance strategy without the need for manual calculations or spreadsheet-driven analysis. Setup Steps Connect Stripe, PayPal, Shopify credentials via n8n authentication. Configure OpenAI GPT-4 API key for structured tax analysis. Connect Gmail account for report distribution and Google Sheets. Set monthly trigger schedule and customize tax category rules. Prerequisites Stripe, PayPal, Shopify, or bank feed accounts; OpenAI API key; Gmail account; Google Sheets. Use Cases Accounting firms automating quarterly tax prep for multiple clients Customization Modify revenue sources, adjust GPT-4 prompts for specific tax scenarios Benefits Eliminates manual tax calculations, reduces forecasting errors

AI Powered Blog Automation for Shopify >Watch the Youtube Tutorial Video Transform Your Shopify Store with Automated, AI Generated Blog Content Stop struggling with content creation. This n8n workflow automatically generates high quality, SEO optimized blog posts for your Shopify store every single day while you focus on growing your business. See It In Action: Real Results from Pink Matcha Visit Pink Matcha Blog - A real Shopify store powered by this exact workflow. Real Traffic, Real Results 50+ SEO optimized articles** published automatically Consistent daily content** without hiring writers Multiple categories** with targeted content Professional formatting** that converts visitors to customers What You're Getting ✅ Automated Content Generation AI creates unique articles** from curated industry sources SEO optimized** with proper headings, keywords, and meta descriptions 800 to 1200 words per article** with actionable insights Plagiarism free** content that ranks in Google ✅ Multi Category Organization Fitness, Nutrition, Wellness, Personal Growth, or YOUR niche Each category gets targeted, relevant content Build authority across your entire product range Cross sell opportunities through strategic content ✅ Direct Shopify Integration One click publishing** to your Shopify blog Professional HTML formatting Automatic categorization SEO metadata included Draft or publish modes ✅ Multi Blog Support Manage multiple blogs** within the same Shopify store Create separate blogs for different product lines or audiences Each blog can have its own RSS feeds and categories Run workflows independently or simultaneously ✅ Smart Product Integration Automatically embed product links** within articles AI intelligently references relevant products from your catalog Include product cards, images, and CTAs Drive traffic directly to product pages Turn readers into buyers with strategic product placement ✅ AI Generated Featured Images Automatically creates branded images** for every blog post AI generates custom visuals that match your brand style Include your logo or signature products in every image Customizable style instructions for perfect brand consistency No need for stock photos or graphic designers Every article gets a unique, professional featured image ✅ Smart Content Intelligence MongoDB vector search** prevents duplicate topics Sources content from trusted RSS feeds in your niche Learns your brand voice Maintains consistency across all articles 🔥 Game Changing Features Multiple Blogs, One Workflow Run multiple blogs within the same Shopify store: Create separate blogs for different product lines (e.g., Men's vs Women's, Premium vs Budget) Target different audiences with customized content strategies Each blog has its own RSS feeds, categories, and publishing schedule Manage everything from a single n8n instance Perfect for multi brand stores or diverse product catalogs Example Use Cases: Fashion Store**: Separate blogs for Men, Women, Kids, and Accessories Wellness Store**: Different blogs for Fitness, Nutrition, Mental Health, and Supplements Tech Store**: Blogs for Gadgets, Software Reviews, How To Guides, and Industry News Intelligent Product Integration AI automatically embeds your products within blog content: Analyzes article topics and matches relevant products from your catalog Inserts product cards with images, descriptions, and "Buy Now" buttons Creates contextual product mentions throughout the article Links to product pages to drive direct sales Customizable product placement rules Turn Every Article Into a Sales Machine: Blog post about "Best Workout Routines" → Automatically includes your yoga mats, resistance bands, and protein powder Article on "Winter Skincare Tips" → Embeds your moisturizers, serums, and face masks Guide to "Home Office Setup" → Features your desk organizers, chairs, and lighting products AI Generated Featured Images with Brand Consistency Every article gets a unique, professionally designed featured image: AI generates custom images matching your brand aesthetic Automatically includes your logo or signature product in each image Configure your brand style once, AI applies it to all future images Customizable image generation instructions for perfect consistency Wide, natural looking scenes (no generic stock photo vibes) No need for Canva, designers, or stock photo subscriptions How It Works: Configure your Branding Logo (product image or logo URL) Set your Branding Style ("Image should contain a girl holding this drink") Define Image Style guidelines ("Wide, natural scene with no square framing") AI automatically generates unique images for each article topic Images are uploaded to Shopify and set as featured images Example: Article: "5 Morning Rituals for Better Energy" Generated Image: Wide, natural scene of a person holding Pink Matcha drink during sunrise, perfectly matching your brand aesthetic No more spending hours on: Finding stock photos Editing images in Canva Ensuring brand consistency Resizing for different platforms Worrying about image licensing Why Store Owners Love This Workflow 💰 Save Thousands on Content Creation Traditional Approach: Freelance writers: $100 to 300 per article 30 articles/month = $3,000 to 9,000/month Plus time for editing, SEO, uploading, formatting With This Workflow: $30 to 60/month** in API costs Unlimited articles Zero manual work Save $2,940 to 8,940 per month** ⏰ Reclaim Your Time Before: 4 to 6 hours writing each article 2 hours researching topics 1 hour formatting and uploading 7+ hours per article** After: Click one button AI generates, formats, and publishes 0 hours of your time** 📈 Grow Your Organic Traffic Fresh content signals to Google you're active More pages = more chances to rank Long tail keywords across every article Internal linking boosts your entire site 🎯 Perfect for E commerce Educational content** that supports your products How to guides** featuring your items Category pages** that drive purchase decisions Build trust** before customers buy Live Examples from Pink Matcha Fitness Content Nutrition Content Self Care Content Personal Growth Content Every single one of these articles was generated automatically by this workflow. Perfect For Every Shopify Store 🏋️ Health & Wellness Brands Generate workout tips, nutrition guides, supplement education, and wellness advice that positions your products as solutions. 👗 Fashion & Apparel Create style guides, trend reports, outfit inspiration, and care instructions that showcase your clothing line. 🏠 Home & Lifestyle Produce decorating tips, organization hacks, product care guides, and seasonal content that drives home goods sales. 💄 Beauty & Skincare Develop routine guides, ingredient education, application tutorials, and trend analysis that supports cosmetics sales. 🎮 Hobbies & Collectibles Write product reviews, how to guides, industry news, and collector tips that engage enthusiasts. 📱 Tech & Gadgets Generate setup guides, comparison articles, tech news, and troubleshooting content for electronics stores. What's Included in Your Purchase 4 Complete n8n Workflows Shopify Blog Automation - The core automation engine Gemini Image Generator Tool - AI powered featured image creation with brand consistency Web Search Tool - Real time web research using OpenAI GPT 4O Search Link Validator Tool - Ensures all URLs work before publishing Complete Documentation Step by step setup guide** (Technical Setup.md) Video walkthrough** (coming soon) Google Sheets templates** for RSS feeds and categories Example configurations** for multiple niches Lifetime Access & Updates All future workflow improvements New features as they're released Updated documentation Priority email support How It Works (Simple 3 Step Process) Step 1: Configure Your RSS Feeds Add trusted content sources from your industry into a Google Sheet. The workflow monitors these for fresh content daily. Step 2: AI Generates Unique Articles Google Gemini reads source articles, understands your niche, and creates completely original blog posts optimized for SEO and your brand voice. Step 3: Auto Publish to Shopify Articles are automatically formatted, categorized, and published to your Shopify blog—no manual work required. That's it. Your blog grows on autopilot. Technical Specs (For the Curious) AI Content Engine**: Google Gemini for blog content generation AI Image Engine**: Google Gemini 3 Pro Image Preview (16:9 branded images) Web Search**: OpenAI GPT-4O SEARCH PREVIEW for real time research Vector Search**: MongoDB Atlas (prevents duplicate topics) Embeddings**: OpenAI text-embedding-3-small for semantic matching Platform**: n8n workflow automation Integration**: Native Shopify Admin API & OAuth2 Social**: Auto post to Twitter (optional) Scalability**: 1 to 10+ articles per day with custom featured images Full technical documentation included with purchase. Frequently Asked Questions Q: Do I need coding skills? A: No! Import the workflows, configure your credentials, and you're ready. Full setup guide included (~60 to 90 minutes). Q: What are the monthly costs? A: ~$30 to 60/month (Google Gemini API + OpenAI + MongoDB free tier + n8n self to hosted). Way cheaper than hiring writers. Q: How many articles can it generate? A: Unlimited. Run it daily for 30 to 90 articles/month, or adjust frequency to your needs. Q: Will the content be unique? A: 100% original. AI creates new content inspired by sources, never copies. Vector search prevents duplicate topics. Q: Can I use this for my niche? A: Yes! Works for ANY niche. Just configure your RSS feeds and categories. Tech, fashion, home, beauty, gaming—anything. Q: Does it work with WordPress or other platforms? A: This version is built for Shopify. The workflow can be adapted for WordPress, Ghost, Medium, or custom sites. Q: How long are the articles? A: Configurable. Default is 800 to 1200 words. Adjust AI prompts for shorter (500w) or longer (2000w+) content. Q: Can I review articles before publishing? A: Yes! Set to "draft" mode, review in Shopify, edit if needed, then publish manually. Q: What languages does it support? A: Google Gemini supports 100+ languages. Configure the AI prompts to generate content in your target language. Q: What's your refund policy? A: No refunds. Please review this page and the live examples before purchasing. Still Not Sure? See The Results Visit pinkmatcha.co to see this workflow in action. Every article. Every category. All automated. Read the articles. Check the formatting. See the SEO optimization. Experience the quality. Then imagine this running on YOUR Shopify store. Questions? We're Here to Help 📧 Email: [email protected] 💬 Community: Join our Skool 📚 Documentation: Comprehensive guides included 🎥 Videos: Setup tutorials (coming soon) About emp0 We build production ready n8n automation workflows used by hundreds of businesses worldwide. Our workflows save companies thousands of hours and tens of thousands of dollars every month. 🛍️ Premium Workflows: store.emp0.com 🆓 Free Workflows: emp0.com/automation-workflows 🐦 Twitter: @emp0_com 🎯 Live Example: Pink Matcha Blog Don't Let Your Competitors Outrank You While you're manually writing one blog post per week, your competitors could be publishing daily with AI automation. Every day you wait is another day without: Fresh SEO content ranking in Google Educational articles converting visitors Authority building thought leadership Traffic flowing to your products The solution is one click away. Powered by n8n • Google Gemini • OpenAI • MongoDB • Shopify

This workflow automates inventory management and predictive reordering for Shopify stores. It integrates Shopify, Google Sheets, and Slack to monitor inventory levels, calculate dynamic reorder points based on sales velocity, and automate supplier communication. The workflow helps prevent stockouts, reduces overstock, and streamlines the purchase order process with minimal manual intervention. Key Features Automated Inventory Monitoring:** Fetches real-time inventory, product, and order data from Shopify and Google Sheets. Predictive Reordering:** Calculates sales velocity and dynamic reorder points for each SKU. Supplier Communication:** Automatically generates and sends purchase orders (POs) to suppliers via email or API. Multi-Warehouse Logic:** Checks for possible stock redistribution before triggering new orders. Business Rule Enforcement:** Applies custom rules (MOQ, budget, business days, approval thresholds). Real-Time Alerts:** Notifies stakeholders via Slack about critical stock risks and slow-moving products. Comprehensive Logging:** Updates purchase order logs and analytics dashboards for full traceability. How to Configure Shopify Integration Create a Shopify Private App and obtain your API credentials (API key, password, and store URL). In n8n, set up Shopify credentials using these details. Google Sheets Integration Prepare three Google Sheets: Inventory Master: Contains SKU, product details, and ideal stock levels. Suppliers: Contains supplier contact information and SKU mapping. Purchase Order Log: Tracks all generated POs. Share these sheets with the Google account connected to n8n and set up Google Sheets credentials. Slack Integration Create a Slack Incoming Webhook for the channel where you want to receive alerts and summaries. Add the webhook URL to the relevant Slack nodes in the workflow. Supplier Communication For email: Configure the Email node with your SMTP credentials and supplier email addresses. For API: Set up HTTP Request nodes with supplier API endpoints and authentication as required. Workflow Parameters Adjust configuration nodes to set business rules such as: Reorder point multipliers Safety stock days Budget limits Minimum order quantities (MOQ) Approval thresholds Scheduling The workflow is set to run hourly by default. Adjust the trigger node as needed. Testing Run the workflow manually with test data to ensure all integrations and logic work as expected before enabling automation. How It Works Trigger: Runs automatically on an hourly schedule. Configuration: Sets business parameters (Shopify URL, reorder multipliers, safety stock days, budget, etc.). Data Collection: Retrieves inventory, product details, and recent orders from Shopify. Reads inventory master, supplier list, and PO log from Google Sheets. Data Merging: Combines all sources into a unified SKU-level dataset. Sales Velocity Calculation: Computes 7/30-day sales velocity for each SKU. Dynamic Reorder Point: Calculates reorder points based on sales velocity, lead time, and safety stock. Reorder Check: Identifies SKUs below their reorder point. Stockout Risk Assessment: Flags SKUs at high risk of stockout and sends Slack alerts. Warehouse Redistribution: Attempts to balance stock between warehouses before reordering. Supplier Data Enrichment: Adds supplier info and checks availability. Business Rule Checks: Validates business day, MOQ, promotional periods, budget, and approval needs. Order Calculation: Determines optimal order quantities and prioritizes by profitability. PO Structuring: Prepares PO line items and context for supplier communication. PO Dispatch: Sends PO via email or API to the supplier. PO Confirmation & Logging: Waits for confirmation and updates the PO log in Google Sheets. Slow-Mover Detection: Identifies slow-selling SKUs and sends actionable Slack suggestions. Inventory Update: Syncs inventory changes back to Shopify. Analytics & Reporting: Updates dashboards, scenario planning sheets, and accounting systems. Daily Summary: Aggregates and sends a daily activity summary to Slack. Example Use Case A Shopify retailer uses this workflow to automate inventory management. Every hour, the workflow checks current stock and sales trends, predicts which products are at risk of running out, and automatically creates purchase orders for suppliers. If a product is selling slowly, the system notifies the team with suggestions for discounts or bundling. All actions are logged and summarized daily, ensuring the team stays informed and inventory is always optimized. Prerequisites Shopify account with API access Google Sheets with inventory, supplier, and PO log sheets Slack workspace and webhook for notifications Supplier email/API endpoints for PO dispatch Limitations & Notes Customization may be required for specific business rules or supplier integrations. Ensure API credentials and sheet structures match the workflow’s configuration. Multi-warehouse logic assumes accurate warehouse-level inventory data. If you need further customization or have specific requirements for your business logic, adjust the configuration and node parameters accordingly.

Who’s it for This template is designed for Print-on-Demand (POD) business owners, independent artists, and e-commerce managers who want to automate the process of turning raw design files into listed products without manual data entry. How it works This workflow acts as an automated merchandise factory that handles everything from image processing to marketing. Trigger: The workflow starts when a new design file is uploaded to a specific Google Drive folder. Analyze: OpenAI Vision analyzes the image to determine the subject, mood, and color palette, and assesses copyright risk. Process: The image background is removed using Remove.bg, and the clean asset is uploaded to Cloudinary. Mockup: The workflow generates realistic product mockups (e.g., T-shirts, Tote bags) by overlaying the design onto base product images using Cloudinary transformations. Copywriting: OpenAI writes an SEO-friendly product title, description, and tags based on the visual analysis. Draft: A draft product is created in Shopify with the generated details and mockup image. Approval: A message is sent to Slack with the product details and mockup. The workflow pauses and waits for a human to click "Approve" or "Reject". Publish & Promote: If approved, the product is published to Shopify and automatically posted to Instagram and Pinterest. If rejected, a notification is sent to Slack. How to set up Base Images: Upload your blank product images (e.g., a white t-shirt, a tote bag) to your Cloudinary account and note their Public IDs. Configuration: Open the Workflow Configuration node and fill in all the required fields, including your API keys and the Cloudinary Public IDs for your base products. Credentials: Configure the credentials for Google Drive, OpenAI, Shopify, Slack, Instagram, and Pinterest in their respective nodes. Folder ID: Update the Google Drive Trigger node with the ID of the folder you want to watch. Requirements n8n (Self-hosted or Cloud) Google Drive account OpenAI API key (Access to GPT-4o model recommended for Vision capabilities) Remove.bg API key Cloudinary account Shopify store Slack workspace Instagram Business account Pinterest account How to customize Mockups: You can modify the Code - Generate Mockup URLs node to add more product types (e.g., Hoodies, Mugs) by adding their Cloudinary Public IDs. Prompt Engineering: Adjust the system prompt in the OpenAI - SEO Copywriting node to match your brand voice or language style. Social Channels: Add or remove nodes to support other platforms like Twitter (X) or Facebook Pages.

How it works The workflow triggers on a new checkout event from Shopify and extracts all relevant cart data. It filters carts based on value and age to isolate qualified abandoned checkouts. For each qualified cart, it sends a follow-up email, updates or creates the corresponding HubSpot contact, and generates a CRM note linked to that contact. Finally, it logs the processed cart into Google Sheets for tracking and review. Step-by-step Trigger on new Shopify checkout** Shopify Trigger – Starts the workflow when a new checkout is created. Normalize and structure cart data** Parse Cart Data – Extracts email, customer name, items, cart totals, timestamps, and hours since creation. Filter carts that meet follow-up criteria** Filter Qualified Carts – Passes only carts older than 12 hours and valued above 50. Send follow-up message** Send a message – Delivers a reminder email to the customer about the pending checkout. Create or update CRM contact** Create or update a contact – Ensures the shopper exists as a HubSpot contact. Prepare CRM note details** Generates Note Data – Builds a structured note containing timing, cart details, and follow-up context. Create the HubSpot note** Create HubSpot Note – Submits the prepared note to HubSpot’s CRM. Associate note with the contact** Associate Note with Contact in HubSpot – Links the generated note to the correct HubSpot contact. Record activity in tracker sheet** Log to Google Sheets – Appends processed cart fields including items, totals, timestamps, and customer info. Why use this? Identifies high-value or long-abandoned carts automatically and follows up without manual effort. Keeps CRM records updated and adds contextual notes sales teams can act on. Maintains a structured audit trail of every abandoned cart interaction. Improves recovery chances by combining email outreach with CRM enrichment and logging. Enables analysis of abandoned checkout patterns directly from Google Sheets.

How it works This workflow listens for new products in Shopify and transforms the product data into polished social media content. It generates captions and hashtags using an AI model, then posts the product to Instagram and Facebook using the Facebook Graph API. It logs every post to Google Sheets and sends a confirmation message to Discord. The flow ensures consistent publishing across all platforms with automated formatting and tracking. Step-by-step Trigger on Shopify product creation** Shopify Trigger – Activates when a new product is added to the store. Prepare product data** parse product data – Extracts product name, price, description, URL, image, and timestamp. Generate caption and hashtags** Generate caption and hashtags – Uses an AI model to craft a caption and produce 10 relevant hashtags. Configure posting parameters** Set Configuration – Stores access tokens, platform IDs, caption text, hashtags, and image URL. Publish to Instagram** Create Instagram Media Container – Sends the image and caption to create a media container. Wait for Processing – Waits for the container to finish processing. Publish Instagram Media – Publishes the processed container to the Instagram feed. Publish to Facebook** Download Image for Facebook – Downloads the product image from Shopify. Post to Facebook Page – Uploads the image with the caption and hashtags to the Facebook Page. Merge publishing results** Merge – Combines responses from Instagram and Facebook for unified logging. Log post to Google Sheets** Log Product Post Data – Appends product info, caption, and hashtags to a spreadsheet. Notify via Discord** Notify Discord About Post – Sends a message summarizing the published product. Why use this? Ensures every new Shopify product is promoted instantly across major social platforms. Eliminates manual posting and caption creation with reliable automation. Maintains centralized logging for auditing, tracking, or analytics. Provides real-time team notifications to confirm successful posts. Reduces errors and keeps brand messaging consistent across channels.

Summary Re-engage your customers with your Shopify store through a personalized contact sequence. How it works The workflow is triggered by a Scheduler Trigger and immediately reviews your Shopify customers by retrieving their last_order_id. For customers with a non-null last_order_id, the workflow proceeds to fetch detailed order information from Shopify, including the order closing date and the products involved. Based on the order date, the workflow calculates the number of days the customer has been inactive. If this period exceeds a defined threshold (e.g., 30 days), the corresponding records are sent via API to Beex, where each customer enters a multi-step contact sequence that may include WhatsApp, email, and other channels. Example: "Customers can then expect to receive a limited-time discount coupon invitation as part of the reactivation strategy". How to set up Before importing the template, make sure to install the Beex node using the following package name: n8n-nodes-beex Configure your Shopify credentials according to your store’s settings. You will need to provide: Your store subdomain Your Access Token Your App Secret Key For Beex users with platform access (if you need a trial, please contact [email protected]), go to the main dashboard and navigate to: Platform Settings → API KEY & Callback There, you can retrieve your API key and insert it into the corresponding Beex node within n8n. Requirements You need accounts for: Beex (omnichannel contact platform) Shopify (E-commerce platform builder) You need in Beex (Node): Portfolio ID Sequence ID The above determines the sequence of contact that customers are subjected to. How to customize You can also change the threshold to define from what extent you consider that a client is inactive. You can configure a particular sequence in Beex to contact your inactive customers to insert them into the node.

Shopify Order Fulfillment & Send Tracking Link via WhatsApp Using Rapiwa API Who is this for? This n8n workflow automatically sends WhatsApp notifications to customers when their Shopify orders are fulfilled. It extracts order details, validates customer phone numbers for WhatsApp compatibility using the Rapiwa API, sends tracking information via WhatsApp, and logs all interactions in Google Sheets with appropriate verification status. What this Workflow Does This n8n workflow listens for new order fulfillments on Shopify and automatically sends a WhatsApp message with tracking details to customers. It uses the Rapiwa API to verify if the customer's number is on WhatsApp, formats all the data, sends a message, and logs everything to Google Sheets for tracking and auditing purposes. Key Features Webhook-Triggered**: Activates on new Shopify fulfillment events Phone Number Validation**: Uses Rapiwa to check WhatsApp compatibility Tracking Message Automation**: Sends real-time tracking messages via WhatsApp Data Cleaning**: Formats phone numbers and customer data Smart Branching**: Separates verified and unverified WhatsApp users Google Sheets Logging**: Stores data with status labels for all messages Rate-Limit Protection**: Wait node helps space API calls Dual Sheet Logging**: Maintains separate records for verified and unverified numbers Requirements Tools & Services An n8n instance (self-hosted or cloud) A Shopify store with REST API access enabled A Rapiwa.com account with: Valid Bearer Token Connected and verified WhatsApp number A Google Sheet with the following columns: Like this Sample Sheet Google Sheets OAuth2 credentials** set up in n8n Shopify API credentials** added to n8n Rapiwa Bearer Token** added as httpBearerAuth credentials How to Use Step-by-step Setup Connect Shopify to n8n Use the Shopify Trigger node Set event to fulfillments/create to capture new fulfillment events Extract Webhook Data Use a Code Node to format the webhook response Capture order, customer, and tracking details Fetch Complete Order Information Add an HTTP Request Node using Shopify Admin API Include the order ID to retrieve customer phone, email, and product details Clean the Phone Number Use a Code Node to: Remove non-numeric characters Format number to international standard Combine customer first and last name Batch Process Orders Use the Split In Batches node to handle customers one-by-one Validate WhatsApp Number Use Rapiwa’s /verify-whatsapp endpoint with a Bearer Token Check if number exists on WhatsApp Conditional Branching Use an If Node: If data.exists === "true" → Verified path Else → Unverified path Send WhatsApp Message Send tracking info with a personalized message: Hi [Customer Name], Good news! Your order has just been fulfilled. Tracking Number: [Tracking Number] Track your package here: [Tracking URL] Thank you for shopping with us. -Team SpaGreen Creative Log Data to Google Sheets Log verified and unverified entries in separate sheets Include all relevant customer and tracking data Add Delay Between Messages Use the Wait Node to avoid rate limits on Rapiwa API Requirements A Shopify store with API access enabled A Google Sheet with required column like this ➤ Sample Rapiwa API account**: Connected WhatsApp number Valid Bearer Token n8n** with: Shopify API credentials Rapiwa Bearer Token Google Sheets OAuth2 credentials Google Sheet Column Reference A Google Sheet formatted like this ➤ Sample | customer_id | name | email | number | tracking_company | tracking_number | tracking_url | product_title | status | |---------------|-----------------|--------------------------------|---------------|------------------|-----------------|---------------------------------------------|----------------------------------------|------------| | 8986XXXX06 | Abdul Mannan | [email protected] | 8801322827799 | Amazon Logistics | SG-OT-02 | https://traxxxG-OT-02 | S25 Ultra 5G Smartphone | verified | | 883XXX7982 | Abdul Mannan | [email protected] | 8801322827799 | Amazon Logistics | SG-OT-N03 | https://traxxxGOT-N03| Samsung Galaxy S24 Ultra | verified | Workflow Logic Summary Shopify Webhook Trigger: On order fulfillment Extract Webhook Payload Fetch Order + Customer Details Clean and Format Phone Number Split into Single-Item Batch Check WhatsApp Validity via Rapiwa If Verified: Send WhatsApp Message Log to verified sheet If Not Verified: Skip message Log to unverified sheet Add Delay with Wait Node Repeat for Next Fulfillment Customization Ideas Modify WhatsApp message to include delivery date or store contact Send different messages for different product categories Use product_type or shipping_zone to trigger separate workflows Add admin alerts for unverified numbers Store message delivery status (e.g., success, failed) Notes & Warnings Rapiwa is an unofficial WhatsApp API — delivery reliability is not guaranteed The Google Sheet column name must include the space at the end Wait node** may need longer delay for high-volume stores Always format phone numbers in international format (e.g., 8801XXXXXXXXX) Shopify API version used is 2025-07 — update as newer versions release You must comply with WhatsApp terms and data privacy laws when messaging users Useful Links Dashboard:** https://app.rapiwa.com Official Website:** https://rapiwa.com Documentation:** https://docs.rapiwa.com Support WhatsApp Support: Chat Now Discord: Join SpaGreen Community Facebook Group: SpaGreen Support Website: https://spagreen.net Developer Portfolio: Codecanyon SpaGreen

This AI Blog Generator is an advanced n8n-powered automation workflow that leverages Google Gemini and Google Sheets to generate SEO-friendly blog articles for Shopify products. It automates the entire process — from fetching product data to creating structured HTML content — with zero manual effort. 💡 Key Advantages Our AI Blog Generator offers five core advantages that make it the perfect solution for automated content creation: 🔗 Shopify Product Sync** — Automatically pulls product data (titles, descriptions, images, etc.) via Shopify API. ✍️ SEO Blog Generation** — Gemini generates blog titles, meta descriptions, and complete articles using product information. 🗂️ Structured Content Output** — Creates well-formatted HTML with headers and bullet points for seamless Shopify blog integration. 📄 Google Sheets Integration** — Tracks blog creation and prevents duplicate publishing using a centralized Google Sheet. 📤 Shopify Blog API Integration** — Publishes the generated blog to Shopify with a single API call. ⚙️ How It Works The workflow follows a systematic 8-step process that ensures quality and efficiency: Step-by-Step Process Manual Trigger – Start the workflow via a test trigger or scheduler. Fetch Products from Shopify – Retrieves all product details, including images and descriptions. Fix Input Format – Organizes and updates the input table using Code and Google Sheet nodes. Filter Duplicates – Ensures no previously used rows are processed again. Limit Control – Processes one row at a time and loops until all blogs are posted. Gemini AI Generation – Creates SEO-friendly blog content in HTML format from product data. HTML Structure Fix – Adjusts content for JSON compatibility by cleaning unsupported HTML tags. Article API Posting – Sends finalized blog content to Shopify for publishing or drafting. 🛠️ Setup Steps Required Node Configuration To implement this workflow, you'll need to configure the following n8n nodes: Trigger Node:** Start the workflow instantly. Shopify Node:** Fetch product details. Google Sheet Node:** Store input/output data and track blog creation status. Code Node:** Format data as required. Filter Node:** Remove used rows to avoid duplication. Limit Node:** Process one blog at a time. Agent Node:** Sends prompt to Gemini and returns parsed SEO-ready content. HTTP Node:** Posts content to Shopify via the API. 🔐 Credentials Required Authentication Setup Before running the workflow, ensure you have the following credentials configured: Shopify Access Token** – For fetching products and posting blogs Gemini API Key** – For AI-powered blog generation Google Sheets OAuth** – For logging and tracking workflow data 👤 Ideal For Target Users This automation workflow is specifically designed for: Ecommerce teams** automating blogs for hundreds of products Shopify store owners** boosting organic traffic effortlessly Marketing teams** building scalable, AI-driven content workflows 💬 Bonus Tip Extensibility Features The workflow is fully modular and highly customizable. You can easily extend it for: Internal linking** between related products Multi-language translation** for global markets Social media sharing** automation Email marketing** integration All extensions can be implemented within the same n8n flow, making it a comprehensive content automation solution.

The AI-Powered Shopify SEO Content Automation is an enterprise-grade workflow that transforms product content creation for e-commerce stores. This sophisticated multi-agent system integrates GPT-4o, Claude Sonnet 4, Claude 3.5, Perplexity AI, and Haloscan keyword research to generate SEO-optimized product descriptions, metafields, and meta descriptions with zero manual intervention and built-in cannibalization prevention. To see the demo connect via my profile profile 💡 Key Advantages 🎯 Multi-Agent AI Orchestration Central Orchestrator manages complex workflows with specialized agents for descriptions, metafields, and SEO, each optimized for specific content types. 🔍 Advanced Keyword Research & Cannibalization Prevention Integrates Haloscan API for premium keyword discovery and SERP overlap analysis to prevent keyword cannibalization across your product catalog. 📊 Enterprise SEO Optimization Specialized for e-commerce with semantic alignment, TF-IDF optimization, and compliance with industry regulations and best practices. 🧠 Intelligent Content Strategy Perplexity AI provides market intelligence, search intent analysis, and trending keyword discovery for data-driven content decisions. 🏗️ Comprehensive Content Generation Creates product descriptions, 6 specialized metafields, SEO meta descriptions, and rich text formatting for complete Shopify integration. 📋 Automated Workflow Management Airtable integration tracks content creation status, manages keyword databases, and provides centralized workflow control. ⚙️ How It Works Content Type Selection Form-based trigger allows selection of content types: create_product_description, create_product_meta, or create_product_seo. Product Data Collection Retrieves comprehensive product information from Shopify and Airtable, including titles, descriptions, handles, and vendor details. Premium Keyword Discovery Haloscan API analyzes product titles for keyword opportunities Extracts search metrics, competitor keywords, and SERP data Perplexity provides market intelligence and search intent analysis SEO Compliance Checking Performs SERP overlap analysis to identify existing rankings Filters keywords to prevent cannibalization Updates Airtable with curated keyword lists Generates actionable SEO content strategies Multi-Agent Content Generation Product Description Agent (Claude Sonnet 4): Generates SEO-optimized product descriptions with verified facts Implements strict HTML structure with proper heading hierarchy Ensures compliance with e-commerce regulations and best practices Meta Fields Agent (Claude Sonnet 4): Creates 6 specialized metafields: ingredients, recommendations, nutritional values, warnings, short descriptions, and client arguments Enforces strict formatting rules and regulatory compliance Generates clean HTML compatible with Shopify themes SEO Fields Agent (Claude Sonnet 4): Produces optimized meta descriptions for search engines Integrates keyword research data for maximum organic visibility Applies current year SEO best practices and anti-keyword stuffing techniques Shopify Integration & Updates Updates product descriptions via Shopify API Uploads metafields using GraphQL mutations Converts HTML to Shopify Rich Text format Tracks completion status in Airtable 🛠️ Setup Steps Core Integrations Shopify Access Token – For product data retrieval and content updates OpenRouter API – For GPT-4o and Claude model access Haloscan API – For keyword research and SERP analysis Perplexity API – For market intelligence and content strategy Airtable OAuth – For workflow management and keyword tracking Agent Configuration Orchestrator Agent – Central workflow management with routing logic Product Description Agent – SEO content generation with fact verification Meta Fields Agent – Structured metafield creation with compliance rules SEO Fields Agent – Meta description optimization with keyword integration Premium Keyword Discovery – Automated keyword research and analysis -SEO Compliance Checker – Cannibalization prevention and strategy generation Workflow Tools MCP Server Integration – Airtable data management HTTP Request Tools – Haloscan API communication Structured Output Parsers – Data validation and formatting Memory Buffer Windows – Conversation context management Rich Text Converters – Shopify-compatible content formatting 🎯 Workflow Capabilities Product Description Generation Length Control: 150-300 words with hard limits SEO Structure: Optimized heading hierarchy and keyword placement Fact Verification: Zero-invention policy with source validation Brand Compliance: Controlled brand mentions and positioning Metafield Creation 6 Specialized Fields: Arguments, ingredients, recommendations, nutrition, warnings, descriptions HTML Formatting: Clean structure with allowed tags only Regulatory Compliance: Industry-specific warnings and disclaimers Dynamic Content: Adapts to different product categories automatically Advanced SEO Features Keyword Research: Automated discovery with search volume analysis Cannibalization Prevention: SERP overlap detection and filtering Meta Optimization: Character-limited descriptions with CTR focus Content Strategy: AI-generated SEO roadmaps based on market data 🔐 Credentials Required Shopify Access Token – Product management and content publishing OpenRouter API Key – Multi-model AI access (GPT-4o, Claude variants) Haloscan API Key – Keyword research and SERP analysis Perplexity API Key – Market intelligence and content strategy Airtable OAuth – Database management and workflow tracking 👤 Ideal For E-commerce Teams scaling content creation across hundreds of products SEO Specialists implementing advanced cannibalization prevention strategies Shopify Store Owners seeking enterprise-level content automation Marketing Agencies building scalable, multi-client SEO workflows Product Managers requiring compliance-focused content generation 💬 Advanced Features Multi-Language Ready Workflow architecture supports easy extension to multiple markets and languages with minimal configuration changes. Compliance Framework Built-in regulatory compliance checking ensures content meets industry standards and legal requirements. Scalable Architecture Modular design allows adding new content types, AI models, or integration points without workflow restructuring. Error Handling & Retries Comprehensive error management with automatic retries and fallback mechanisms ensures reliable content generation. 💡 Pro Tip: This workflow represents a complete SEO content factory that can process hundreds of products daily while maintaining quality, compliance, and search engine optimization standards.

Workflow Information 📌 Purpose 🎯 The intention of this workflow is to integrate New Shopify Orders into MS Dynamics Business Central: Point-of-Sale (POS):** POS orders will be created in Business Central as Sales Invoices given no fulfillment is expected. Web Orders:** This type of orders will be created as Business Central Sales Orders. How to use it 🚀 Edit the "D365 BC Environment Settings" node with your own account values (Company Id, Tenanant Id, Tax & Discount Items). Go to the "Shopify" node and edit the connection with your environment. More help here. Go to the "Lookup Customers" node to edit the Business Central connection details with your environment settings. Set the required filters on the "Shopify Order Filter" node. Edit the "Schedule Trigger" node with the required frequency. Useful Workflow Links 📚 Step-by-step Guide/ Integro Cloud Solutions Business Central REST API Documentation Video Demo Need Help? Contact me at: ✉️[email protected] 📥 https://www.linkedin.com/in/greg-lopez-08b5071b/