Get Started
Back to Templates

Send Shopify new product announcements via WhatsApp using Google Sheets and GPT-4.1 mini

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