Zapier MCP + WhatsApp → Google Sheets in 15 Minutes

WhatsApp messages flowing into Google Sheets — without writing backend code. Connect Omdaa API, Zapier MCP, and Sheets in under 15 minutes.

Architecture

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

Step 1: Enable Zapier MCP

Connect Google Sheets + Webhooks by Zapier in Cursor via the Zapier MCP plugin.

Step 2: Create Catch Hook Zap

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

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

Step 4: Test

Send a WhatsApp message — a new row appears in Omdaa WhatsApp Logs.

Template: integrations/zapier/omdaa-whatsapp-google-sheets.template.json

Omdaa API — Free Forever.