AutoDocument: https://github.com/TomMalkin/AutoDocument

Imagine your basic Excel spreadsheet -> generating document files, but add:

- Other sources like SQL queries

- User form (e.g. "Generate documents for Client Category [?]")

- Chaining sources in order like SQL queries with parameters based on the user form

- Split at multiple points (5 records in a csv, 4 records in a sql result = 20 generated documents)

- Full Jinja2 templating with field substitution but also if/for blocks that works nicely with .docx files

- PDF output

- output file names using the same templating: "/BusinessDrive/{{ client_id }}/Invoice - {{ invoice_id}}.pdf"

All saved in reproducible workflows (for example if you need to process a .csv file you receive each morning)