n8n and Google Sheets

WApp Chat accepts external automation events over HTTP, so any tool that can send JSON can trigger a workflow.

Read Automation API first for the full payload format.

n8n #

Use an HTTP Request node:

Example body:

{
  "event": "lead.created",
  "source": "n8n",
  "idempotency_key": "lead.created:{{$json.id}}",
  "contact": {
    "name": "{{$json.name}}",
    "phone": "{{$json.phone}}"
  },
  "payload": {
    "service": "{{$json.service}}",
    "city": "{{$json.city}}"
  }
}

Use a stable source ID for idempotency_key. Do not generate a random value on each retry.

Google Sheets Apps Script #

function sendWappChatEvent(row) {
  const body = {
    event: 'lead.created',
    source: 'google-sheets',
    idempotency_key: `lead-row-${row.id}`,
    contact: {
      name: row.name,
      phone: row.phone
    },
    payload: {
      service: row.service,
      city: row.city
    }
  };

  UrlFetchApp.fetch('https://wapp.chat/api/whatsapp/automation/events', {
    method: 'post',
    contentType: 'application/json',
    headers: {
      'x-wappchat-key': 'wchat_live_...'
    },
    payload: JSON.stringify(body)
  });
}

Google Sheets CSV Campaigns #

For campaign-style sending:

1. Export a CSV from Sheets.
2. Import it in https://wapp.chat/whatsapp/contacts.
3. Tag the imported contacts.
4. Create an approved-template campaign.
5. Review delivery status in WApp Chat.

See Contacts and Campaigns.

Security #

For production partner integrations:

• keep API keys server-side
• enable signed requests where possible
• use stable idempotency keys
• test with a small contact group before scaling

Continue with API Keys and Signatures.