{"product_id":"invoice-ninja-ar-ageing-pdf-weekly-via-n8n-pdfmint-gmail","title":"Invoice Ninja AR Ageing PDF Weekly via n8n, PDFMint \u0026 Gmail","description":"\u003ch3\u003eWeekly AR ageing PDF from Invoice Ninja—automatically emailed via n8n\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow pulls your \u003cstrong\u003eactive Invoice Ninja invoices\u003c\/strong\u003e every Monday, generates a branded \u003cstrong\u003eaccounts-receivable ageing summary PDF\u003c\/strong\u003e using \u003cstrong\u003ePDFMint\u003c\/strong\u003e, and emails it through \u003cstrong\u003eGmail\u003c\/strong\u003e—so you always have an up-to-date AR ageing report without manual work.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns every Monday at 08:00\u003c\/strong\u003e on a schedule.\u003c\/li\u003e\n  \u003cli\u003eLoads your \u003cstrong\u003ecompany branding\u003c\/strong\u003e and \u003cstrong\u003ereport recipient details\u003c\/strong\u003e used throughout the report.\u003c\/li\u003e\n  \u003cli\u003eFetches \u003cstrong\u003eall active invoices\u003c\/strong\u003e from \u003cstrong\u003eInvoice Ninja\u003c\/strong\u003e, including \u003cstrong\u003eeach client’s details\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eFilters to invoices with an \u003cstrong\u003eoutstanding balance\u003c\/strong\u003e, calculates \u003cstrong\u003edays past due\u003c\/strong\u003e, and builds an \u003cstrong\u003eHTML ageing table\u003c\/strong\u003e grouped by client and bucketed into:\n    \u003cul\u003e\n      \u003cli\u003eNot-yet-due\u003c\/li\u003e\n      \u003cli\u003e1–30 days\u003c\/li\u003e\n      \u003cli\u003e31–60 days\u003c\/li\u003e\n      \u003cli\u003e61–90 days\u003c\/li\u003e\n      \u003cli\u003e90+ days\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eStops automatically\u003c\/strong\u003e if there are \u003cstrong\u003eno clients with an outstanding balance\u003c\/strong\u003e, preventing empty reports from being sent.\u003c\/li\u003e\n  \u003cli\u003eConverts the HTML report into a \u003cstrong\u003elandscape PDF\u003c\/strong\u003e using \u003cstrong\u003ePDFMint\u003c\/strong\u003e and \u003cstrong\u003eemails it as an attachment via Gmail\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eWeekly AR reporting for finance teams who need a consistent \u003cstrong\u003eInvoice Ninja ageing PDF\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators tracking overdue customers and prioritizing collections by ageing bucket.\u003c\/li\u003e\n  \u003cli\u003eAccountants using n8n to standardize branded reporting and reduce manual spreadsheet work.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSchedule:\u003c\/strong\u003e Runs every Monday at 08:00.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePDF generation:\u003c\/strong\u003e \u003ccode\u003en8n-nodes-pdfmintpdf\u003c\/code\u003e (PDFMint community node) + PDFMint API credentials.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eData source:\u003c\/strong\u003e Invoice Ninja node for active invoices and client data.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEmail delivery:\u003c\/strong\u003e Gmail node using an \u003cstrong\u003eOAuth2 credential\u003c\/strong\u003e with permission to send email.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWorkflow logic:\u003c\/strong\u003e \u003ccode\u003eif\u003c\/code\u003e, \u003ccode\u003eset\u003c\/code\u003e, \u003ccode\u003ecode\u003c\/code\u003e nodes (including an “Your company details” step).\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003cp\u003e\u003cstrong\u003eSetup quick notes:\u003c\/strong\u003e Install \u003ccode\u003en8n-nodes-pdfmint\u003c\/code\u003e, add PDFMint, Invoice Ninja, and Gmail credentials, then update company name\/address, accent colour, currency, footer note, and recipient email in the “Your company details” step.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45945681313971,"sku":"N8N-19112","price":61.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/Iq5-qSCJgroaaO63opmXR_W5Z9raRx.png?v=1788426068","url":"https:\/\/buyflowscripts.com\/products\/invoice-ninja-ar-ageing-pdf-weekly-via-n8n-pdfmint-gmail","provider":"N8N Commerce","version":"1.0","type":"link"}