From Airtable, yes if you have the concatenated PDF in an attachment field. But, I think you’re still a ways off from achieving that.
This is one of many complexities that push me to design systems that blend artefacts and data by using custom integrations that offer scale without added cost. Imagine a single Google Apps Script process that listens for an Airtable record ID and upon receipt…
- Fetches the Airtable record;
- Unpacks all of the PDF attachments;
- Compiles a single Google Document report based on a Google Doc template (the PDFs are simply embedded images in the Google Doc;
- Adds headers, footers, other narrative content and even other Airtable field data to the report;
- Converts the final Google Doc report into a single PDF;
- Stores the PDF into Google Drive; uploads the report into Airtable (wherever needed);
- Creates an email message with narrative, etc; attaches the PDF report; send it;
- Updates an Airtable record with date/rime of the transmission and a copy of the email sent.
I have a general policy not to use anything that has the word “monkey” in it. There are exceptions, of course, and this one looks like what you might need. However, it has a low ceiling for the free tier, so there’s that.
One point I might make - these items are stored in Airtable as PDF documents; that’s a red flag to me because it is far easier to blend binary objects that are images rather than PDF documents. For example, embedding five JPGs into a single document is very easy to do, whereas, blending five PDFs into a single PDDF document is a sh*tshow and should be avoided altogether (if possible).