Skip to content
ClickRuntime

Connect Supabase to WhatsApp Business

Supabase holds your product data, customers and bookings, and WhatsApp is where many customers want to talk. Connecting them lets customers get answers, place orders and receive reminders on WhatsApp, with everything recorded in your own database.
Add to ChatGPTAdd to Claude
Works inChatGPTClaudeClaude CodeCursorCodexVS CodeGemini CLIZedopencodeAny MCP client

Ideas

What you can do with Supabase and WhatsApp Business

WhatsApp conversations answered from and recorded in your Supabase database. These are ready-made starting points. Anything else you can describe works too.
The moment it happensAI

Answer WhatsApp questions from your Supabase knowledge base

Customers who message you on WhatsApp get an answer drawn from the docs or catalogue in your Supabase database, and you're emailed the questions it couldn't answer.

See how it works
The moment it happensAI

Log WhatsApp requests in Supabase by category and urgency

Every WhatsApp request is sorted by type and urgency, saved in your Supabase table and acknowledged, with urgent ones emailed to you.

See how it works
Every 5 minutesAI

Reply to new leads on WhatsApp in a matching tone

New leads saved in Supabase get a WhatsApp reply chosen to match the tone of their message, and the lead is marked as contacted.

See how it works
The moment it happensAI

Take WhatsApp orders into Supabase

Customers order or ask for a quote on WhatsApp, the items are priced from your Supabase menu, the order is saved and they get a summary back.

See how it works
On a schedule

Send WhatsApp reminders for due dates in Supabase

People with a fee, renewal or appointment coming up get a WhatsApp reminder, and the row is marked so they aren't reminded twice.

See how it works Your own logic

Any other automation you can describe in words

Your own rules, schedule and AI steps with Supabase and WhatsApp Business, plus any other app. Describe it and your assistant builds it.

See how to build your own

Build your own

Build any Supabase and WhatsApp Business automation you can describe

The ideas above are ready-made starting points, not a fixed list. Describe what should happen between Supabase and WhatsApp Business in your own words, with your conditions, other apps or an AI step, and your assistant writes it, tests it and runs it on ClickRuntime.

  • Your own rules

    Conditions, thresholds, filters and exceptions, written the way you'd explain them to a colleague.

  • Any number of apps

    One automation can read from one app and update several others. Over 248 apps are ready, and anything with an API works too.

  • AI where it helps

    Summaries, classification, extraction and drafts use ClickRuntime's built-in AI, with no extra key.

  • On a schedule or on each event

    Runs as often as every 5 minutes, or the moment an app sends an event, and keeps track of what it already handled.

For example, ask your assistant

When an order row in Supabase changes to Delayed, send a WhatsApp message to the customer only if they have not been messaged about that order in the last 24 hours.

When a WhatsApp message asks about a booking, look up the phone number in my Supabase bookings table and reply with the booking date, or ask for the booking reference if none is found.

Use cases

Why people connect Supabase and WhatsApp Business

How the two apps work together

  • Supabase database webhooks can call a trigger link when rows are inserted or updated, or the script checks a table every few minutes.
  • WhatsApp messages reach a trigger link right away through the WhatsApp Business Platform webhook.
  • The script reads and writes Supabase rows through its API and sends WhatsApp messages in response.

  • Apps notify users on WhatsApp

    When a row in a Supabase table changes, like an order status, the user gets a WhatsApp update. The app gets messaging without new backend code.

  • Support bots answer from product data

    WhatsApp questions are answered using data in Supabase tables, such as booking or order details. Customers get real answers, not a menu.

  • Teams log every conversation

    Incoming and outgoing WhatsApp messages are stored in a Supabase table. Conversation history can be queried and shown in the app.

  • Founders run opt-in campaigns

    Contacts in a Supabase table who opted in receive a WhatsApp template campaign. Send status is written back per contact.

More apps

Supabase, WhatsApp Business and other apps in one automation

An automation isn't limited to two apps. Add the next step in another app and it runs as part of the same automation.

WhatsApp chats stored in Supabase with Slack alerts

Store each incoming WhatsApp message in my Supabase messages table and post in #support on Slack when the AI marks one as urgent.

Payment confirmations on WhatsApp

When a Stripe payment succeeds, update the order in my Supabase orders table to Paid and send the customer a WhatsApp confirmation template.

Answer with embeddings from Supabase

When a WhatsApp question comes in, use OpenAI embeddings to search my Supabase documents table and reply with the best answer.

Setup

Connect Supabase and WhatsApp Business once

Every idea on this page uses the same two connections, so you set them up once. If one is missing, your assistant tells you and links to the right place.

Supabase

Developer / Database & backend

  1. In your Supabase project, open Settings, then API Keys, and copy or create a secret key (it starts with sb_secret_).
  2. Note your project URL, which looks like https://<project-ref>.supabase.co.
  3. If an automation needs the Management API, go to Account, then Access Tokens, and generate a new token.
  4. In the ClickRuntime dashboard, open Connections & secrets and save the project URL and secret key (and the access token, if you made one).

WhatsApp Business

Messaging

  1. At developers.facebook.com/apps, create a Business app and add the WhatsApp product to it.
  2. In business.facebook.com, open Business Settings, go to System users and add one. Assign it the app with Manage app and your WhatsApp account with Manage WhatsApp Business accounts.
  3. Generate a token for that system user, select the app and add business_management, whatsapp_business_messaging and whatsapp_business_management, then copy it.
  4. Under WhatsApp, API Setup, note your Phone Number ID and WhatsApp Business Account ID.
  5. In the ClickRuntime dashboard, open Connections & secrets and save the token as a secret for WhatsApp Business, along with the two IDs.

FAQ

Questions about connecting Supabase and WhatsApp Business

Which Supabase key should I use?
A secret (service role) key saved in your ClickRuntime dashboard, so the automation can read and write the tables it needs. It's never shown in logs.
Do I need the WhatsApp Business API?
Yes. These use the WhatsApp Business Platform from Meta. Set up a number in Meta's developer dashboard and save its token in your ClickRuntime dashboard.
Why do some messages need an approved template?
WhatsApp only lets businesses start a conversation, or write more than 24 hours after the customer last messaged, with a template Meta has approved. Replies within 24 hours can be free text.
Do my tables need a particular structure?
Each automation lists the columns it uses, such as phone, status and created_at. You can map them to the names you already have.
Which Supabase key should it use?
For server-side scripts the service role key is common, but use the least access you need and keep the key only in the ClickRuntime dashboard.
Does it work with Row Level Security?
The service role key bypasses Row Level Security. With the anon key, your policies apply to what the script can read and write.
Can it store media in Supabase Storage?
Yes. Images or voice notes from WhatsApp can be uploaded to a Supabase Storage bucket.

Related pages

Keep exploring

Tell your assistant what Supabase and WhatsApp Business should do together

Free plan. No credit card.

Add to ChatGPTAdd to Claude