Collect form-based report requests and send pdfmill PDFs via Gmail and Drive
UnknownUnknown. This template uses community nodes we can't verify statically. Uses community nodes that can't be verified statically (unverified community packages are off by default in 3.0). Static check, last run 2026-10-19.
What this workflow does
This workflow has 11 nodes and runs when someone submits an n8n form (“Request a report”). Along the way it connects Gmail, Google Sheets, Google Drive and Pdfmill (community).
How it runs
Trigger: When someone submits an n8n form (“Request a report”).
- Parse and validate the request (Code): runs custom JavaScript code
- Is the request valid? (If): checks a condition and branches into true / false
- Load matching metrics from Google Sheets (Google Sheets): read (sheet)
- Email request corrections (Gmail): uses Gmail
- Build the report from metric rows (Code): runs custom JavaScript code
- Were matching metrics found? (If): checks a condition and branches into true / false
- Generate the report PDF (Pdfmill): template
- Email that no metrics matched (Gmail): uses Gmail
- Archive the report in Google Drive (Google Drive): upload (file)
- Email the finished report (Gmail): uses Gmail
Services it uses
Before you upgrade to n8n 3.0
We can't fully verify this one: it relies on 1 community package, and n8n 3.0 turns unverified community packages off by default (N8N_UNVERIFIED_PACKAGES_ENABLED=false).
- Check that n8n-nodes-pdfmill is verified or supports 3.0 (used in Generate the report PDF).
Nodes used (7)
- n8n Form Trigger
n8n-nodes-base.formTrigger - Code
n8n-nodes-base.code - If
n8n-nodes-base.if - Gmail
n8n-nodes-base.gmail - Google Sheets
n8n-nodes-base.googleSheets - Pdfmill
n8n-nodes-pdfmill.pdfmill - Google Drive
n8n-nodes-base.googleDrive
From the author
Quick overview Turn a shared Google Sheets metrics table into validated, branded PDF reports with correction handling, no-data notifications, Google Drive archiving, and Gmail delivery. How it works 1. Collects the report title, report key, period, recipient…