WhatsApp broadcast console for planning and launching campaigns

Compare every WhatsApp campaign side by side, launch a new one from a spreadsheet audience, and stop a bad send in one click.

App
KapsoGoogle SheetsMarketingAI ReportsContent Generation
PromptCreate

Build me a WhatsApp broadcast console where my marketing team plans, launches and compares campaigns without living in the Kapso dashboard. It uses Kapso for everything broadcast related and Google Sheets as the source of the audience list.

The home view is a list of every broadcast, most recent first, from the Kapso List Broadcasts operation. Each row shows the campaign name, the template it used, when it went out, and sent, delivered, read and failed counts side by side so the team can compare templates head to head. Show delivered and read as both raw counts and a percentage of sent, and make a high failed count visually obvious. Anything currently sending should show live progress in its row.

Clicking a broadcast opens a detail view built from Get Broadcast for the campaign level numbers and List Recipients for recipient level delivery status. Show a table of recipients with phone number, their merge field values, current status and any error. Above that table, group the failures by reason with a count for each, so the team can tell at a glance whether they hit bad numbers, an opt out, or a template problem. Sending is asynchronous, so poll Get Broadcast while a campaign is in a sending state and update the counts in place, then stop polling once it finishes.

A launcher page walks through a new send. First pick a template from List Message Templates, showing name, language and approval status, and only allow approved templates to be selected. Then point at the audience and read it with the Google Sheets Get Values operation, letting the user choose the spreadsheet, tab and range, and map sheet columns to the phone number and to each template variable. Render a live preview of the message exactly as it will arrive for the first few rows so they can see the merge fields filled in and catch a bad mapping before anything sends.

Launching runs the Kapso sequence in order: Create Broadcast to make the campaign in draft, Add Recipients to load the audience, then Schedule Broadcast for a future time or Send Broadcast to start immediately. Add Recipients accepts at most 1000 recipients per call, so batch larger Sheet audiences into successive calls and show upload progress. Broadcasts stay in draft until the send or schedule call, so the user can build one up and confirm before committing.

Every in flight campaign needs a stop button that is always one click away, on the detail view and on the home view row. Stopping calls Update Broadcast Status with status set to stopped, which starts no new sends and leaves pending recipients pending. For a campaign that has not gone out yet, offer Cancel Scheduled Broadcast to pull it back to draft. Confirm before either action, then show clearly what state the campaign ended in.

Add a review before send button, on the launcher and on any draft or scheduled campaign, that kicks off a background agent. The agent reads how similar past broadcasts performed using List Broadcasts, Get Broadcast and List Recipients, comparing the chosen template against past sends with similar content or audience. It checks the chosen template and the Sheet audience for problems such as malformed or duplicate numbers, missing merge values, or a template that has underperformed before. It then drafts one or two stronger copy variants and submits them with Create or Update Message Template so WhatsApp approval can start early, since templates must be approved before they can be used. Finally it writes a go or no go note back into the app with its reasoning, the past campaigns it compared against, and the variants it drafted.

Persist the review notes in the app so each one shows on the campaign it belongs to and stays readable later, with the time it ran and its outcome. The team can launch without a review, but when a review came back no go, surface that warning next to the send button. The Kapso broadcasts API is marked alpha, so handle its errors gracefully and show a clear message rather than failing silently.

What does this prompt do?

  • Lists every broadcast newest first with sent, delivered, read and failed counts next to each other, so you can compare templates head to head instead of opening them one at a time.
  • Click into any campaign for recipient by recipient delivery status, with the failures grouped by reason so you can tell bad numbers apart from a template problem.
  • Build a new send from an approved template plus a spreadsheet of phone numbers and merge fields, preview the real message, then schedule it or send it now.
  • A review before send button hands the plan to a background assistant that checks it against past campaigns, flags problems, drafts stronger copy variants, and posts a go or no go note back into the app.

What do I need to use this?

  • A Kapso account with your WhatsApp Business number connected and at least one approved message template
  • A Google account with a spreadsheet of phone numbers and any fields you want to personalize, such as first name or appointment time
  • Permission in Kapso to create and send broadcasts

How can I customize it?

  • Change which spreadsheet columns map to the phone number and to each field in the message, and which tab the audience is read from
  • Decide whether the review step is optional or something the team must run before the send button unlocks
  • Adjust which numbers appear on the home view, for example putting failure rate front and center or adding your own cost per campaign column

FAQs

Do I still need to open the Kapso dashboard?
Not for day to day campaign work. Planning, launching, scheduling, watching progress, stopping a send and comparing past results all happen in this app. You would still use Kapso itself for account level setup like connecting numbers.
Can I stop a send that is already going out?
Yes. Every campaign that is currently sending has a stop button that is always one click away, and it halts new sends immediately. Messages already delivered cannot be recalled, but everyone still waiting stays unsent. A campaign scheduled for later can be pulled back before it ever starts.
What happens if my spreadsheet has thousands of phone numbers?
The app loads them in batches behind the scenes and shows progress while they upload, so a large audience works the same as a small one from your side.
Can the assistant send messages on its own?
No. It only reviews, flags problems and drafts copy variants for you to consider. Launching, scheduling and stopping are always your click.
Why does the assistant draft new message templates before I need them?
WhatsApp has to approve a template before you can send it, and approval takes time. Getting stronger variants submitted early means they are ready when you want to test them instead of holding up the campaign.
Will this work if my team is not technical?
Yes. Picking a template, choosing a sheet, previewing the message and hitting send or schedule are all point and click. The spreadsheet is the only thing anyone needs to maintain.

Related templates

See which Kajabi offers actually made money this period

Pick any date range and see gross revenue, orders, refunds, and average order value for every Kajabi offer, then drill into the exact sales behind each number.

Kajabi
Google Sheets
App
Shared WhatsApp inbox with a 24 hour reply window countdown

Work every open WhatsApp chat from one board, sorted by how long you have left to reply for free, with claims so two people never answer the same customer.

Kapso
HubSpot
App
A weekly Keap cleanup desk for duplicate contacts and tag sprawl

See duplicate Keap contacts side by side with their orders and tags in view, merge the right record on purpose, and retire the tags nobody uses.

Keap
Google Sheets
App
Klaviyo list health and sunset workbench for deliverability

Clean your email list from one screen: see every audience, review who is in it, and suppress unengaged people in batches a human approves first.

Klaviyo
Google Sheets
App
Daily buying signal desk your SDRs work like an inbox

Every morning your reps open one queue of people publicly asking for alternatives, complaining about a renewal, or shopping your category.

Infegy
HubSpot
Google Sheets
+1
App
Competitor hiring radar for talent acquisition teams

Open one board before every planning meeting to see how many roles each competitor has open, what changed since the last check, and what it means.

JSearch
Google Sheets
Slack Bot
App

Run WhatsApp campaigns from one screen.

Plan, launch, compare and stop broadcasts without living in someone else's dashboard.