n8n Report Request Automation: pdfmill PDF via Gmail & Drive

Automatically generate and deliver PDF reports from n8n Form submissions—via pdfmill, Google Drive, and Gmail.

This n8n workflow turns inbound report requests into branded PDF files using pdfmill, uploads them to Google Drive, and emails the PDF to the requester through Gmail. Ideal for n8n users and automation engineers who want a reliable “request → generate → store → deliver” pipeline.

What this workflow does

• Collects report requests from an n8n Form, capturing the report title, requested period, recipient email, and optional notes.
• Builds a structured report dataset from the form answers, including derived start/end dates for the selected period and report content sections (sample KPI/section content is included and can be replaced with your real metrics).
• Generates a branded PDF by sending the report dataset to pdfmill and rendering the available “report” template.
• Saves the PDF to Google Drive using the report title/period as the filename (uploaded to your selected Drive and folder).
• Emails the PDF attachment to the requester using Gmail credentials.

Use cases

• Operations teams request weekly/monthly performance summaries from internal stakeholders.
• SaaS operators automate ad-hoc report delivery without manual PDF generation.
• Support or success teams collect customer report requirements and send finalized PDFs automatically.

Technical details

• n8n Form Trigger to receive report title, period, recipient email, and notes.
• Code node to transform form answers into the report payload (including derived date ranges and content dataset).
• n8n-nodes-pdfmill (pdfmill) to render the “report” template into a PDF.
• Google Drive integration to upload the generated PDF to a specified folder.
• Gmail integration to email the PDF attachment to the recipient.

Setup checklist

• Add pdfmill credentials (API key) and confirm the report template exists.
• Configure Google Drive credentials, target Drive, and upload folder.
• Configure Gmail credentials for the sending mailbox.
• Share the n8n Form URL (or embed it) and optionally replace the sample KPI/section data source in the workflow code.