Consolidate Daily Google Form Submissions into One Gmail Recap

This n8n workflow receives one clean Gmail recap each day summarizing all submissions from your Google Forms linked to Google Sheets. It filters for today's entries, assembles them into a neat HTML list or table with details like submitter name, timestamp, and custom fields, then emails the recap to your inbox or team distribution list at a customizable time (default 5 PM).

Ideal for teams handling high volumes of incoming requests, such as healthcare billing and insurance queries, it eliminates notification spam by replacing dozens of individual alerts with a single digest. Managers can review summaries efficiently without constant interruptions, ensuring nothing gets overlooked while maintaining a clutter-free inbox.

Key benefits include time savings, improved organization, and scalability for multiple forms. Requirements are straightforward: Google account with Forms, Sheets, and Gmail access, plus n8n OAuth credentials. Setup involves a Cron trigger, Sheets reader, Code node for HTML formatting, and Gmail sender. Test with sample submissions, then activate for daily automation. Includes tutorial video and canvas sticky notes for easy implementation.

Use cases: Healthcare practices consolidating patient insurance forms, billing teams tracking daily claims, or any service managing form-based inquiries.