📱 Send Shopify new product announcements via WhatsApp using Google Sheets and GPT-4.1 mini
⚡ 9 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 designed for e-commerce store owners, digital marketers, and Shopify merchants who want to automate their product announcement and marketing campaigns. It’s particularly useful for businesses that rely on WhatsApp marketing to inform customers about new products and want to streamline their notification process while ensuring message delivery to verified numbers only.
Key Features
- Triggers automatically for new Shopify 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
Workflow Does
This workflow automates announcing new Shopify products via WhatsApp. It extracts product images, converts HTML descriptions into AI-powered bullet points, fetches customer contacts from Google Sheets, verifies WhatsApp numbers, and sends personalized messages with product details. Message status is tracked in Google Sheets, marking numbers and messages appropriately, with built-in rate limiting to ensure smooth delivery.
Requirements
- Shopify store with webhook access for product creation events
- Google Sheets account with customer contact information
- Rapiwa account for WhatsApp verification and messaging
- OpenAI API credentials for text processing
- Properly configured Google Sheets with columns for:
WhatsApp numbers,Customer names,Verification status,Message status,Product URLs`
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, Shopify Trigger, AI Agent, OpenAI Chat Model
📥 Import
Download workflow.json and import into n8n:
Workflow menu → Import from File