n8n Monthly Monday.com PDF Lead Reports (Gemini + Gmail)

Turn your Monday.com data into a polished PDF report every month—then send it automatically via Gmail

This n8n workflow, n8n Monthly Monday.com PDF Lead Reports (Gemini + Gmail), pulls lead records from a specified Monday.com board, generates a styled HTML report using Gemini (via OpenRouter), converts it to a PDF with PDFMunk, downloads the file, and emails it to your recipients through Gmail.

What this workflow does

• Runs monthly using a scheduled trigger.
• Fetches items from a configured Monday.com Board ID and Group ID.
• Flattens and aggregates each item’s key column values (e.g., Name, Date, Status, Owner, and contact fields) into one combined dataset.
• Generates print-ready HTML by sending the aggregated data to Gemini via OpenRouter.
• Converts HTML to PDF using PDFMunk (HTML/CSS to PDF), producing a downloadable PDF report.
• Extracts the report link from the structured AI output.
• Downloads and emails the PDF as an attachment using Gmail, including the report link in the email body.

Use cases

• Monthly lead performance reporting for SaaS teams tracking pipeline stages in Monday.com.
• Operational updates sent to stakeholders who prefer PDF summaries over dashboards.
• Consistent reporting for automation engineers who want repeatable, scheduled n8n workflows.

Technical details

• Scheduler: monthly schedule trigger.
• Monday.com integration: OAuth2, configured Board ID + Group ID; column mapping for fields like Name, Date, Status, Owner, Email, Phone, Location, Files.
• AI generation: Gemini model through OpenRouter.
• PDF generation: PDFMunk (HTML/CSS to PDF) with configurable output filename/template.
• Email delivery: Gmail OAuth2 to send the PDF attachment + message body link.
• Supporting nodes: code, aggregate, http request, sticky note (for workflow clarity).