Extract form data and send automated email summaries
Workflow Description
Automation that receives form submissions, extracts and organizes them in Google Sheets, then uses AI to summarize the data and send comprehensive email reports automatically to designated recipients.
How it works
- 1.Receive form submissions through form trigger integration
- 2.Organize and store submitted data in Google Sheets
- 3.Extract key information and generate AI-powered summaries
- 4.Filter data based on predefined criteria and rules
- 5.Send summarized reports via Gmail to stakeholders
Use cases
- Collect customer feedback from forms and distribute daily summaries to teams
- Process support tickets and send categorized alerts with email notifications
- Aggregate marketing campaign data and share executive summaries with management
Requirements
- Google Workspace account with Sheets and Gmail access
- Permissions to read form data and write to spreadsheets
- Configured email templates for consistent report formatting
Service Value
Ideal as a smart automation service combining integrations and AI to produce ready-to-use results.
Apps Used
Details
How to Use
- 1.Click "Download Template"
- 2.Open your n8n dashboard
- 3.Go to Workflows > Import from File
- 4.Select downloaded file and configure credentials
Nodes Used (20)
Client Usage Log
Google Sheets Tool
Logging Attributes
Set
On form submission
Form Trigger
Custom LLM Subnode
Code
Sticky Note
Sticky Note
Sticky Note1
Sticky Note
Sticky Note2
Sticky Note
Sticky Note3
Sticky Note
Sticky Note4
Sticky Note
Display JSON Document
Form
Filter Last Month
Filter
Get Client Logs
Google Sheets
Calculate Totals
Summarize
Every End of Month
Schedule Trigger
Send Invoice
Gmail
Sticky Note5
Sticky Note
Sticky Note6
Sticky Note
Sticky Note7
Sticky Note
Parse PDF Upload
Extract From File
Extract Resume Data
Information Extractor