Get Started
Back to Templates

Send bulk WhatsApp promos for new Shopify products with OpenAI and Sheets

Created by

Created by: SpaGreen Creative || spagreen

SpaGreen Creative

Last update

Last update 4 hours ago

Categories

Share

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