{"product_id":"morning-whatsapp-report-automation-with-n8n-sheets-calendar-claude","title":"Morning WhatsApp Report Automation with n8n, Sheets, Calendar \u0026 Claude","description":"\u003ch3\u003eWake up to a WhatsApp morning report—automatically\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow generates a brief, friendly \u003cstrong\u003emorning WhatsApp report\u003c\/strong\u003e every day at \u003cstrong\u003e7:00 a.m.\u003c\/strong\u003e by pulling your latest \u003cstrong\u003eGoogle Sheets inquiries\u003c\/strong\u003e, today’s \u003cstrong\u003eGoogle Calendar events\u003c\/strong\u003e, and using \u003cstrong\u003eAnthropic Claude\u003c\/strong\u003e to format everything into a message. Then it sends the report to your WhatsApp number via the \u003cstrong\u003eWhapi API\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns on a schedule\u003c\/strong\u003e every morning at 7:00 a.m.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads inquiries\/messages\u003c\/strong\u003e from a specified Google Sheets spreadsheet and sheet.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFetches today’s Google Calendar events\u003c\/strong\u003e (using the \u003cstrong\u003eAmerica\/Costa_Rica\u003c\/strong\u003e timezone), sorting them by start time.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCalculates inquiry metrics\u003c\/strong\u003e for yesterday—\u003cstrong\u003eentered\u003c\/strong\u003e, \u003cstrong\u003eattended\u003c\/strong\u003e, and \u003cstrong\u003epending\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCollects pending item details\u003c\/strong\u003e to include in the report.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFormats today’s appointment list\u003c\/strong\u003e with times.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUses Anthropic Claude\u003c\/strong\u003e to rewrite the compiled data into a short, WhatsApp-ready morning message.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends the final text to WhatsApp\u003c\/strong\u003e using an HTTP request to \u003cstrong\u003eWhapi\u003c\/strong\u003e, targeting the configured owner number in international format (no “+”).\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eService businesses that need a daily snapshot of inquiries, attendance status, and upcoming appointments.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators or automation engineers who want consistent, human-friendly WhatsApp updates without manual copy\/paste.\u003c\/li\u003e\n  \u003cli\u003eTeams using Google Sheets + Google Calendar who want reporting and messaging to happen reliably every morning.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n Schedule Trigger\u003c\/strong\u003e (daily at 7:00 a.m.)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e (read inquiries\/messages log)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Calendar\u003c\/strong\u003e (fetch today’s events, America\/Costa_Rica, order by start time)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCode\u003c\/strong\u003e node (metric calculations and report preparation)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAnthropic Claude\u003c\/strong\u003e via the n8n AI Gateway \/ Anthropic API integration (model confirmation required)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eHTTP Request\u003c\/strong\u003e node to \u003cstrong\u003eWhapi API\u003c\/strong\u003e (authenticated WhatsApp delivery)\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003ePerfect for anyone building an \u003cstrong\u003en8n automation workflow\u003c\/strong\u003e that turns business data into actionable WhatsApp updates.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46146361229491,"sku":"N8N-20236","price":53.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/nCezkdQdhLMcCJg3mKFUC_iRS3AQjt.png?v=1790846312","url":"https:\/\/buyflowscripts.com\/products\/morning-whatsapp-report-automation-with-n8n-sheets-calendar-claude","provider":"N8N Commerce","version":"1.0","type":"link"}