📱 Send bulk WhatsApp promos for new Shopify products with OpenAI and Sheets
⚡ 8 views · 📱 Social Media & Email Marketing
💡 Pro Tip — If you’ve run into Facebook’s Graph API permission restrictions, ScraperNode is a community node that scrapes pages, groups, posts, and comments directly — no app review needed.
Description
Who Is This For?
This workflow is perfect for e-commerce store owners using Shopify who want to automatically announce new products to their customer base through personalized WhatsApp messages. It’s ideal for businesses looking to increase product visibility and drive sales without manual outreach efforts.
What This Workflow Does
This workflow automatically sends WhatsApp product announcements whenever a new product is added to your Shopify store. It processes product data by extracting images, generating product links, and converting HTML descriptions into clean, bullet-point feature lists using OpenAI. Customer data is pulled from Shopify, formatted, and phone numbers are verified on WhatsApp via the Rapiwa API. Personalized messages with product images, features, and purchase links are sent only to verified numbers. All verification and messaging activity is logged in Google Sheets, clearly tracking which contacts were verified and successfully reached.
Features
- Shopify Integration that triggers automatically when new products are created
- Image Processing to extract and filter valid product images from Shopify
- Product URL Generation to create direct links to new products
- AI-Powered Description Conversion using OpenAI to transform HTML descriptions into concise bullet points
- Customer Data Retrieval from Shopify store via API
- WhatsApp Number Verification using Rapiwa to check if customer numbers are valid WhatsApp accounts
- Personalized WhatsApp Messaging with product details, features, and images
- Dual-Path Logging to Google Sheets, tracking both verified (sent) and unverified (not sent) messages
- Batch Processing to handle multiple customers efficiently
- Rate Limiting with wait steps to avoid API restrictions
Requirements
- Shopify Access Token API credentials for accessing product and customer data
- OpenAI API credentials for converting HTML descriptions to bullet points
- Rapiwa API credentials for WhatsApp number verification and messaging
- Google Sheets OAuth2 credentials for logging message delivery status
Support & Help
- WhatsApp: Chat on WhatsApp
- Discord: SpaGreen Community
- Facebook Group: SpaGreen Support
- Website: https://spagreen.net
- Developer Portfolio: Codecanyon SpaGreen
🔗 Nodes Used
Google Sheets, HTTP Request, Shopify Trigger, Gmail, OpenAI
📥 Import
Download workflow.json and import into n8n:
Workflow menu → Import from File