Shopify VIP alerts: AI summary & Slack notification for big orders
𧨠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_priceis 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:
Yaron@nofluff.online
π·οΈ Tags
#shopify, #openai, #slack, #vip-customers, #automation, #n8n, #workflow, #ecommerce, #customer-insights, #ai-summaries, #gpt4o
Shopify VIP Order Alerts with AI Summary & Slack Notification
This n8n workflow automates the process of identifying significant Shopify orders, generating an AI-powered summary of the customer's order history, and notifying a Slack channel. It helps businesses quickly identify and acknowledge high-value customers or unusual purchasing patterns.
What it does
- Monitors Shopify Orders: Listens for new order events from your Shopify store.
- Filters for VIP Orders: Checks if the total price of the new order exceeds a predefined threshold (e.g., $500).
- Retrieves Customer Order History (via HTTP Request): If the order is a VIP order, it fetches the customer's complete order history from Shopify's API.
- Generates AI Summary: Uses an OpenAI Chat Model to create a concise summary of the customer's past purchases based on their order history.
- Formats Slack Message: Prepares a detailed message including the new VIP order details and the AI-generated customer summary.
- Notifies Slack Channel: Posts the formatted alert message to a designated Slack channel.
- Handles Non-VIP Orders: If an order does not meet the VIP threshold, the workflow gracefully exits without further action.
Prerequisites/Requirements
- n8n Instance: A running n8n instance.
- Shopify Account: With API access enabled and a Private App created to generate API credentials.
- OpenAI API Key: For the AI Agent and OpenAI Chat Model to generate summaries.
- Slack Account: With a Slack App and incoming webhook configured for sending notifications.
Setup/Usage
- Import the workflow: Download the provided JSON and import it into your n8n instance.
- Configure Shopify Trigger:
- Add your Shopify API credentials (Shop Name, Access Token).
- Set the "Event" to "Order Created".
- Activate the workflow to create the webhook in Shopify.
- Configure "If" Node:
- Adjust the "Total Price" condition to your desired VIP order threshold (e.g.,
{{ $json.current.total_price > 500 }}).
- Adjust the "Total Price" condition to your desired VIP order threshold (e.g.,
- Configure "HTTP Request" Node:
- Update the URL to your Shopify store's API endpoint for fetching customer orders. Ensure it includes the customer ID from the incoming Shopify trigger data.
- Set up appropriate authentication (e.g.,
X-Shopify-Access-Tokenheader with your Shopify API token).
- Configure "AI Agent" Node:
- Add your OpenAI API credentials.
- Review the prompt to ensure it effectively summarizes customer order history.
- Configure "OpenAI Chat Model" Node:
- Add your OpenAI API credentials.
- Ensure the model and temperature settings are suitable for generating concise summaries.
- Configure "Edit Fields" (Set) Node:
- Review and adjust the fields being set to ensure the Slack message contains all necessary information.
- Configure "Slack" Node:
- Add your Slack API credentials (e.g., OAuth Access Token).
- Specify the "Channel" where you want the VIP alerts to be posted.
- Customize the "Text" field to format your Slack message using the data from previous nodes, including the AI summary.
- Activate the workflow: Once all credentials and configurations are set, activate the workflow to start monitoring Shopify orders.
Related Templates
Track meal nutrition from meal photos with LINE, Google Gemini and Google Sheets
AI Meal Nutrition Tracker with LINE and Google Sheets Who's it for This workflow is designed for health-conscious individuals, fitness enthusiasts, and anyone who wants to track their daily food intake without manual calorie counting. It is best suited for users who want a simple, AI-powered meal logging system that analyzes food photos one at a time and provides instant nutritional feedback via LINE. What it does This workflow processes a single meal photo sent via LINE, analyzes it using Google Gemini AI to identify foods and estimate nutritional content, and stores the data in Google Sheets for tracking. The workflow focuses on simplicity and encouragement: it receives a meal image, performs AI-based food recognition, estimates calories and macronutrients, calculates a health score, provides personalized advice, and replies with a detailed nutritional breakdown on LINE. How it works A single meal photo is sent to the LINE bot. The workflow is triggered via a LINE webhook. The image file is downloaded and sent to Google Gemini AI for food analysis. The AI identifies foods and estimates nutritional values (calories, protein, carbs, fat, fiber). A health score (1-10) is calculated with personalized improvement tips. The data is appended to Google Sheets for meal history tracking. The image is uploaded to Google Drive for reference. A formatted nutritional report with advice is sent back as a LINE reply. This workflow is intentionally designed to handle one image per execution. Requirements To use this workflow, you will need: A LINE Messaging API account A Google Gemini API key A Google account with access to Google Sheets and Google Drive A Google Sheets document with the following column names: Date Time Meal Type Food Items Calories Protein (g) Carbs (g) Fat (g) Fiber (g) Health Score Advice Image URL Important limitations This workflow does not support multiple images sent in a single message. Sending images in quick succession may trigger multiple executions and lead to unexpected results. Only the first image in an event payload is processed. Nutritional values are AI estimates based on visual analysis and typical serving sizes. Accuracy depends on image quality, lighting, and food visibility. This tool should not replace professional dietary advice. These limitations are intentional to keep the workflow simple and easy to understand. How to set up Create a LINE Messaging API channel and obtain a Channel Access Token. Generate a Google Gemini API key. Update the Config node with your LINE token, Google Sheets ID, Google Drive folder ID, and daily calorie goal. Configure credentials for LINE, Google Gemini, Google Sheets, and Google Drive. Register the n8n webhook URL in your LINE channel settings. Activate the workflow in n8n and test it with a single meal photo. How to customize Modify the AI prompt in the "Analyze Meal with AI" node to support different languages or dietary frameworks (keto, vegan, etc.). Adjust the daily calorie goal in the Config node to match individual needs. Add additional nutritional fields such as sodium, sugar, or vitamins. Replace Google Sheets with a fitness app API or database. Integrate with other services to send daily/weekly nutrition summaries. --- Note: This workflow was tested using real meal photos sent individually via the LINE Messaging API. Nutritional estimates are approximations and may vary from actual values. For accurate dietary tracking, consult a registered dietitian.
Track free Udemy courses automatically with RapidAPI and Google Sheets
This workflow fetches free Udemy courses hourly via the Udemy Coupons and Courses API on RapidAPI, filters them, and updates a Google Sheet. It sends alerts on errors for smooth monitoring. --- Node-by-Node Explanation Schedule Trigger: Runs the workflow every hour automatically. Fetch Udemy Coupons: Sends POST request to the Udemy Coupons and Courses API on RapidAPI to get featured courses. Check API Success: Verifies if the API response is successful; routes accordingly. Filter Free Courses: Selects only courses with sale_price of zero (free courses). Send Error Notification: Emails admin if API fetch fails for quick action. Sync Courses to Google Sheet: Appends or updates the filtered free courses into Google Sheets. --- Google Sheets Columns id name price sale_price image lectures views rating language category subcategory slug store sale_start --- Google Sheets Setup & Configuration Steps Create Google Sheet: Create or open a Google Sheet where you want to sync courses. Set Headers: Add columns headers matching the fields synced (id, name, price, etc.). Enable Google Sheets API: Go to Google Cloud Console, enable Google Sheets API for your project. Create Service Account: In Google Cloud Console, create a Service Account with editor access. Download Credentials: Download the JSON credentials file from the service account. Share Sheet: Share your Google Sheet with the Service Account email (found in JSON file). Configure n8n Google Sheets Node: Use the service account credentials, set operation to βAppend or Updateβ, provide Sheet URL and sheet name or gid. Match Columns: Map the course fields to your sheet columns and set id as the unique key for updates. --- How to Obtain RapidAPI Key & Setup API Request Sign up/Login: Visit RapidAPI Udemy Coupons and Courses API and create an account or log in. Subscribe to API: Subscribe to the Udemy Coupons and Courses API plan (free or paid). Get API Key: Navigate to your dashboard and copy your x-rapidapi-key. Configure HTTP Request: In your workflowβs HTTP Request node: Set method to POST. URL: https://udemy-coupons-and-courses.p.rapidapi.com/featured.php Add headers: x-rapidapi-host: udemy-coupons-and-courses.p.rapidapi.com x-rapidapi-key: your copied API key Set content type to multipart/form-data. Add body parameter: page=1 (or as needed). Test API: Run the node to ensure the API responds with data successfully before continuing workflow setup. --- Use Cases & Benefits Automates daily updates of free Udemy courses in your sheet using the Udemy Coupons and Courses API on RapidAPI. Saves manual effort in tracking coupons and deals. Enables quick error alerts to maintain data accuracy. Ideal for course aggregators, affiliate marketers, or learning platforms needing fresh course data. --- Who This Workflow Is For Content curators and edtech platforms tracking free courses. Affiliate marketers promoting Udemy deals. Anyone needing real-time access to updated free Udemy coupons.
Automate LinkedIn requests & icebreaker with Browserflow and Google sheets
Disclaimer: As this workflow uses a Community node, it is available only to self-hosted installation of n8n Who is this for? This n8n template is designed for professionals, recruiters, and marketers who need to automate LinkedIn data population and contact request processes. It is particularly useful for those looking to streamline their outreach efforts and manage LinkedIn connections more efficiently. What problem is this workflow solving? / Use Case The workflow addresses the challenge of manually managing LinkedIn connections and sending contact requests followed by an AI generated ice-breaker. By automating these tasks, users can save time, reduce errors, and ensure consistent follow-ups with potential clients, partners, or candidates. What this workflow does: This template extract LinkedIn adresses from a google sheet, check if they already are connected to you, and send them a contact request if hey are not. Then it sends to them an AI generated Ice breaker messages, which take into account the personal and company posts, and your company description, to find common points of interest. You can contact up to 50 persons for free. Setup Copy this google sheet to your Google account Enter your data in "Set your Data Here": Google sheet URL: Paste here the URL of your google sheet Your activity: Define here what your company is about (used to match your activity with the users activity) Your name: Enter your name (used to sign your mail) Your company: Enter here your company name Your email: Used to send your email Maxitems: The number of maximum posts to download from LinkedIn Set an account on Rapid API, you are allowed for free to 50 credits (5$ for 500) and most of the calls cost 1 credit. Setup an account at Browserflow You will benefit from a 7 days free trial. And then you will have to pay $17.95. With this account you'll be able to send 1920 connection invites and 3204 messages. Install n8n-nodes-browserflow from your n8n Settings > Community Nodes. (it means for now that you'll need a self-hosted installation of n8n). and paste the API key you copied earlier as a credential. Execute it regularly to check if your connections have accepted your connection request. How to customize this workflow to your needs Customize Contact Messages: Personalize the AI agent prompt that generates the icebreaker Integrate with Other Tools: Add additional nodes to integrate with CRM systems or other marketing tools for enhanced functionality. Monitor and Optimize: Regularly review the workflow's performance and make adjustments to improve efficiency and effectiveness. By following this setup and customization guide, users can leverage this n8n template to enhance their LinkedIn outreach and connection management processes.