Bulk generate payment reminder PDFs from NocoDB with Autype


⚠️ Important: This workflow uses the Autype community node and requires a self-hosted n8n instance.

This workflow reads overdue invoices from a NocoDB database, generates a personalized payment reminder PDF for each record using the Autype Bulk Render API, and sends the resulting ZIP archive by email via SMTP. Days overdue are calculated automatically from the due date at runtime. Supported output formats: PDF, DOCX (Word), ODT.

Who is this for?

Finance teams, accounting departments, and developers who want to automate recurring document generation from database records. Good fit for payment reminders, invoices, collection letters, dunning notices, or any business correspondence that goes out in batches.

What this workflow does

It reads all overdue invoices from a NocoDB table, maps each row to a set of document variables, and sends everything to the Autype Bulk Render API in a single batch request. The result is a ZIP archive with one PDF per invoice, which gets sent by email via SMTP on a weekly schedule.

The included payment reminder template includes: - Company logo in the header, page numbers in the footer - Customer name and full address block - Invoice details table with USD amounts - Styled table with alternating row colors - Automatic date insertion via {{date/DD.MM.YYYY}} - Days overdue calculated at runtime from duedate (no separate DB column needed)