{"product_id":"n8n-google-forms-order-alerts-whatsapp-business-gmail-summary","title":"n8n Google Forms Order Alerts: WhatsApp Business + Gmail Summary","description":"\u003ch3\u003eInstant WhatsApp Order Confirmations from Google Forms (with Daily Gmail Summary)\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow watches your Google Forms responses, validates each order against your \u003cstrong\u003eproducts\u003c\/strong\u003e list in Google Sheets, sends \u003cstrong\u003eWhatsApp Business Cloud\u003c\/strong\u003e confirmations for valid orders, and emails you a \u003cstrong\u003edaily summary via Gmail\u003c\/strong\u003e—all automatically.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTriggers automatically\u003c\/strong\u003e when a new row is added to the \u003cem\u003e“Form Responses 1”\u003c\/em\u003e tab, and also runs on a schedule at \u003cstrong\u003e20:00\u003c\/strong\u003e for the daily summary.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLoads configuration values\u003c\/strong\u003e (including Google Sheets URL, WhatsApp phone number ID, currency, limits, and the owner email) used by both the order handling and summary paths.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidates each order\u003c\/strong\u003e by reading the \u003cem\u003eproducts\u003c\/em\u003e tab and checking fields like \u003cem\u003ename\u003c\/em\u003e, \u003cem\u003ephone\u003c\/em\u003e, \u003cem\u003eproduct\u003c\/em\u003e, \u003cem\u003equantity\u003c\/em\u003e, \u003cem\u003estock\u003c\/em\u003e, and \u003cem\u003eprice\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eClassifies orders\u003c\/strong\u003e as \u003cstrong\u003econfirmed\u003c\/strong\u003e, \u003cstrong\u003eneeds_review\u003c\/strong\u003e, or \u003cstrong\u003einvalid\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends WhatsApp template messages\u003c\/strong\u003e to customers for \u003cstrong\u003econfirmed\u003c\/strong\u003e orders using \u003cstrong\u003eWhatsApp Business Cloud\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNotifies you by email\u003c\/strong\u003e via Gmail if an order \u003cstrong\u003eneeds review\u003c\/strong\u003e, is \u003cstrong\u003einvalid\u003c\/strong\u003e, or if the WhatsApp send \u003cstrong\u003efails\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLogs every processed order\u003c\/strong\u003e to the \u003cem\u003eorders\u003c\/em\u003e tab in Google Sheets, including status, totals, and notes.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEmails a daily report at 20:00\u003c\/strong\u003e by calculating confirmed revenue and listing exceptions from today’s entries in the \u003cem\u003eorders\u003c\/em\u003e tab.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSell products via a Google Form and confirm orders instantly on WhatsApp.\u003c\/li\u003e\n  \u003cli\u003ePrevent mistakes by validating stock and pricing against a Google Sheets product catalog.\u003c\/li\u003e\n  \u003cli\u003eGet a clean daily operational summary in Gmail, including exceptions that require manual attention.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations\/logic:\u003c\/strong\u003e Google Sheets tabs “Form Responses 1”, “products”, and “orders”.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMessaging:\u003c\/strong\u003e WhatsApp Business Cloud for WhatsApp template notifications.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEmail:\u003c\/strong\u003e Gmail daily summary and exception alerts.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWorkflow tools\/nodes:\u003c\/strong\u003e if, set, code, gmail, whats app, sticky note.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eSetup checklist (required spreadsheet tabs)\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\u003cem\u003eForm Responses 1\u003c\/em\u003e\u003c\/li\u003e\n  \u003cli\u003e\n\u003cem\u003eproducts\u003c\/em\u003e (product, price, stock columns)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cem\u003eorders\u003c\/em\u003e (order_id, date, name, phone, product, qty, address, total, stat)\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46154037067955,"sku":"N8N-20279","price":11.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/Pdaw-tkUkUc1QCVnxWl_M_Biic2AKm.png?v=1790932914","url":"https:\/\/buyflowscripts.com\/products\/n8n-google-forms-order-alerts-whatsapp-business-gmail-summary","provider":"N8N Commerce","version":"1.0","type":"link"}