Send on-demand CSV report summaries from Google Sheets forms via Gmail
Ready for 3.0What this workflow does
This workflow has 9 nodes and runs when someone submits an n8n form (“Request a Report”). Along the way it connects Google Sheets and Gmail.
How it runs
Trigger: When someone submits an n8n form (“Request a Report”).
- Validate & Pick Report (Code): runs custom JavaScript code
- Read Sheet Rows (Google Sheets): uses Google Sheets
- Filter & Aggregate (Code): runs custom JavaScript code
- Any Rows In Range? (If): checks a condition and branches into true / false
- Create CSV Attachment (Convert to File): converts data to a file (csv)
- Email 'No Data' Notice (Gmail): uses Gmail
- Build Email Body (Code): runs custom JavaScript code
- Email Report + CSV (Gmail): uses Gmail
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (6)
- n8n Form Trigger
n8n-nodes-base.formTrigger - Code
n8n-nodes-base.code - Google Sheets
n8n-nodes-base.googleSheets - If
n8n-nodes-base.if - Convert to File
n8n-nodes-base.convertToFile - Gmail
n8n-nodes-base.gmail
From the author
Quick overview This workflow collects a report request via an n8n Form, reads the matching tab in Google Sheets, filters and aggregates rows by a date range, and emails the requester an HTML summary plus a CSV attachment using Gmail. How it works 1. Receives…