See llms.txt for all machine-readable content.

Back to Templates

Send Shopify back-in-stock waitlist waves with WhatsApp, Gmail, Sheets and Slack

Created by

Created by: Rahul Joshi || rahul08
Rahul Joshi

Last update

Last update a day ago

Categories

Quick overview

This workflow collects back-in-stock waitlist signups for Shopify product variants, stores them in Google Sheets, and sends FIFO restock notifications in stock-based waves via WhatsApp Business Cloud or Gmail with time-limited Shopify discount codes, then posts wave summaries to Slack and marks conversions when Shopify orders.

How it works

  1. Receives a POST webhook from your product page with a shopper’s variant ID, contact details, channel preference, and consent.
  2. Looks up the product variant in Shopify and checks Google Sheets to validate consent/contact info, detect duplicates, and decide whether to join the waitlist, return an “in stock” message, or reject the request.
  3. Appends valid signups to a Google Sheets waitlist and sends a confirmation message via WhatsApp Business Cloud or Gmail, then returns the shopper’s queue position in the webhook response.
  4. Triggers on Shopify inventory level increases and on an hourly schedule to find variants with waiting shoppers, expire previously notified entries whose offer window has ended, and fetch live inventory for those variants from Shopify.
  5. Plans a FIFO notification wave sized to available stock (including a configurable multiplier and cap), creates a time-limited variant-specific discount code in Shopify, and sends each recipient their back-in-stock message via WhatsApp Business Cloud or Gmail.
  6. Updates Google Sheets to mark recipients as notified (including code and expiry) and posts a wave summary message to a Slack channel.
  7. Triggers on Shopify order creation, matches orders back to notified waitlist entries by variant plus email/phone/discount code, and updates Google Sheets to mark matched entries as converted.

Setup

  1. Add Shopify admin API access (custom app token or header auth) with permissions to read products/inventory and create discounts, and connect Shopify triggers for inventory_levels/update and orders/create.
  2. Connect Google Sheets, Gmail, Slack, and WhatsApp Business Cloud credentials, and set the WhatsApp Phone Number ID.
  3. Replace placeholders for your Shopify store domain, Google Sheet ID (with a “Waitlist” tab and required columns), Slack channel ID, and storefront URL in the workflow.
  4. Publish the signup webhook URL in your product page “notify me” form and send variant_id, email or phone, channel, and consent in the POST body.
  5. Review and adjust wave settings (multiplier, max wave size, discount percentage, and expiry window) to fit your restock strategy.