Here’s my problem: I need to periodically print NICE-LOOKING reports from Airtable data, displaying dozens of records on a single page, in spreadsheet form. The standard “Print View” action doesn’t provide enough control (formatting of text, sizing of columns, custom headers & footers, etc). The new Print Layout Designer is a wonderful tool, but it only allows for one record per page.
The best option I’ve found so far is to copy-and-paste data from a given Airtable View into a Google Sheets worksheet. This gives me most of the formatting options I want, but it’s just really cumbersome to do this over and over, and I’m worried about the potential for human error. So, I’d love an automated way of doing this.
Zapier has a similar integration (https://zapier.com/app/editor/template/7324), but this doesn’t work for me, because it only sends NEW records to the sheet. If values change in an existing record (which mine do constantly… it’s exactly what we’re tracking!), the Zapier solution is worthless to me. I understand this is a limitation of the Airtable API, not Zapier.
Does anyone have a solution/idea/product/etc to automatically send ALL data (not just new records) from an Airtable view to Google Sheets or a similar app that gives me robust formatting control? Or even better, a means of converting airtable data into a custom printable format? Or anything else that would solve my problem?