Automate Shopify New Product Promotions via WhatsApp from Sheets

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