Automated WhatsApp Group Summary & Daily Reporter

This n8n workflow automates WhatsApp group communication management by receiving messages through Evolution API webhook, distinguishing group chats, handling text and audio (with OpenAI transcription), and storing data in a structured Google Sheet. A unique control panel with checkboxes allows selective enabling/disabling of summaries per group, ensuring only relevant chats are processed.

The workflow splits into two parts: message capture and storage (triggered by incoming messages) and daily summary generation (scheduled at 08:00 AM). It pulls yesterday's messages, groups them by chat, verifies enabled status, and uses GPT to create concise summaries formatted for WhatsApp delivery.

Benefits include time-saving by eliminating manual review of chat histories, customizable control for focused insights, and scalability for multiple groups. Ideal for sales teams tracking discussions, commission updates, or customer support in WhatsApp groups, reducing information overload while keeping stakeholders informed with morning digests.

Use cases: Sales managers monitoring team chats for leads/commissions, community admins summarizing discussions, or businesses automating client group recaps for better follow-up.