Shopify and Twilio integration

This workflow is a complete, production-ready solution for recovering abandoned carts in Shopify stores using a multi-channel, multi-touch approach. It automates personalized follow-ups via Email, SMS, and WhatsApp, tracks every customer interaction for multi-touch attribution, and enables advanced retargeting and analytics. Key features: Multi-step, timed recovery sequence (Email → SMS → Email → WhatsApp) Customer segmentation (new, returning, VIP) and A/B testing Dynamic discounting and personalized messaging Touchpoint logging to Google Sheets for attribution analysis Facebook Custom Audience retargeting for unrecovered carts Slack notifications for high-value cart recoveries What does this workflow do? Listens for abandoned cart events from Shopify (or any e-commerce platform) via webhook. Normalizes and enriches cart data by fetching full cart details and customer purchase history. Predicts the likely reason for abandonment (e.g., price sensitivity, checkout complexity, technical issues) using rule-based logic. Segments the customer (new, returning, VIP), assigns an A/B test group, and generates a personalized discount and checkout URL. Runs a timed, multi-channel recovery sequence: 1 hour after abandonment: Checks if the order is completed. If not, sends a personalized Email #1 and logs the touchpoint. 4 hours after abandonment: Checks again. If not recovered, sends an SMS with a discount code and logs the touchpoint. 24 hours after abandonment: Checks again. If not recovered, sends Email #2 (with social proof/urgency) and logs the touchpoint. 48 hours after abandonment: Final check. If not recovered, sends a WhatsApp reminder and logs the touchpoint. If the cart is still not recovered: Hashes customer identifiers and adds them to a Facebook Custom Audience for retargeting. Logs every touchpoint (email, SMS, WhatsApp) to a Google Sheet for multi-touch attribution analysis. Sends a Slack notification if a high-value cart is recovered. Why is this workflow useful? Boosts recovery rates:** By using multiple channels and personalized timing, you maximize the chance of recovering lost sales. Improves attribution:** Every customer interaction is logged, so you can analyze which channels and messages drive conversions. Enables advanced retargeting:** Unrecovered carts are automatically added to a Facebook Custom Audience for paid retargeting. Saves time:** Fully automated, with easy configuration for your store, messaging, and analytics. Scalable and extensible:** Easily adapt the sequence, add more channels, or integrate with other tools. How to install and configure Prerequisites n8n instance (v2.0.2+ recommended) Shopify store with API access Accounts and API credentials for: SendGrid (email) Twilio (SMS) WhatsApp Business API Google Sheets (service account) Facebook Graph API (for Custom Audiences) Slack (for notifications) Setup steps Import the workflow into your n8n instance. Configure the “Workflow Configuration” node: Set your Shopify domain, API URLs, Google Sheets ID, and high-value threshold. Connect all required credentials in the respective nodes: Shopify, SendGrid, Twilio, WhatsApp, Google Sheets, Facebook Graph API, Slack. Create a Google Sheet named “Touchpoints” with columns: cart_id, customer_id, touchpoint_type, timestamp, channel, ab_group. Set up the webhook in your Shopify store (or e-commerce platform) to trigger the workflow on cart abandonment. Test the workflow with a sample abandoned cart event to ensure emails, SMS, WhatsApp, and logging work as expected. Enable the workflow in n8n for live operation. Node-by-node breakdown Abandoned Cart Webhook:** Receives abandoned cart events. Workflow Configuration:** Stores global settings (API URLs, Shopify domain, Google Sheets ID, high-value threshold). Normalize Cart Data:** Cleans and standardizes incoming cart data. Fetch Cart Details / Fetch Customer History:** Enriches data with full cart and customer info. Predict Abandonment Reason:** Uses business logic to guess why the cart was abandoned. Personalization Engine:** Segments the customer, assigns A/B group, calculates discount, and builds checkout URL. Customer Segment Check / Device Type Check:** Applies routing logic for personalized messaging. Wait / Check Order Status / Generate & Send Messages:** Timed sequence for Email, SMS, and WhatsApp, with order status checks at each step. Log Touchpoint (Google Sheets):** Records every message sent for attribution. Attribution Merge:** Combines all touchpoints into a single journey for analysis. Hash Customer Data for Facebook / Add to Retargeting Audience:** Adds unrecovered carts to a Facebook Custom Audience. Check Cart Value Threshold / Notify High-Value Recovery:** Sends Slack alerts for high-value recoveries. Customization tips Adjust wait times and message content to fit your brand and audience. Add or remove channels (e.g., push notifications, phone calls) as needed. Expand the Google Sheet for deeper analytics (e.g., add UTM parameters, campaign IDs). Integrate with your CRM or analytics platform for end-to-end tracking. Troubleshooting Make sure all API credentials are set and tested. Check Google Sheets permissions for the service account. Test each channel (email, SMS, WhatsApp) individually before going live. Review the workflow execution logs in n8n for errors or failed steps.

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.

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.