Send WooCommerce cross-sell offers to customers via WhatsApp using Rapiwa API

Name: Send WooCommerce cross-sell offers to customers via WhatsApp using Rapiwa API
Availability: InStock
Rating: 4.5 (18 reviews)
Author: Rapiwa

$20/month : Unlimited workflows

2500 executions/month

Try free

THE #1 IN WEB SCRAPING

Scrape any website without limits

Try free

HOSTINGER 🎉 Early Black Friday Deal
DISCOUNT 20%

Self-hosted n8n

Unlimited workflows - from $4.99/mo

Try free

#1 hub for scraping, AI & automation

6000+ actors - $5 credits/mo

Try free

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

1. 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

2. Configure Google Sheets

Ensure your sheet has the required columns as specified in the Google Sheet Column Structure section

3. 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

4. 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	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

Rapiwa

0 workflows

Nodes

set gmail telegram agent google-gemini

Complexity

advanced

Published 25 Oct 2025

Likes 0

View on n8n.io Download Workflow

✨

Share Your Workflow

Have a great workflow to share? Join the n8n Creator Hub and help the community!

Submit Your Template How to Submit

Related Workflows

Create and schedule LinkedIn posts from Google Sheets with Gemini and DALL·E

## Overview This n8n automation is a complete LinkedIn Content Engine that turns simple topic ideas into fully written, visual, and scheduled posts. It features a "Human-in-the-Loop" design, meaning AI handles the heavy lifting of writing and image creation, but nothing goes live until you manually approve it in Google Sheets. ## How It Works The system runs two separate workflows in parallel: ### 1. The "Creator" Workflow **Input:** Detects when you add a new topic to your "Content Calendar" Google Sheet. **Brand Alignment:** Pulls your specific "Brand Voice" guidelines from a separate tab to ensure the AI sounds like you. **Creation:** Uses Gemini Flash 1.5 to write the post and DALL-E 3 to generate a matching professional image. **Drafting:** Uploads the image to ImgBB and saves the full draft back to your sheet with a status of "Draft." ### 2. The "Publisher" Workflow **Daily Scan:** Wakes up every morning to check your Content Calendar. **Verification:** Looks for posts that match two criteria: * Date Scheduled matches today's date. * Status is marked as "Approved" (by you). **Publishing:** If both match, it automatically uploads the text and image to LinkedIn and updates the sheet status to "Posted." **Tools Used:** n8n, Google Sheets, OpenRouter (Gemini / OpenAI), ImgBB. ## Connect & Learn More **YouTube Channel:** **[Simon Scrapes](https://www.youtube.com/@simonscrapes)** – More tutorials on AI & Automation. **Community:** **[Skool Community](https://www.skool.com/scrapes/about)** – Master AI & Automation with us. **Full Video Tutorial:** [Watch the step-by-step build here](https://youtu.be/eiIRSUhPgOI?si=lgZTrPZPMqWF4uqz&t=4276)

View

Curate and post AI news to X, Bluesky, Threads and more with GPT-5 mini and Cue

# Curate & post AI news to X, Bluesky, Threads & more via GPT-5 mini & Cue This n8n template automatically curates AI news from RSS feeds and generates platform-tailored social media posts using GPT-5 mini. Posts are saved as drafts in Cue for review before publishing to X, Bluesky, Threads, Mastodon, and Facebook. Use cases include: * Daily automated AI/tech news curation * Multi-platform social media content creation * Building thought leadership with consistent posting * Staying on top of industry news without manual effort ## Who is this for? This workflow is ideal for: * Tech content creators who want to share AI news across multiple platforms * Social media managers handling multiple accounts * Anyone building an audience around AI/tech topics * Teams who want consistent daily content without manual curation ## What problem does this workflow solve? Manually curating news, writing platform-specific posts, and publishing across 5 different social networks is time-consuming. This workflow automates the entire process: * **Curation** - Pulls from 4 trusted AI/tech RSS feeds daily * **Deduplication** - Tracks posted articles in Google Sheets so you never share the same story twice * **Content creation** - GPT-5 mini writes posts tailored to each platform's style and character limits * **Review workflow** - Creates drafts in Cue so you can review before publishing ## How it works 1. **Schedule Trigger** - Runs daily at 9am (configurable) 2. **RSS Feeds** - Fetches articles from TechCrunch AI, Ars Technica AI, The Verge AI, and MIT Tech Review 3. **Filter & Merge** - Combines all feeds and filters to articles from the last 7 days 4. **Deduplication** - Compares against Google Sheets to find unposted articles 5. **Random Selection** - Picks one random article from available stories 6. **AI Generation** - GPT-5 mini generates 5 platform-specific posts with appropriate tone and length 7. **Save to Cue** - Creates a draft post with all 5 platform variations 8. **Log to Sheet** - Records the article URL to prevent future duplicates ## Setup ### Requirements * [Cue account](https://oncue.so) with connected social accounts * OpenAI API key * Google account for Sheets ### Step 1: Install the Cue community node 1. Go to **Settings** → **Community Nodes** 2. Click **Install** 3. Enter `@cuehq/n8n-nodes-cue` ### Step 2: Create tracking spreadsheet 1. Create a new Google Sheet named "AI News Tracker" 2. Add these column headers in row 1: * `article_url` * `title` * `source` * `processed_at` ### Step 3: Configure credentials 1. **Google Sheets** - Add OAuth2 credentials and connect to the "Get Recent Posts" node 2. **OpenAI** - Add your API key and connect to the "GPT-5 mini" node 3. **Cue** - Add your API key from [Cue Settings](https://app.oncue.so/settings/api) ### Step 4: Configure the Cue node 1. Open the **Create Draft in Cue** node 2. Select your **Profile** 3. For each platform slot, select your social account: * Slot 1 → X/Twitter * Slot 2 → Bluesky * Slot 3 → Threads * Slot 4 → Mastodon * Slot 5 → Facebook Don't have all 5 platforms? Simply delete the unused slots. ### Step 5: Publish Save and click **Publish** to activate the workflow. ## Customizing this workflow ### Change the schedule Edit the **Daily 9am Trigger** node to run at a different time or frequency. ### Use different RSS feeds Replace the feed URLs with sources relevant to your niche. The workflow handles any standard RSS feed. Keep 3-6 feeds for best results. ### Auto-publish instead of drafts To publish immediately instead of creating drafts, enable **Publish Immediately** in the Cue node settings. ### Adjust the AI tone Modify the system prompt in the **Write Social Posts** node to match your brand voice or adjust platform-specific guidelines. ## Good to know * **Cost** - Each run uses one OpenAI API call. With GPT-5 mini, this costs approximately $0.01-0.02 per execution. * **Draft review** - Posts are created as drafts in Cue, giving you a chance to review and edit before publishing. * **Deduplication** - The Google Sheet tracks all posted URLs, so the same article is never shared twice. ## About Cue [Cue](https://oncue.so) is a social media scheduling platform that lets you manage and publish content across X, Bluesky, Threads, Mastodon, Facebook, LinkedIn, TikTok, and Instagram from a single dashboard. Key features: * **Multi-platform publishing** - Schedule once, publish everywhere * **Platform-specific content** - Tailor each post for different audiences * **Draft workflow** - Review and edit before publishing * **API & integrations** - Connect with n8n, Zapier, Make, and custom apps [Get started free](https://oncue.so) · [Documentation](https://docs.oncue.so) · [n8n Community Node](https://www.npmjs.com/package/@cuehq/n8n-nodes-cue)

View

Create and post social media image captions with GPT-4.1-mini and Google Sheets

# Social Media Posting Automation with Image and Caption ## How it works This AI-powered workflow streamlines your social media posting process, transforming hours of manual caption writing, image uploading, and scheduling into a fully automated system. You define the topic and image once, and the workflow handles caption generation, review, approval, and posting to your selected platforms. ### Automated Flow 1. **Generate Caption** Trigger the workflow manually and set your post topic and image URL in the Set node. The AI (GPT-4.1-mini) generates a high-quality, engaging social media caption tailored to your audience, platform, and content goals. 2. **Store in Google Sheet** The generated caption, along with your image URL and post metadata, is automatically appended to your Google Sheet. This creates a central location to review and manage all your social media content. 3. **Review and Approve** You review the generated caption in the sheet, make any edits if needed, and update the status to **Approved**. You can also select the platform(s) where you want to post. 4. **Automatic Posting** Once the status is updated to Approved, the next workflow is triggered automatically. It posts your caption and image to the selected social media platform(s) without any further manual effort. **The result?** A seamless, end-to-end social media posting process where captions are AI-generated, stored, reviewed, and posted automatically. Focus on strategy and engagement instead of repetitive manual posting. --- ## Setup Steps **Setup time:** ~10–15 minutes **What you’ll need:** OpenAI API key, Google account, access to your social media platform(s) 1. **Connect Your Google Account** - Click on the Google Sheets node in your workflow. - Select the Credential dropdown and choose **+ Create New Credential**. - Authenticate your Google account and grant the necessary permissions. 2. **Initialize Your Spreadsheet** - Run the workflow once by clicking the play button on the start node. - This will automatically create a Google Sheet with all the required columns for caption tracking and approval. 3. **Add Your OpenAI API Key** - Navigate to the AI Agent node. - Click the Credential dropdown and select **+ Create New Credential**. - Paste your OpenAI API key and save. - Get your API key from [platform.openai.com/api-keys](https://platform.openai.com/api-keys). 4. **Set Post Topic and Image** - Update the title in the Set node with the topic you want to post. - Add the image URL associated with your post. 5. **Review Captions and Approve** - Open your Google Sheet, review the generated captions, and update the status to **Approved**. - Select the platform(s) where the post should go live. 6. **Go Live** - Once the status is updated, the workflow will automatically post your content to the selected social media platform(s). - Sit back and watch your AI-generated captions and images go live automatically. **Ready to automate your social media?** Activate your workflow and start posting smarter today! 🚀💡✅

View

👨‍💻

Need Custom Automation?

N8N Automation Expert

Specialized in N8N automation, I design custom workflows that connect your tools and automate your processes.