Quick Overview
Quick Overview This workflow runs monthly to pull items from a Monday.com board, transform and aggregate them into a dataset, generate a styled HTML-to-PDF report using Gemini via OpenRouter and PDFMunk, then downloads and emails the PDF report through Gmail. How it works Runs on a monthly schedule trigger. Retrieves all items from a specified Monday.com board and group. Flattens each item’s key column values (for example Name, Date, Status, Owner, and contact fields) and aggregates all rows into one dataset. Sends the aggregated data to Gemini (via OpenRouter) to generate a print-ready HTML report and converts it to a PDF using PDFMunk. Extracts the generated report link from the structured AI output. Downloads the PDF from the report link and emails it as an attachment via Gmail, including the link in the message body. Setup Add a Monday.com OAuth2 credential and set the correct Board ID and Group ID for the board you want to report on. Ensure your Monday.com board includes column titles that match the mapping (Name, Date, Status, Owner, Email, Phone, Location, Files) or update the mapping in the transformation step. Add an OpenRouter API credential and select the Gemini model you want to use for HTML generation. Add a PDFMunk (HTML/CSS to PDF) API credential and configure the output filename/template if needed. Add a Gmail OAuth2 credential and set the recipient email address and subject/body content for the report email. An n8n automation workflow template by Fahmi Fahreza.
Fahmi Fahreza
web
free
Others in the same category, ranked by how often they are opened.
