Zapier MCP + WhatsApp Google Sheets in 15 Minutes

#zapier #whatsapp #automation #tutorial

WhatsApp messages flowing into Google Sheets — without writing a line of backend code. In this tutorial you connect Omdaa API, Zapier MCP, and Google Sheets in under 15 minutes. Part of the Free Forever WhatsApp Dev series.

Full version on omdaa.com blog

Why Zapier + Omdaa?

Free Forever Omdaa API — unlimited WhatsApp sessions & webhooks
Zapier MCP — manage automations from your AI editor (Cursor)
Google Sheets — instant CRM / message log with zero code
Works alongside n8n if you prefer self-hosted

Architecture

WhatsApp → Omdaa Webhook → Zapier Catch Hook → Google Sheets Row

Step 1: Enable Zapier MCP

In Cursor, connect Google Sheets and Webhooks by Zapier via the Zapier MCP plugin. Authenticate your Google account when prompted.

Step 2: Create Catch Hook Zap

Trigger: Webhooks by Zapier → Catch Hook
Action: Google Sheets → Create Spreadsheet Row
Map fields: Timestamp, From, Message, Session ID, Event

Copy your Catch Hook URL (https://hooks.zapier.com/hooks/catch/...).

Step 3: Point Omdaa webhook to Zapier

OMDAA_API_KEY=your-key \
ZAPIER_WEBHOOK_URL=https://hooks.zapier.com/hooks/catch/XXX/YYY/ \
node backend/scripts/setup-n8n-webhook.js

Or via SDK:

await client.webhooks.set({
  url: 'https://hooks.zapier.com/hooks/catch/XXX/YYY/',
  enabled: true,
  events: ['message', 'message.received'],
});

Step 4: Test with sample payload

{
  "event": "message.received",
  "sessionId": "default",
  "data": {
    "from": "201234567890",
    "text": "Hello from customer",
    "messageId": "ABC123"
  }
}

A new row appears in Omdaa WhatsApp Logs instantly.

What's next?

Omdaa API — Free Forever. Get started →

DEV Community