Have you tried an automation tool like Zapier or Make? They typically have modules that handle all the details of the API integration like Authentication so you put together a workflow without code. 

I did find a third party solution that we are taking a look at. Much more ronust functionality than Airtable's native Page Designer: Document Generation & Automation | DocumintLooks very Promising!

I think this is a must have features. The whole point of airtable is to manage long lists of data . . . if you can't print out that data on an invoice or inventory list, whatever your use case, that makes the data pretty useless. Sometimes you need a...

Was wondering if you were able to make any head way on this. We are looking to do the same, format the google sheet dynamically. Documint works for invoices, but this are more dynamicaly created spreadsheets that will be editied by users. Documint do...

Did you ever find a solution for this? Looking to do somethign similar to find weighted averages or two rollup fields.