Consolidate Daily Google Form Submissions into One Gmail Recap

Description

Description
Receive one clean Gmail recap each day with all Google Forms submissions. The workflow reads your Form-linked Google Sheets, compiles every request submitted today, and sends a single, structured email at your chosen time—keeping your inbox tidy.

Context
Instead of receiving dozens of individual notifications, consolidate all daily form submissions into one organized email recap.

Who is this for?

Teams managing multiple incoming requests per day.

Managers who want a daily summary instead of real-time alerts.

Anyone who prefers to avoid notification spam.

Requirements

Google account with Forms & Sheets access

Google Forms linked to Google Sheets

Gmail account with n8n OAuth configured

Steps


🗒️ Use the sticky notes in the n8n canvas to:

Credentials : Add/verify Google (Sheets) and Gmail credentials in n8n.

Schedule : Add a Cron/Schedule Trigger (default: 17:00/ 5PM, your local time).

Add Google Sheets node → Read mode.

Spreadsheet: select your Form-linked sheet.

Build the Recap Body

Use a Code (Function) node to assemble a simple HTML list or table from the filtered rows.

Send Gmail : Add Gmail node and setup your team inbox / distribution list. For the body, paste the HTML body from step 5 and enable HTML.

Test & Activate : Submit a few sample responses, run once, confirm the email looks right.

Turn the workflow ON.


You’ll get this:


A structured Gmail message listing all daily submissions with: submitter name, timestamp, request details, and any custom fields from your form.

Tutorial video
Watch the Youtube Tutorial video

How it works

⏰ Trigger: workflow runs once a day at your chosen time (default 5 PM).

📑 Collects all requests from that day in the Google Sheet.

📝 Compile: Generates a recap list/table.

📝 Generates a recap list with all submissions.

📨 Sends one Gmail email summarizing all requests of the day.

About me :
I’m Yassin a Project & Product Manager Scaling tech products with data-driven project management.
📬 Feel free to connect with me on Linkedin