{"product_id":"whatsapp-to-google-sheets-lead-capture-instant-hebrew-auto-reply","title":"WhatsApp to Google Sheets Lead Capture + Instant Hebrew Auto Reply","description":"\u003ch3\u003eTurn every incoming WhatsApp message into a Google Sheets lead—plus an instant Hebrew auto-reply\u003c\/h3\u003e\n\u003cp\u003eStop losing WhatsApp inquiries. This n8n workflow captures each inbound WhatsApp message, saves the sender as a structured lead row in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, and immediately sends a \u003cstrong\u003eHebrew confirmation\u003c\/strong\u003e message back to the sender—so no lead sits unanswered on your phone.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives inbound WhatsApp messages\u003c\/strong\u003e via a webhook from \u003cstrong\u003eWAHA\u003c\/strong\u003e or the \u003cstrong\u003eWhatsApp Cloud API\u003c\/strong\u003e (both payload shapes are handled).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFilters out\u003c\/strong\u003e irrelevant messages on purpose, including \u003cstrong\u003egroup chats\u003c\/strong\u003e and \u003cstrong\u003eyour own outgoing messages\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eUses a \u003cstrong\u003eCode\u003c\/strong\u003e node to extract the sender \u003cstrong\u003ename\u003c\/strong\u003e and \u003cstrong\u003emessage text\u003c\/strong\u003e, and \u003cstrong\u003enormalizes the phone number to E.164\u003c\/strong\u003e format (default prefix \u003cstrong\u003e+972\u003c\/strong\u003e, easily changed).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppends a lead row\u003c\/strong\u003e to your Google Sheet with: \u003cstrong\u003eTimestamp | Name | Phone | Message | Source\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eSends an \u003cstrong\u003einstant auto-reply in Hebrew\u003c\/strong\u003e back to the sender within seconds (the text is fully editable).\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eInbound WhatsApp inquiries for \u003cstrong\u003eservices\u003c\/strong\u003e captured automatically and logged for follow-up.\u003c\/li\u003e\n  \u003cli\u003eLead collection for \u003cstrong\u003eHebrew-speaking businesses\u003c\/strong\u003e that need a fast “We received your message” response.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers using n8n to convert real-time chat messages into a \u003cstrong\u003eCRM-like spreadsheet\u003c\/strong\u003e without extra tools.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes used:\u003c\/strong\u003e webhook, Code, HTTP Request, Google Sheets, plus Sticky Note for guidance.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWhatsApp integrations:\u003c\/strong\u003e WAHA or Meta’s WhatsApp Cloud API (webhook Production URL required).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets:\u003c\/strong\u003e appends a new row to the selected spreadsheet tab.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSecurity setup:\u003c\/strong\u003e adds \u003cstrong\u003eHeader Auth\u003c\/strong\u003e using \u003cstrong\u003eX-Api-Key\u003c\/strong\u003e for your WAHA API key.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eBuilt by \u003cstrong\u003eAchiya Automation\u003c\/strong\u003e: \u003ca href=\"https:\/\/achiya-automation.com\" target=\"_blank\" rel=\"noopener\"\u003ehttps:\/\/achiya-automation.com\u003c\/a\u003e.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45837471219891,"sku":"N8N-18197","price":39.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/BE8lbuYKoq7qmDsOwf-do_4GItBP4p.png?v=1786794845","url":"https:\/\/buyflowscripts.com\/products\/whatsapp-to-google-sheets-lead-capture-instant-hebrew-auto-reply","provider":"N8N Commerce","version":"1.0","type":"link"}