{"product_id":"n8n-whatsapp-to-google-sheets-daily-construction-reports","title":"n8n WhatsApp to Google Sheets Daily Construction Reports","description":"\u003ch3\u003eCapture WhatsApp construction updates, auto-transcribe them, and log daily reports to Google Sheets—every day\u003c\/h3\u003e\n\u003cp\u003eThis \u003cstrong\u003en8n WhatsApp to Google Sheets Daily Construction Reports\u003c\/strong\u003e workflow turns WhatsApp voice notes, photos, and texts from construction crews into structured site logs in Google Sheets, stores photos in Google Drive, alerts managers by Gmail, and emails a per-project end-of-day report every day at \u003cstrong\u003e6pm\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTriggers\u003c\/strong\u003e when a WhatsApp message arrives or on a daily schedule at \u003cstrong\u003e6pm\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eReads the sender from the \u003cstrong\u003eGoogle Sheets “Crew”\u003c\/strong\u003e tab and matches the update to a \u003cstrong\u003eproject\u003c\/strong\u003e from the \u003cstrong\u003e“Projects”\u003c\/strong\u003e tab (optionally using a \u003cem\u003e#ProjectName\u003c\/em\u003e tag).\u003c\/li\u003e\n  \u003cli\u003eIf the sender isn’t found in the crew list, it \u003cstrong\u003ereplies on WhatsApp\u003c\/strong\u003e requesting they be added and stops processing.\u003c\/li\u003e\n  \u003cli\u003eFor registered users, retrieves WhatsApp media:\n    \u003cul\u003e\n      \u003cli\u003e\n\u003cstrong\u003eVoice notes\u003c\/strong\u003e are \u003cstrong\u003etranscribed\u003c\/strong\u003e using \u003cstrong\u003eOpenAI\u003c\/strong\u003e.\u003c\/li\u003e\n      \u003cli\u003e\n\u003cstrong\u003ePhotos\u003c\/strong\u003e are \u003cstrong\u003edescribed\u003c\/strong\u003e with OpenAI and saved to \u003cstrong\u003eGoogle Drive\u003c\/strong\u003e.\u003c\/li\u003e\n      \u003cli\u003e\n\u003cstrong\u003eText messages\u003c\/strong\u003e pass through as-is.\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003eUses OpenAI to extract structured site-log fields (e.g., \u003cstrong\u003esummary, category, hours, materials, issues, safety, and attention flags\u003c\/strong\u003e) and appends them to the \u003cstrong\u003e“Site log”\u003c\/strong\u003e tab in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eConfirms\u003c\/strong\u003e the entry back to the crew member via WhatsApp.\u003c\/li\u003e\n  \u003cli\u003eSends an \u003cstrong\u003eimmediate Gmail alert\u003c\/strong\u003e to the project report email list when the update needs attention.\u003c\/li\u003e\n  \u003cli\u003eAt \u003cstrong\u003e6pm\u003c\/strong\u003e, groups today’s “Site log” rows by project, generates a \u003cstrong\u003eper-project daily report\u003c\/strong\u003e (or a no-update notice) with OpenAI, \u003cstrong\u003eemails it\u003c\/strong\u003e, and appends a summary to the \u003cstrong\u003e“Daily reports”\u003c\/strong\u003e tab.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eForemen report progress via WhatsApp voice notes and photos; the team gets a structured daily summary automatically.\u003c\/li\u003e\n  \u003cli\u003eWhen issues or safety flags appear, managers receive a \u003cstrong\u003ereal-time Gmail alert\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003ePer-project reporting for multiple construction sites without manual spreadsheet entry.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations\u003c\/strong\u003e: WhatsApp (WhatsApp Business Cloud API credentials), \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, \u003cstrong\u003eGoogle Drive\u003c\/strong\u003e, \u003cstrong\u003eGmail\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWorkflow logic\/nodes\u003c\/strong\u003e: \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003egmail\u003c\/strong\u003e, \u003cstrong\u003emerge\u003c\/strong\u003e, \u003cstrong\u003eswitch\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAI layer\u003c\/strong\u003e: \u003cstrong\u003eOpenAI\u003c\/strong\u003e transcription, photo description, and structured extraction + report writing.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46172959735987,"sku":"N8N-20556","price":34.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/du57nqeHbGzKPQMznPiih_m078SOJr.png?v=1791365114","url":"https:\/\/buyflowscripts.com\/products\/n8n-whatsapp-to-google-sheets-daily-construction-reports","provider":"N8N Commerce","version":"1.0","type":"link"}