I don’t know if you’re open to a bit of coding, but I implemented a similar feature for our company recently to generate invoices based on 100% Airtable data. I had good success using Google Sheets and a Google Apps Script. Later on I switched to MS365 and Power Automate + Excel (because the company switched to that environment, not because I wanted to), which was definitely less convenient, but also worked in the end.