SMS Deal Club — Signup & Broadcast Automation by Ameer HamzaSMS Deal Club — Signup & Broadcast Automation by Ameer Hamza

SMS Deal Club — Signup & Broadcast Automation

Ameer Hamza

Ameer Hamza

A complete Make.com SMS marketing system for a deal club: automated BigCommerce signups, scheduled MMS deal broadcasts from Google Sheets, and a two-way keyword command handler over Twilio.
Need something similar? See my Workflow Automation (n8n & Make.com) service.
SMS Deal Club Automation — Signups, Broadcasts & Two-Way Replies — Automation project screenshot

Overview

Built for a surf equipment retailer's exclusive SMS deal club, this system runs on three connected Make.com scenarios. The signup handler turns a landing-page form into a fully onboarded customer: it checks phone and email for duplicates, creates or reuses a BigCommerce customer, and sends a welcome SMS plus the current deal as an MMS. The broadcast scenario polls a Google Sheet every 15 minutes; when the operator flips a deal to Active, it fans out an MMS with the product image to every active subscriber and marks the deal as broadcasted so it never sends twice. The reply handler routes every inbound text by keyword: BUY returns the purchase link (or a sold-out or no-deal reply), INVITE sends a shareable invitation, HELP lists commands, and STOP/START manage subscription status, turning a one-way broadcast tool into two-way conversational commerce.

What I built

Signup flow with duplicate detection on phone and email, BigCommerce customer creation, and an instant welcome SMS plus current-deal MMS
15-minute scheduled polling with multi-condition filtering on Active, Broadcasted, and Sold Out flags
Fan-out MMS broadcast to every active subscriber, with atomic updates guaranteeing each deal sends once
URL sanitization layer working around a Cloudflare WebP conversion issue that broke Twilio MMS delivery
Six-way inbound command router (BUY, INVITE, HELP, STOP, START, and an unknown-keyword fallback) with case-insensitive matching
Instant TwiML acknowledgment and self-loop prevention to keep the reply flow fast and safe

Role

Automation Design — Architected all three Make.com scenarios, the BigCommerce and Google Sheets integrations, and the Twilio SMS/MMS logic, with nested routers, fallback branches, and atomic state updates for broadcast-once delivery.

Project FAQ

What is SMS Deal Club Automation — Signups, Broadcasts & Two-Way Replies?
A complete Make.com SMS marketing system for a deal club: automated BigCommerce signups, scheduled MMS deal broadcasts from Google Sheets, and a two-way keyword command handler over Twilio.What was Ameer Hamza’s role on SMS Deal Club Automation — Signups, Broadcasts & Two-Way Replies?
Automation Design — Architected all three Make.com scenarios, the BigCommerce and Google Sheets integrations, and the Twilio SMS/MMS logic, with nested routers, fallback branches, and atomic state updates for broadcast-once delivery.What stack was used for SMS Deal Club Automation — Signups, Broadcasts & Two-Way Replies?
SMS Deal Club Automation — Signups, Broadcasts & Two-Way Replies was built with Make.com, Twilio, Google Sheets, BigCommerce.Is there a public live demo of SMS Deal Club Automation — Signups, Broadcasts & Two-Way Replies?
Like this project

Posted Oct 22, 2026

Make.com and Twilio automation that captures SMS club signups, syncs them to Google Sheets and sends deal broadcasts to subscribers automatically.