আপনার পুরোনো Customers-দের WhatsApp-এ Automatic Message পাঠান — Wati বা BotSailor ছাড়াই

Today her system:

• Reads all 3 years of her order data automatically
• Scores every customer by how recently they bought, how often, and how much
• When she publishes a new product — sends the message only to the right customers
• Costs ৳450/month in infrastructure
• Requires zero manual work per campaign

This article explains exactly how it works — and how you can have the same system for your business.

The Real Problem with Every WhatsApp Marketing Platform

Whether you use Wati, Interakt, AiSensy, BotSailor, or ForwardValueSMS — they all share the same fundamental flaw:

"They know nothing about your customers."

They are broadcast tools. You upload a phone list. You compose a message. You send it to everyone. You pay monthly. Forever. They cannot tell you:

• Which customers bought from you 3 times and are most likely to buy again
• Which customers prefer gown versus kimono versus cape
• Which customers have gone cold and need a different approach
• Who your top 200 buyers are right now

And worse — most of them charge you a 10–25% markup on every WhatsApp message you send through them. You pay their platform fee plus inflated message costs. Every month. With no end in sight.

The result is marketing that feels like spam — because it is. Everyone gets the same message regardless of what they bought, when they bought, or how valuable they are.

What a Smart WhatsApp Marketing System Actually Looks Like

Here is the system we built — and the principles behind every decision.

Principle 1: Your Order History Is Your Most Valuable Asset

You already have the data. Every completed order in your Google Sheets contains the answer to who your best customers are and what they are most likely to buy next.

The system reads every order tab in your spreadsheet — all the way back to the first entry. For each phone number it finds, it calculates:

• Recency: When did this customer last complete a purchase? A customer who bought 2 weeks ago is far more valuable than one who bought 18 months ago.
• Frequency: How many times have they purchased? A customer who has bought 5 times is demonstrably loyal and likely to buy again.
• Average Order Value: Does this customer spend above or below your store average? Higher spenders deserve to be messaged first.
• Category Preference: What did they buy? A customer with 4 kimono purchases is a kimono buyer. When you launch a new kimono, she should get the message — not a customer who only buys hijab.

These four factors combine into a Conversion Score from 0 to 100. Every customer in your 16,000+ database gets scored automatically, updated every 2 hours.

Principle 2: Automation Should Require Zero Manual Work Per Campaign

Every other system requires you to manually create a campaign each time you launch a product. Select your segment. Upload the list. Write the message. Schedule. Wait.

Our system eliminates every manual step:

• WooCommerce: You publish a product. That's it. Within 30 minutes, the system has detected the new product, identified the right customers, and sent the campaign. You do nothing after clicking Publish.
• Laravel or custom store: One function call from your backend. The system handles the rest.
• Shopify: Webhooks automatically trigger the campaign on product creation.
• F-commerce / no website: You type PENDING in one Google Sheet cell. The system fires within 30 minutes.

Principle 3: Direct Meta API Means Lower Costs Forever

Every BSP-based platform (Wati, Interakt, AiSensy, BotSailor) makes money by sitting between you and Meta. You buy credits from them. They charge a markup. You pay more per message than you need to.

Our system connects directly to Meta WhatsApp Cloud API — the same API those platforms use, but without the middleman. You pay Meta's rates directly through your own Meta account. For Bangladesh marketing conversations, that is approximately ৳0.50–1.50 per 24-hour conversation window.

No markup. No credits. No platform profiting from your messages.

Principle 4: Google Sheets Is the Best Interface — Because You Already Know It

New software platforms require learning time, training, and ongoing familiarity. Your team already knows Google Sheets.

The entire system lives in your spreadsheet:

• WA_Settings: All configuration in two columns. Change your daily message limit, frequency cap, or minimum score in one cell.
• WA_Products: Add a product row, set campaign_trigger to PENDING. That's a manual campaign launch.
• WA_Customers: See every customer's score, last purchase date, preferred categories, last message sent — live, updated every 2 hours.
• WA_MessageLog: Every message sent, with delivered timestamp, read timestamp, and any errors.
• WA_Campaigns: Full analytics per campaign — how many sent, how many delivered, how many read.
• WA_Inbox: Every customer reply, with a direct WhatsApp link to continue the conversation.

No new dashboard. No new password. No new app to open.

The Technical Architecture

How the entire automatic flow is tied together smoothly:

Three n8n workflows handle the entire operation:

1. Workflow 1 — Campaign Runner: Receives the trigger, reads customers, filters and scores, sends in batches of 50, logs every result, marks the campaign complete.
2. Workflow 2 — Status Tracker: Receives delivery and read callbacks from Meta. Updates your MessageLog in real time. If a customer blocks your number, they are automatically added to a suppression list and never messaged again.
3. Workflow 3 — Product Intake: Receives webhooks from WooCommerce, Shopify, or Laravel. Normalises product data, detects category, queues for campaign. Skip this if you use manual entry.

Real Results from the Live Deployment

These are actual numbers from the first 3 months of operation:

The block rate being under 1% is the metric that matters most for long-term health. When you send relevant, category-matched messages to customers who have bought from you before — at a 72-hour minimum frequency — customers do not block you. They engage.

For International Businesses: Why This Works Globally

The same system that works for a clothing brand in Dhaka works for ecommerce businesses anywhere in the world.

• The intelligence layer is universal. RFM scoring — recency, frequency, monetary value — is the most proven customer segmentation methodology in retail globally. Whether your customers are in Bangladesh, the UK, the UAE, or Australia, the scoring logic identifies your best buyers the same way.
• The category detection is customisable. We map your product categories — in Bengali, English, Arabic, or any language — to the targeting system. WooCommerce categories, Shopify product types, Laravel database fields — all supported.
• The template auto-selection extends to all languages. A +880 number gets the Bengali template. A +44 number gets the English template. You can add any language template and route by country code.
• The cost advantage is even more dramatic internationally. In South Asia, Southeast Asia, and the Middle East, WhatsApp usage is near-universal for customer communication. The platforms charging $50–150/month for WhatsApp automation are extracting significant margin. Direct Meta API access cuts that completely.

Is This System Right For Your Business?

What the Done-For-You Setup Includes

We build, configure, and connect everything for you within 3 days:

1. Phase 1 — Meta Setup (Day 1): Meta Business Manager, Cloud API phone setup, and permanent system token setup.
2. Phase 2 — Template Creation (Day 1-2): Structuring highly engaging templates in Bengali & English with parameters like product image, price, and CTA buttons.
3. Phase 3 — Google Sheets System (Day 1-2): Fully-equipped 7-tab spreadsheet designed for configuration, tracking, and logs.
4. Phase 4 — Apps Script Integration (Day 2): Multi-tab layout auto-detection and 2-hour update triggers.
5. Phase 5 — n8n Workflows (Day 2-3): Cloud workflows setup for automation runners and real-time status callbacks.
6. Phase 6 — Platform Integration (Day 3): Connecting webhooks for WooCommerce, Shopify, or Laravel.
7. Phase 7 & 8 — Live Test Campaign & Handover (Day 3): Monitoring the first live campaign together and handing over complete documentation with 30 days of backup support.

Transparent Package Pricing

Bangladesh Pricing

*Optional monthly retainer: ৳2,500/month (covers new template submissions, health monitor, & campaigns tracking).
Payment methods: bKash · Nagad · Bank Transfer · Wise

International Pricing

Frequently Asked Questions