Quick setup

1. In your automation server, create a workflow and add a Webhook node (Method: POST). Copy its Production URL into the field below.
2. After the webhook, add two branches: a WhatsApp Business Cloud node (or an HTTP Request node to Twilio's WhatsApp API), and a Send Email node (Gmail / SMTP / Outlook).
3. The webhook sends { date, shifts, message, messageHtml, recipients }. Use message (plain text) for WhatsApp, and messageHtml (line breaks as <br>) for the email body if your Email node is set to HTML — otherwise use message there too.
4. If the email comes through blank: click "Listen for test event" on the Webhook node, then hit "Send test message" below — the server will show the exact incoming JSON. Most often the fields sit one level deeper, under body (e.g. {{$json.body.message}} instead of {{$json.message}}) — check the panel and fix the expression in your Email/WhatsApp node to match.
5. Every Send button also posts subject, dateFrom, dateTo, section and attachments — a list of { fileName, mimeType, base64 } (the Excel and the PDF of that section). In your automation server, split attachments, use a Convert to File node (“Move Base64 String to File”) and attach the binary in the Email node; use subject as the email subject.
6. Password-reset emails use the same webhook with purpose: "admin-password-reset" and only the admin email in recipients (no phone) — make sure the workflow skips WhatsApp when phone is empty.
7. Team sends (the Send to team buttons and Admin panel → Team members) use the same webhook with audience: "team" and only team members in recipients; client sends have audience: "client". Branch on audience in server if the team should get a different template or sender.
8. Loop over recipients (each has label, phone, email) so every number/address gets the message. Activate the workflow, then re-test.

Expected JSON (one object per date+shift)

[
  {
    "date": "2026-10-15", "shift": "A", "incharge": "", "dispatcher": "",
    "coal": { "trips": 120, "tons": 2600, "seams": [ { "seam": "8th", "trips": 120, "qty": 2600 } ] },
    "ob":   { "trips": 260, "cm": 5200,  "seams": [] },
    "lead": { "coalManual": 3.4, "coalFMS": 3.1, "obManual": 2.5, "obFMS": 2.2 },
    "fleet":{ "loaderIds": ["L-0034"], "tipperIds": [], "excavatorIds": [], "dumperIds": [] }
  }
]