Automatic document creation and sharing from Airtable records

Ideally what I’d like is for the “page designer” block to have the ability to share its output automatically with different recipients who don’t have Airtable accounts themselves. I have a large base that is used to process reports that come in from forms. Each record is an individual report, which I can build into printable pdf using the page designer. But the only way to share these is to download each individual pdf and then send it by email. I would like to be able to automate this process, i.e. once a report is complete, the document generated by the page designer is automatically shared with a given recipient. Is this possible through Zapier, or any other platform? I’ve looked at a few google sheets add ons but I’m not sure they’re what I’m after. Thank you in advance for your advice! :slight_smile:

1 Like

Your best bet for this is probably to integrate your Airtable database with WebMerge.me (by using Zapier as the middleman).

WebMerge can automatically generate your customized PDF documents for you, email each document to the appropriate recipient, and then you can even place a copy of those PDF files back into your Airtable database for long-term storage in the appropriate records.

p.s. If you try this but it ends up feeling like it’s too complex for you to tackle on your own, feel free to send me a private message… I am a freelance Airtable consultant! :slight_smile:

1 Like

Hi @Jonathan_Bradshaw - Advanced Reporting is a Service we offer (and have ability to send out on scheduled basis)

https://openside.com/airtable-services

Feel free to reach out at dan@openside.com to learn more

Thanks Scott - I’ve been looking at Webmerge; it does the job I want it to do but it’s quite expensive considering the quantity of documents I’d need to process (around 500 per month). I need for every new record in a view to trigger the creation of a pdf document that would then be emailed automatically to a given recipient (also determined from data within the base). I’ve looked at google sheets and some add ons that can be added to that that would achieve the same output, but I’m concerned about google’s data protection policies. The data is sensitive personal data and I need it to be secure end-to-end, such that only the intended recipient can ever access it. Airtable data protection policies are much more robust in this regard I think.

I’ve done exactly this using Google Apps Script and G-Suite with full security measures for HIPPA.

The key is to start with a paid G-Suite account ($10/month) and use that as the basis for your web services development that taps into Airtable via its API.

Then ask Google to upgrade your G-Suite account to a security level that support HIPPA. They will do this on request and it’s no additional cost. It may also just be part of the G-Suite package now.

G-Suite also provides the automation framework for running serverless scripts and a fully-baked SDK for accessing documents that exist in Google Drive or accessing the data from Airtable and creating PDFs on the fly.

Lastly, the little cheap G-Suite account can email far more than 500 documents per day without cost and the domain those emails come from can be set up to be yours.

This approach is the only one that I’ve found reliable, secure, fully customized, and commercial grade (i.e., it looks and feels like your private solution).

2 Likes

Hi Bill. I think I have GSuite. What are the steps/clicks in airtable to get the page designer to convert to PDF and then email the PDF attachment? Hoping you can help. Thx.

Hi Lucy!

There are no such steps to make that possible (that I’m aware of).

Unfortunately content in Page Designer stays in Page Designer unless you physically (and manually) use the features provided in the block to create a process with its content. There is no automation of printing, or queuing into another process for distribution. And there is no API into the content created by Page Designer.

Ergo, Page Designer is a nice friendly cul-de-sac.

The way I created an automated and highly visual process is to pull the data from Airtable (via the API) into the G-Suite environment using Google Apps Script. Then, using the native aspects of Google Docs and Slides I built various report templates with placeholders for the data including text narratives and charts.

Then I created a simple table (in Airtable) so users could administer automation properties such as how often a report was generated, who should receive it, and the template it should be based on.

Lastly, I built the scripting process to do it all without any manual process. This involves establishing repeatable processes that use Google’s integrated chron-job platform for running scripts at various intervals.

As you can see, this is not a product or a recipe, there are succinct steps and clicks anyone could follow. Rather, it is a solution crafted for a business that embraces automation process to make its workers productive and especially where data and visualizations are key to their communications success.

All I did was leverage the great elements of Airtable which the client loves, and make it possible to build and manage the reporting process far beyond anything we could ever expect Airtable to provide.

Here’s an example output. All of the data in these pages came from Airtable.

Awesome work around Bill - can you share how you did this?

@Matt_Lindop,

It’s quite simple -

  • Google Apps Script reads the Airtable data into an array structure (using the API).
  • The array is transformed into various objects - titles, texts, charts.
  • The objects are replaced into a Google Doc report template.
  • The report template is exported into Drive as a PDF.
  • The PDF is attached to a gmail message and dispatched to the designated recipients.
1 Like

Hello Bill,

Thank you for writing about your workflow.
I’m no programmer but i would love to create a workflow like the one you describe here for ceating and sending invoices.

Could you explain me in a bit more detail how you achieved this? :slight_smile:

Thank you

In my view, to replicate this you’ll need Javascript skills and specifically the flavor of Javascript that is provided by Google Apps Script.

Google Apps Script is a superset of server-side javascript. One advantage is you don’t need to worry about deploying your solution onto your own server and then configuring it to run every five minutes looking for new Airtable changes indicating it’s time to build another invoice.

With Google Apps Script you need only worry about using the vast features for document creation, and attaching documents to email messages that are sent automatically.

But that is a lot to choke down for a non-programmer. If you want become proficient at this, I would start with this introduction by Ben Collins.

I think almost everyone can become a javascript programmer - they just need a place to do it and one where business elements are integrated and preferably free. Only Google’s platform makes this possible. It’s how learned more than ten years ago and it’s proven to be an ideal platform for big enterprises and small businesses.

I would love to hand over the code for the project shown above, but it belongs to a company in the UK. It was originally developed in 2005 to use data in Google sheets and recently updated to pull its data from Airtable.

1 Like

I understand. Thanks Bill. I’ll definitely try it out :slight_smile:

Hey @Bill.French this is exactly what I need, I’ve been racking my brains trying to solve this for weeks. Do you do private work at all to set this up for me? :slight_smile:

@Aaron_Marc_Georgiou,

Sure - give me a shout @ Bill.french@gmail.com.