Google Sheets and WooCommerce integration

Who Is This For? This n8n workflow enables automated cross-selling by identifying each WooCommerce customer's most frequently purchased product, finding a related product to recommend, and sending a personalized WhatsApp message using the Rapiwa API. It also verifies whether the user's number is WhatsApp-enabled before sending, and logs both successful and unsuccessful attempts to Google Sheets for tracking. What This Workflow Does Retrieves all paying customers from your WooCommerce store Identifies each customer's most purchased product Finds the latest product in the same category as their most purchased item Cleans and verifies customer phone numbers for WhatsApp compatibility Sends personalized WhatsApp messages with product recommendations Logs all activities to Google Sheets for tracking and analysis Handles both verified and unverified numbers appropriately Key Features Customer Segmentation:** Automatically identifies paying customers from your WooCommerce store Product Analysis:** Determines each customer's most purchased product Smart Recommendations:** Finds the latest products in the same category as customer favorites WhatsApp Integration:** Uses Rapiwa API for message delivery Phone Number Validation:** Verifies WhatsApp numbers before sending messages Dual Logging System:** Tracks both successful and failed message attempts in Google Sheets Rate Limiting:** Uses batching and wait nodes to prevent API overload Personalized Messaging:** Includes customer name and product details in messages Requirements WooCommerce store with API access Rapiwa account with API access for WhatsApp verification and messaging Google account with Sheets access Customer phone numbers in WooCommerce (stored in billing.phone field) How to Use — Step-by-Step Setup Credentials Setup WooCommerce API: Configure WooCommerce API credentials in n8n (e.g., "WooCommerce (get customer)" and "WooCommerce (get customer data)") Rapiwa Bearer Auth: Create an HTTP Bearer credential with your Rapiwa API token Google Sheets OAuth2: Set up OAuth2 credentials for Google Sheets access Configure Google Sheets Ensure your sheet has the required columns as specified in the Google Sheet Column Structure section Verify Code Nodes Code (get paying_customer): Filters customers to include only those who have made purchases Get most buy product id & Clear Number: Identifies the most purchased product and cleans phone numbers Configure HTTP Request Nodes Get customer data: Verify the WooCommerce API endpoint for retrieving customer orders Get specific product data: Verify the WooCommerce API endpoint for product details Get specific product recommend latest product: Verify the WooCommerce API endpoint for finding latest products by category Check valid WhatsApp number Using Rapiwa: Verify the Rapiwa endpoint for WhatsApp number validation Rapiwa Sender: Verify the Rapiwa endpoint for sending messages Google Sheet Required Columns You’ll need two Google Sheets (or two tabs in one spreadsheet): A Google Sheet formatted like this ➤ sample The workflow uses a Google Sheet with the following columns to track coupon distribution: Both must have the following headers (match exactly): | name | number | email | address1 | price | suk | title | product link | validity | staus | | ---------- | ------------- | ----------------------------------------------- | ----------- | ----- | --- | ---------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------ | ---------- | -------- | | Abdul Mannan | 8801322827799 | [email protected] | mirpur dohs | 850 | | Sharp Most Demanding Hoodie x Nike | https://your_shop_domain/p-img-nike | verified | sent | | Abdul Mannan | 8801322827799 | [email protected] | mirpur dohs | 850 | | Sharp Most Demanding Hoodie x Nike | https://your_shop_domain/p-img-nike | unverified | not sent | | Abdul Mannan | 8801322827799 | [email protected] | mirpur dohs | 850 | | Sharp Most Demanding Hoodie x Nike | https://your_shop_domain/p-img-nike | verified | sent | Important Notes Phone Number Format:** The workflow cleans phone numbers by removing all non-digit characters. Ensure your WooCommerce phone numbers are in a compatible format. API Rate Limits:** Rapiwa and WooCommerce APIs have rate limits. Adjust batch sizes and wait times accordingly. Data Privacy:** Ensure compliance with data protection regulations when sending marketing messages. Error Handling:** The workflow logs unverified numbers but doesn't have extensive error handling. Consider adding error notifications for failed API calls. Product Availability:** The workflow recommends the latest product in a category, but doesn't check if it's in stock. Consider adding stock status verification. Testing:** Always test with a small batch before running the workflow on your entire customer list. Useful Links Dashboard:** https://app.rapiwa.com Official Website:** https://rapiwa.com Documentation:** https://docs.rapiwa.com Support & Help WhatsApp**: Chat on WhatsApp Discord**: SpaGreen Community Facebook Group**: SpaGreen Support Website**: https://spagreen.net Developer Portfolio**: Codecanyon SpaGreen

Who is this for? This workflow is designed for online store owners, customer-success teams, and marketing operators who want to automatically verify customers' WhatsApp numbers and deliver order updates or invoice links via WhatsApp. It is built around WooCommerce order WooCommerce Trigger (order.updated) but is easily adaptable to Shopify or other platforms that provide billing and line_items in the WooCommerce Trigger payload. What this Workflow Does / Key Features Listens for WooCommerce order events (example: order.updated) via a Webhook or a WooCommerce trigger. Filters only orders with status "completed" and maps the payload into a normalized object: { data: { customer, products, invoice_link } } using the Code node Order Completed check. Iterates over line items using SplitInBatches to control throughput. Cleans phone numbers (Clean WhatsApp Number code node) by removing all non-digit characters. Verifies whether the cleaned phone number is registered on WhatsApp using Rapiwa's verify endpoint (POST https://app.rapiwa.com/api/verify-whatsapp). If verified, sends a templated WhatsApp message via Rapiwa (POST https://app.rapiwa.com/api/send-message). Appends an audit row to a "Verified & Sent" Google Sheet for successful sends, or to an "Unverified & Not Sent" sheet for unverified numbers. Uses Wait and batching to throttle requests and avoid API rate limits. Requirements HTTP Bearer credential for Rapiwa (example name in flow: Rapiwa Bearer Auth). WooCommerce API credential for the trigger (example: WooCommerce (get customer)) Running n8n instance with nodes: WooCommerce Trigger, Code, SplitInBatches, HTTP Request, IF, Google Sheets, Wait. Rapiwa account and a valid Bearer token. Google account with Sheets access and OAuth2 credentials configured in n8n. WooCommerce store (or any WooCommerce Trigger source) that provides billing and line_items in the payload. How to Use — step-by-step Setup 1) Credentials Rapiwa: Create an HTTP Bearer credential in n8n and paste your token (flow example name: Rapiwa Bearer Auth). Google Sheets: Add an OAuth2 credential (flow example name: Google Sheets). WooCommerce: Add the WooCommerce API credential or configure a Webhook on your store. 3) Configure Google Sheets The exported flow uses spreadsheet ID: 1S3RtGt5xxxxxxxXmQi_s (Sheet gid=0) as an example. Replace with your spreadsheet ID and sheet gid. Ensure your sheet column headers exactly match the mapping keys listed below (case and trailing spaces must match or be corrected in the mapping). 5) Verify HTTP Request nodes Verify endpoint: POST https://app.rapiwa.com/api/verify-whatsapp — sends { number } (uses HTTP Bearer credential). Send endpoint: POST https://app.rapiwa.com/api/send-message — sends number, message_type=text, and a templated message that uses fields from the Clean WhatsApp Number output. Google Sheet Column Structure The Google Sheets nodes in the flow append rows with these column keys. Make sure the spreadsheet headers A Google Sheet formatted like this ➤ sample | Name | Number | Email | Address | Product Title | Product ID | Total Price | Invoice Link | Delivery Status | Validity | Status | |----------------|---------------|-------------------|------------------------------------------|-----------------------------|------------|---------------|--------------------------------------------------------------------------------------------------------------|-----------------|------------|-----------| | Abdul Mannan | 8801322827799 | [email protected] | mirpur dohs | Air force 1 Fossil 1:1 - 44 | 238 | BDT 5500.00 | Invoice link | completed | verified | sent | | Abdul Mannan | 8801322827799 | [email protected] | mirpur dohs h#1168 rd#10 av#10 mirpur dohs dhaka | Air force 1 Fossil 1:1 - 44 | 238 | BDT 5500.00 | Invoice link | completed | unverified | not sent | Important Notes Do not hard-code API keys or tokens; always use n8n credentials. Google Sheets column header names must match the mapping keys used in the nodes. Trailing spaces are common accidental problems — trim them in the spreadsheet or adjust the mapping. The IF node in the exported flow compares to the string "true". If the verify endpoint returns boolean true/false, convert to string or boolean consistently before the IF. Message templates in the flow reference $('Clean WhatsApp Number').item.json.data.products[0] — update templates if you need multiple-product support. Useful Links Dashboard:** https://app.rapiwa.com Official Website:** https://rapiwa.com Documentation:** https://docs.rapiwa.com Support & Help WhatsApp**: Chat on WhatsApp Discord**: SpaGreen Community Facebook Group**: SpaGreen Support Website**: https://spagreen.net Developer Portfolio**: Codecanyon SpaGreen

This AI Agent is designed to streamline the process of creating realistic images of clothing products worn by models, eliminating the need for expensive photoshoots. The primary goal is to automate the generation of virtual try-on images for an eCommerce store selling clothing, using advanced image processing technologies. Example of results How It Works Triggering the Workflow: The workflow can be triggered manually using the When clicking ‘Test workflow’ node or automatically via the Schedule Trigger node, which runs the workflow at regular intervals (e.g., every 5 minutes). Data Retrieval: The Get new product node retrieves data from a Google Sheets document containing the URLs of the model image, the clothing product image, and the WooCommerce product ID. The document also includes a column for the resulting virtual try-on image URL, which is initially empty. Setting Up the Request: The Set data node prepares the data for the AI request by assigning the model image URL and the product image URL to variables. AI Image Generation: The Create Image node sends a request to API to generate a virtual try-on image. The request includes the URLs of the model and the clothing product. When you register for the API service you will get 1$ for free. For continuous work add API credits to your account. Image Retrieval: The Get Url image node retrieves the URL of the generated virtual try-on image. The Get File image node downloads the generated image from the provided URL. Image Storage: The Upload Image node uploads the generated image to a specified Google Drive folder for storage. Updating Google Sheets: The Update result node updates the Google Sheets document with the URL of the generated virtual try-on image. Updating WooCommerce: The Update product node updates the corresponding product in WooCommerce by adding the generated virtual try-on image to the product's image gallery. Functionality This AI Agent is designed to streamline the process of creating realistic images of clothing products worn by models, eliminating the need for expensive photoshoots. The primary goal is to automate the generation of virtual try-on images for an eCommerce store selling clothing, using advanced image processing technologies. By offering realistic images of clothing items worn by models, this automation process saves time and resources, making product catalog management more efficient. This approach not only enhances the competitiveness of the eCommerce store but also provides greater flexibility in creating high-quality visual content adaptable to various digital marketing campaigns. Key Features Automated Virtual Try-On**: Generates realistic images of models wearing clothing items using AI. Google Sheets Integration**: Retrieves and updates data in Google Sheets for seamless data management. Image Storage**: Uploads generated images to Google Drive for easy access and archiving. WooCommerce Integration**: Updates product pages with virtual try-on images, enhancing the shopping experience. Scheduled Automation**: Can be triggered manually or run at regular intervals for continuous processing. This workflow is ideal for eCommerce businesses looking to enhance their product catalogs with high-quality, realistic images without the need for costly photoshoots. It leverages AI to provide a cost-effective and efficient solution for virtual try-on image generation.

(Retail) Auto-Sync Transactions to Accounting Tools This workflow automates the collection and standardization of sales data from Shopify and WooCommerce into a centralized Google Sheets ledger. It triggers on new orders, normalizes disparate platform data, distinguishes between sales and refunds, and formats the information for accounting readiness. This eliminates manual data entry and ensures real-time financial tracking across multiple storefronts. Quick Implementation Steps Connect Triggers:** Authenticate your Shopify and WooCommerce accounts in the respective "Order Events" nodes. Set Webhooks:** Add the generated n8n Webhook URLs to your Shopify and WooCommerce notification settings. Configure Sheets:** Select your target spreadsheet and sheet name in the "Log to Google Sheets" node. Map Credentials:** Ensure Google Sheets OAuth2 is connected to authorize the "Append or Update" action. Verify Fields:** Test the workflow to ensure platform-specific keys map correctly to your sheet columns. What It Does The workflow acts as a bridge between e-commerce storefronts and financial reporting tools: Multi-Source Ingestion:** Listens for real-time webhooks from both Shopify (orders/create) and WooCommerce (order.created). Data Normalization:** Translates platform-specific JSON (like current_total_price vs total) into a single internal schema. Smart Routing:** Evaluates the transaction type to determine if the record is a standard sale or a refund. Accounting Formatting:** Structures data into financial-ready blocks, including calculated line items, tax details, and audit notes. Centralized Logging:** Records all activity in Google Sheets, using an "Append or Update" logic to prevent duplicate entries. Who's It For E-commerce Business Owners managing multiple stores who need a single "source of truth" for daily revenue. Accountants & Bookkeepers who require standardized transaction data without manual export/import tasks. Operations Managers looking to monitor multi-platform sales performance in real-time within a shared spreadsheet. Technical Workflow Breakdown Entry Points (Triggers) Shopify Order Events:** Listens for the orders/create topic to capture new Shopify transactions. WooCommerce Order Events:** Monitors the order.created event for new WooCommerce sales. Processing & Logic Platform Configuration:** Separate nodes for Shopify and WooCommerce that map native fields to standardized internal keys. Merge Platform Data:** Consolidates the two distinct platform paths into a single unified stream. Format Transaction Data:** A "Set" node that builds the final data object, creating a "description" string and assigning global statuses. Check Transaction Type:** An "If" node that routes data based on whether the transactionType equals "sale". Output & Integrations Format Sale/Refund Entry:** Logic-specific nodes that prepare line-item details (e.g., setting ItemRef to "Sales" or "Refund") and handle currency formatting. Google Sheets (Log Data):** Appends the final formatted record to the "Price_Changes_Log" spreadsheet, including date, customer, amount, and document numbers. Customization Add New Platforms You can extend this workflow by adding a new Trigger node (e.g., Magento or Amazon) and connecting it to a new Configuration node before the Merge node. Adjust Tax/Fee Logic Modify the "Format Sale Entry" node expressions to calculate net revenue after marketplace fees or to separate regional tax codes into different columns. Change Log Destination Swap the Google Sheets node for an ERP or Accounting node (like QuickBooks or Xero) to push data directly into professional accounting software. Troubleshooting Guide | Issue | Possible Cause | Solution | | :--------------------- | :--------------------------------------- | :------------------------------------------------------------------------------------------------- | | Webhook Not Triggering | Incorrect Webhook URL in Store settings. | Copy the Production Webhook URL from n8n and update your Shopify/WooCommerce settings. | | Missing Data Fields | Platform API version mismatch. | Check the "Configuration" nodes to ensure JSON keys match the current platform payload. | | Sheets Sync Failure | Column headers don't match. | Ensure your Google Sheet has headers matching the keys in the "Log to Google Sheets" node. | | Duplicate Records | "Append" mode used instead of "Update". | Set the Google Sheets operation to "Append or Update" and select a unique identifier like orderId. | Need Help? If you need help mapping additional custom fields from your store or connecting this to a professional accounting suite like QuickBooks, we're here to help. Feel free to contact our n8n developers at WeblineIndia.

Who Is This For? This workflow is perfect for e-commerce store owners using WooCommerce who want to automatically announce new products to their customers 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 announces new WooCommerce products by extracting product images and converting HTML descriptions into concise, bullet-pointed features using OpenAI. It retrieves and formats customer data, including names, phone numbers, and addresses, and verifies which numbers are registered on WhatsApp via the Rapiwa API. Personalized messages containing product details, images, purchase links, and bullet-point features are sent to verified contacts, while all outreach is logged in Google Sheets, tracking which numbers were verified and messages successfully sent versus unverified or not sent. Key Features Triggers automatically for new WooCommerce products Extracts and processes product images and media Converts HTML descriptions into concise AI-powered bullet points Verifies WhatsApp numbers before sending Sends personalized WhatsApp messages with product info and images Updates Google Sheets with verification and delivery status Adds delays to prevent API rate limits Manages both verified and unverified numbers Requirements WooCommerce API Access** (to retrieve product and customer data) Google Sheets OAuth2** (for tracking outreach) OpenAI API** (for processing product descriptions) Rapiwa API** (for WhatsApp verification and messaging) . Prepare Your Google Sheet Create a Google Sheet with columns for: name, number, verify, and status to track customer outreach. . Customize the Workflow Adjust the WooCommerce Trigger to specify which product events should trigger announcements Modify the message template in the Rapiwa node to match your brand voice Update the Google Sheet ID in both ""Save data"" nodes to point to your tracking sheet Support & Help WhatsApp**: Chat on WhatsApp Discord**: SpaGreen Community Facebook Group**: SpaGreen Support Website**: https://spagreen.net Developer Portfolio**: Codecanyon SpaGreen

Retail Price Sync Automation for Shopify & WooCommerce This workflow automates the synchronization of product prices across Shopify and WooCommerce platforms to ensure retail consistency. It triggers when a price change is detected in either system, applies platform-specific pricing rules (such as psychological rounding) and updates the secondary platform. The workflow also includes a threshold-based alerting system via Gmail for major price drops and logs every change to a Google Sheets master file for auditing. Quick Implementation Steps Set the priceChangeThreshold in the Shopify Configuration and WooCommerce Configuration nodes. Connect your Shopify Access Token credentials to the Shopify trigger and update nodes. Connect your WooCommerce API credentials to the WooCommerce trigger and update nodes. Link your Google Sheets OAuth2 and Gmail OAuth2 credentials for logging and notifications. Specify the documentId for your pricing log in the Log Price Changes node. What It Does This workflow acts as a bridge between two major e-commerce platforms, ensuring that a price update in one is intelligently reflected in the other. It goes beyond simple mirroring by: Threshold Monitoring: Detecting if a price change exceeds a set limit (e.g., $150 or $500) to trigger immediate management alerts. Platform-Specific Logic: Automatically formatting prices for different environments—for example, rounding WooCommerce prices to the nearest .99 for psychological pricing while using standard rounding for Shopify. Audit Trail Creation: Maintaining a centralized record of all price migrations in Google Sheets, including SKUs, old vs. new prices and timestamps. Team Communication: Sending automated email notifications to ensure the team is aware of successful syncs or critical price volatility. Who’s It For Multi-Channel Retailers who need to keep pricing in sync across Shopify and WooCommerce storefronts. Inventory Managers looking to automate price adjustments without manual data entry. Finance & Operations Teams requiring an automated audit log of all pricing modifications. Technical Workflow Breakdown Entry Points (Triggers) Shopify Price Update: Triggers on the orders/updated topic (or product updates) to capture new price data from Shopify. WooCommerce Price Update: Triggers on product.updated to capture changes originating from the WooCommerce store. Processing & Logic Configuration Nodes: Define the source system and set the specific threshold for what constitutes a "major" price change. Apply Platform-Specific Rules: A custom code block that calculates psychological pricing (e.g., forcing a .99 ending) and ensures prices never drop below a minimum safety floor (e.g., $1.00). Check Price Change Threshold: An internal filter that routes the workflow based on the magnitude of the price shift. Output & Integrations Update Nodes: Pushes the formatted price data to the target platform (Shopify or WooCommerce). Log Price Changes: Appends a new row to a Google Sheet with detailed metadata. Notifications: Uses Gmail to send high-priority alerts for major drops and routine confirmations for successful syncs. Customization Adjust Pricing Strategy Modify the Apply Platform-Specific Rules (Code Node) to change rounding logic, add currency conversion factors or implement different psychological pricing tiers. Change Alert Thresholds Update the priceChangeThreshold value in the Shopify Configuration or WooCommerce Configuration nodes to make alerts more or less sensitive. Expand Logging The Log Price Changes node is set to autoMapInputData. You can add custom columns to your Google Sheet and the workflow will automatically attempt to fill them if the data exists in the workflow. Troubleshooting Guide | Issue | Possible Cause | Solution | | :--------------------------------------- | :----------------------------------- | :----------------------------------------------------------------------------------------------------------------- | | Sync Not Triggering | Webhook not registered correctly. | Check the webhookId in the Shopify/WooCommerce trigger nodes and ensure the apps have permission to send events. | | Google Sheets Error | Sheet ID or Column names mismatched. | Verify the documentId and ensure the id column exists in your Sheet for matching. | | Prices Not Rounding Correct/Expected | Code node logic error. | Review the JavaScript in Apply Platform-Specific Rules to ensure the Math functions match your strategy. | | Emails Not Sending | Gmail OAuth2 expired. | Re-authenticate your Gmail credentials in the n8n settings. | Need Help? If you need assistance adjusting the psychological pricing code, adding more platforms (like Amazon or eBay) or setting up advanced Slack notifications, please reach out to our n8n automation experts at WeblineIndia. We can help scale this workflow to manage thousands of SKUs with high precision.

Daily WooCommerce Sales Snapshot to Slack with Google Sheets Logging This workflow automatically collects WooCommerce sales data every day, calculates key sales metrics, sends a clean summary to Slack and logs the same data into Google Sheets for historical tracking. It helps teams stay informed about daily performance without manually checking dashboards or reports. Quick Implementation Steps (Get Started Fast) Import the workflow JSON into n8n. Connect your WooCommerce, Slack and Google Sheets credentials. Verify the Slack channel and Google Sheet selection. Activate the workflow. Receive daily sales updates automatically. What It Does This workflow runs on a daily schedule and fetches all recent orders from a WooCommerce store. It filters the orders to include only paid ones (Processing and Completed) and further narrows them down to those created within the last 24 hours. Using separate Code nodes, the workflow calculates essential sales metrics such as total revenue, number of orders, average order value (AOV) and the top-selling products. These metrics are merged into a single structured object for consistent downstream use. Finally, the workflow sends a formatted sales summary to a Slack channel for quick visibility and appends the same data as a row in Google Sheets. This creates a reliable daily log that can be used for trend analysis and reporting. Who’s It For WooCommerce store owners Sales and operations teams Marketing teams tracking daily performance Business managers who prefer Slack updates Analysts maintaining sales history in spreadsheets Requirements to Use This Workflow Active WooCommerce store with API access n8n instance (self-hosted or cloud) Slack workspace with permission to post messages Google Sheets document for logging data Valid credentials configured in n8n for: WooCommerce Slack Google Sheets How It Works A Schedule Trigger runs the workflow once per day. Orders are fetched from WooCommerce. Only paid orders (Processing / Completed) are considered. Orders from the last 24 hours are filtered. Sales metrics are calculated: Total Revenue Order Count Average Order Value (AOV) Top Selling Products Metrics are merged into a single object. A formatted summary is: Sent to Slack Appended or updated in Google Sheets How To Set Up Configure the Schedule Trigger time. Add WooCommerce credentials. Review paid order filtering logic. Select Slack channel. Select Google Sheet and worksheet. Test the workflow. Activate it. How To Customize Nodes Change schedule time in the Schedule Trigger. Modify order statuses in the Filter Paid Orders node. Adjust the 24-hour window in the Code node. Increase or decrease top products count. Customize Slack message formatting. Add or remove Google Sheets columns. Add-ons (Optional Enhancements) Weekly or monthly summaries Revenue comparison (day-over-day / week-over-week) Revenue threshold alerts Multiple Slack channels Dashboard integrations from Google Sheets Use Case Examples Daily sales snapshot for store owners Morning updates for sales teams Automated sales logging for finance teams Performance tracking without dashboards Remote team visibility via Slack Many more variations are possible depending on business needs. Troubleshooting Guide | Issue | Possible Cause | Solution | |------|---------------|----------| | Slack message not received | Slack credentials or channel issue | Verify Slack API and channel | | Google Sheet not updating | Incorrect sheet or mapping | Recheck sheet selection | | Orders missing | Order status filter too strict | Update filter conditions | | Revenue incorrect | Time filter issue | Verify last 24-hour logic | | Workflow not running | Workflow inactive | Activate workflow | Need Help? If you need help setting up, customizing or extending this workflow, our n8n automation experts at WeblineIndia can assist. We specialize in: n8n automation workflows Business process automation Custom integrations and reporting Contact WeblineIndia to build reliable and scalable automation tailored to your business.

Retail – New Product Drop Notifications This workflow automatically detects when a new product is created in WooCommerce and instantly notifies internal teams through Slack and email. At the same time, it logs all product details into Google Sheets for tracking and reporting. A centralized data formatting step ensures consistent and reusable product data across all nodes. Quick Implementation Steps Import the workflow JSON into n8n. Connect WooCommerce, Slack, Gmail and Google Sheets credentials. Review the Format Product Details node for field mappings. Select the Slack channel and Google Sheet. Activate the workflow. What It Does This workflow listens for new product creation events from WooCommerce. When a product is created, the workflow extracts key product attributes such as name, price, status, permalink and images and prepares them in a single centralized configuration node. Using this standardized data, the workflow sends a real-time Slack notification to inform internal teams, sends a formatted HTML email announcing the product launch and appends the same product information into a Google Sheet for historical reference and reporting. By centralizing data preparation and reusing it across all downstream nodes, the workflow remains easy to maintain, highly readable and simple to extend for future requirements. Who’s It For This workflow is ideal for: E-commerce teams using WooCommerce Marketing teams managing product launches Operations teams maintaining product logs Sales teams needing instant product visibility Business owners tracking new product releases Prerequisites To use this workflow, you need: An active n8n instance (self-hosted or cloud) WooCommerce REST API credentials Slack workspace with API access Gmail account with OAuth2 access Google Sheets API access A Google Sheet with predefined columns How to Use & Setup Import the workflow JSON into n8n. Configure WooCommerce – New Product Created with your WooCommerce credentials. Review the Format Product Details node to verify product field mappings. Configure Notify Team on Slack and select the target Slack channel. Configure Send Product Launch Email and update the recipient email if required. Configure Log Product in Google Sheets and select the target spreadsheet and sheet. Save and activate the workflow. Once activated, the workflow runs automatically whenever a new product is created in WooCommerce. How To Customize Nodes Format Product Details** Add or remove product attributes such as SKU, categories or tags. Modify how images are processed or stored. Slack Notification** Customize message format, emojis or mentions. Email Notification** Adjust branding, layout or additional product details. Google Sheets Logging** Add more columns like product ID, category or creator. Add-ons (Optional Enhancements) This workflow can be extended to: Prevent duplicate product entries in Google Sheets Route Slack notifications to different channels by category Send emails to multiple stakeholder groups Add approval or review steps before notifications Integrate with CRM or ERP systems Generate daily or weekly product launch summaries Use Case Examples Marketing teams receiving instant alerts for new product launches. Operations teams maintaining a centralized product creation log. Sales teams staying updated on new offerings. Business owners tracking product launch activity over time. Teams ensuring consistent communication across Slack, email and reports. There can be many additional use cases depending on business needs. Troubleshooting Guide | Issue | Possible Cause | Solution | |------|---------------|----------| | Slack message not sent | Invalid Slack credentials | Reconnect Slack API credentials | | Email not delivered | Gmail OAuth expired | Reauthorize Gmail account | | Google Sheet not updated | Sheet permissions missing | Verify Google Sheets access | | Images missing | Product has no images | Check WooCommerce product data | | Workflow not executing | Workflow inactive | Activate the workflow | Need Help? If you need help setting up, customizing or extending this workflow or want to build similar automations tailored to your business, our n8n developers at WeblineIndia can assist with advanced workflow design and automation solutions.

WooCommerce Seasonal Sales Planning & Monitor → SET Pattern Compare → Slack This workflow automatically aggregates sales data, calculates performance trends (Revenue & Orders) against previous months and years, identifies the top-selling SKU and sends a strictly formatted, professional summary report to Slack. This workflow runs on a schedule (e.g., daily or weekly) to generate a snapshot of your business performance. It fetches sales data from your database or e-commerce platform, calculates growth percentages (vs. Month, vs. Year), formats the data into a clean JSON structure and sends a structured report to Slack without unnecessary clutter or emojis. You receive: Automated comparison of Revenue & Order counts** Trend analysis (Percentage change & directional trend)** Identification of the Top Performing SKU** A clean, professional Slack alert for team visibility** Ideal for management teams needing a quick, data-driven pulse check on store performance without manually running reports. Quick Start – Implementation Steps Add your Database or API Credentials (e.g., Postgres, Shopify, WooCommerce) in the data fetching nodes. Connect your Slack account credentials and select the target channel. Ensure your data source provides current, vsMonth and vsYear metrics (or use the calculation nodes provided). Review the Slack Node to ensure the JSON block formatting matches your preference. Activate the workflow — automated reporting begins instantly. What It Does This workflow automates the generation of your business trend report: Trigger: Starts automatically based on a schedule (e.g., every morning at 8 AM). Fetch Data: Retrieves raw sales numbers for the current period, previous month and previous year. Process Trends: Calculates the percentage difference and determines the trend direction (Increase, Flat, Decrease). Identify Top SKU: Sorts product sales to find the highest-performing item of the period. Format Report: Constructs a strict JSON object containing: Revenue (Current, vs Month, vs Year) Orders (Current, vs Month, vs Year) Top SKU Name Send Slack Alert: Pushes a cleanly formatted message (using Block Kit or Markdown) to your team channel. This ensures your team focuses on the numbers that matter, with zero manual effort. Who’s It For This workflow is ideal for: E-commerce Store Owners Sales & Marketing Managers Data Analysts Operations Teams Executive leadership requiring daily snapshots Teams preferring data-heavy, emoji-free reports Requirements to Use This Workflow To run this workflow, you need: n8n instance** (cloud or self-hosted) Data Source** (PostgreSQL, MySQL, Shopify, WooCommerce or Google Sheets) Slack workspace** with API permissions (Webhook or Bot Token) Basic understanding of JSON structure for Slack Block Kit How It Works Scheduled Trigger – Initiates the workflow at a specific time. Get Sales Data – Queries your backend to get the raw numbers. Calculate Logic – Compares current numbers vs. historical data to generate percentages. Create Report Object – Maps the values into a standardized JSON format (e.g., revenue.current, orders.vsYear). Format Message – Converts the JSON object into a Slack-readable text block or UI block. Send Notification – Posts the final report to Slack. Setup Steps Import the provided n8n JSON file. Open the Data Fetch nodes and configure your database/API connection. Ensure your query returns the necessary fields (Revenue Orders, SKU). Verify the Format Data node is correctly mapping your variables to the JSON structure: {{ $json"revenue" }} {{ $json"orders"["percent"] }} Connect Slack API credentials and choose your channel. Run a test execution to verify the numbers appear correctly in Slack. Activate the workflow — done! How To Customize Nodes Customize Report Metrics Modify the Set/Calculation nodes: Add Average Order Value (AOV) Include Customer Acquisition Cost (CAC) Change the comparison period (e.g., vs Last Week instead of Month) Customize Slack Layout You can modify the JSON in the Slack node to: Use Block Kit for a table-like structure (columns for Revenue/Orders) Use Plain Text for a simple list view Add or remove bold formatting (bold) Add a "View Dashboard" button link Customize Data Source Replace the generic database node with: Shopify Node** (Get Orders) WooCommerce Node** (Get Sales Report) Stripe Node** (Get Balance Transactions) Google Sheets** (Read Row) Add-Ons (Optional Enhancements) You can extend this workflow to: Send reports to Email or Microsoft Teams in addition to Slack. Generate a PDF report using an HTML-to-PDF service. Save the daily snapshot into a "History" table in Airtable/Database. Add conditional alerts (e.g., @mention the CEO if Revenue drops by >20%). Integrate with OpenAI to write a qualitative analysis of the trends. Use Case Examples Morning Standup Report Delivers key metrics to the team channel 15 minutes before the daily meeting. Performance Monitoring Quickly identifies if a new marketing campaign is driving order volume. Inventory Awareness Highlights the "Top SKU" so the warehouse team knows what is moving fast. Executive Summaries Provides leadership with a noise-free, "just the numbers" view of the business. Troubleshooting Guide | Issue | Possible Cause | Solution | | :--- | :--- | :--- | | "N/A" in Trend | No historical data found | Ensure database has data for previous month/year | | Slack formatting broken | Invalid JSON syntax | Check quotes and brackets in Slack node | | Wrong Top SKU | Sorting logic incorrect | Verify the "Sort" node is ordering by Count DESC | | Authentication Error | Slack token expired | Re-connect Slack credentials in n8n | | Workflow not running | Schedule disabled | Toggle "Active" switch to ON | Need Help? If you need help customizing or extending this workflow — integrating specific ERPs, creating complex visual dashboards or scaling your data reporting, feel free to contact our n8n workflow development experts at WeblineIndia. We are happy to assist you with advanced automation solutions.

Who is this for? This workflow is ideal for WooCommerce store owners who want to automatically send promotional WhatsApp messages to their customers when new coupons are created. It’s designed for marketers and eCommerce managers looking to boost engagement, streamline coupon sharing, and track campaign performance effortlessly through Google Sheets. Overview This workflow listens for WooCommerce coupon creation events (coupon.created) and uses customer billing data to send promotional WhatsApp messages via the Rapiwa API. The flow formats the coupon data, cleans phone numbers, verifies WhatsApp registration with Rapiwa, sends the promotional message when verified, and logs each attempt to Google Sheets (separate sheets for verified/sent and unverified/not sent). What this Workflow Does Listens for new coupon creation events in WooCommerce via the WooCommerce Trigger node Retrieves all customer data from the WooCommerce store Processes customers in batches to control throughput Cleans and formats customer phone numbers for WhatsApp Verifies if phone numbers are valid WhatsApp accounts using Rapiwa API Sends personalized WhatsApp messages with coupon details to verified numbers Logs all activities to Google Sheets for tracking and analysis Handles both verified and unverified numbers appropriately Key Features Automated coupon distribution: Triggers when new coupons are created in WooCommerce Customer data retrieval: Fetches all customer information from WooCommerce Phone number validation: Verifies WhatsApp numbers before sending messages Personalized messaging: Includes customer name and coupon details in messages Dual logging system: Tracks both successful and failed message attempts Rate limiting: Uses batching and wait nodes to prevent API overload Data formatting: Structures coupon information for consistent messaging Google Sheet Column Structure A Google Sheet formatted like this ➤ sample The workflow uses a Google Sheet with the following columns to track coupon distribution: | name | number | email | address1 | couponCode | couponTitle | couponType | couponAmount | createDate | expireDate | validity | status | | ----------- | ------------- | --------------------------------------------------- | --------- | ---------- | -------------- | ---------- | ------------ | ------------------- | ------------------- | ---------- | -------- | | Abdul Mannan | 8801322827799 | [email protected] | mirpur-DOHS | 62dhryst | eid offer 2025 | percent | 20.00 | 2025-09-11 06:08:02 | 2025-09-15 00:00:00 | unverified | not sent | | Abdul Mannan | 8801322827799 | [email protected] | mirpur-DOHS | 62dhryst | eid offer 2025 | percent | 20.00 | 2025-09-11 06:08:02 | 2025-09-15 00:00:00 | verified | sent | Requirements n8n instance with the following nodes: WooCommerce Trigger, Code, SplitInBatches, HTTP Request, IF, Google Sheets, Wait WooCommerce store with API access Rapiwa account with API access for WhatsApp verification and messaging Google account with Sheets access Customer phone numbers in WooCommerce (stored in billing.phone field) Important Notes Phone Number Format**: The workflow cleans phone numbers by removing all non-digit characters. Ensure your WooCommerce phone numbers are in a compatible format. API Rate Limits**: Rapiwa and WooCommerce APIs have rate limits. Adjust batch sizes and wait times accordingly. Data Privacy**: Ensure compliance with data protection regulations when sending marketing messages. Error Handling**: The workflow logs unverified numbers but doesn't have extensive error handling. Consider adding error notifications for failed API calls. Message Content**: The current message template references the first coupon only (coupons[0]). Adjust if you need to handle multiple coupons. Useful Links Dashboard:** https://app.rapiwa.com Official Website:** https://rapiwa.com Documentation:** https://docs.rapiwa.com Support & Help WhatsApp**: Chat on WhatsApp Discord**: SpaGreen Community Facebook Group**: SpaGreen Support Website**: https://spagreen.net Developer Portfolio**: Codecanyon SpaGreen

Send WooCommerce New Category Alert via WhatsApp Using Rapiwa API This n8n automation listens for the creation of a new WooCommerce product category, fetches all WooCommerce customers, cleans and formats their phone numbers, verifies them using the Rapiwa WhatsApp validation API, sends a WhatsApp message to verified numbers with the new category info, and logs each interaction into a Google Sheet (separately for verified and unverified customers). Who this is for You have a WooCommerce store and want to: Send a promotional message when a new product category is added, Verify customer WhatsApp numbers in bulk, Keep a clear log in Google Sheets of which numbers are verified or not. What it does (high level) Webhook is triggered when a new WooCommerce category is created. Fetches all WooCommerce customers via API. Limits processing to the first 10 customers (for performance/testing). Cleans phone numbers (removes +, spaces, and non-digits). Verifies each number via Rapiwa WhatsApp Verify API. If verified: sends WhatsApp message with new category info, logs as Verification = verified, Status = sent. If not verified: logs as Verification = unverified, Status = not sent. Processes users in batches with delays to avoid rate limiting. How it works (step-by-step) Trigger**: Webhook node is triggered by WooCommerce category creation. Format Data**: Category details (name, slug, description) are parsed. Get Customers**: Fetch all WooCommerce customers using the WooCommerce API. Limit**: Only the first 10 are processed. Loop & Clean**: Loop over each customer, clean phone numbers and extract info. Verify Number**: Send HTTP POST to https://app.rapiwa.com/api/verify-whatsapp. Decision Node**: Use If node to check if exists == true. Send Message**: If verified, send WhatsApp message with category details. Append to Sheet**: Log verified and unverified customers separately in Google Sheets. Wait + Batch Control**: Use Wait and SplitInBatches nodes to control flow and prevent throttling. Example verify body (HTTP Request node): { ""number"": ""{{ $json['WhatsApp No'] }}"" } Google Sheet Column Reference | name | number | email | address | catagoris | description | status | |-------------|---------------|------------------------------|------------------------------------------------------|-------------|-------------------------------------------------------------------------------------------------|------------| | Abdul Mannan | 8801322827799 | [email protected] | mirpur dohs | Electronics | SShop top-braxxxxrable tech. | unverified | | Abdul Mannan | 8801322827799 | [email protected] | mirpur dohs | Electronics | Shop top-braxxxxrable tech. | verified | | Abdul Mannan | 8801322827799 | [email protected] | mirpur doh | Electronics | Shop top-braxxxxrable tech. | verified | Customization ideas Send images, videos, or template messages if supported by Rapiwa. Personalize messages using name or category data. Increase delay or reduce batch size to minimize risk of rate limits. Add a second sheet to log full API responses for debugging and auditing. Best practices Test on small batches before scaling. Only send messages to users who opted in. Store API credentials securely using n8n’s credentials manager. Ensure your Google Sheet column headers match exactly with what's expected. Key Improvements Made Clarified the trigger source as a Webhook from WooCommerce category creation. Fixed inconsistency in the ""What it does"" section (originally referenced reading from Google Sheets, but your workflow starts from WooCommerce, not Sheets). Standardized terminology to match n8n nodes: Webhook, Loop, HTTP Request, etc. Aligned the flow exactly with your nodes: Webhook → Format → Get Customers → Limit → Loop → Clean → Verify → If → Send/Log → Wait → Repeat 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 "