Skip to main content

How to generate PDFs based on options chosen in Airtable form

  • September 11, 2020
  • 1 reply
  • 7 views
C

Hi everyone,

I’m trying to create a PDF generation automation. I have a number of PDF “concept notes” each of them tied to a particular option I’d like to list in a form. I would like users to be able to use a multi-select option in the form to select which concept note they would like to be emailed, and have the automation merge all the options they selected into a single PDF, then email that to the user. I’m not sure how to design the automation to search for the docs (in a Google Drive) based on the form responses. How would you go about setting up such an automation? Any feedback or ideas welcome!

Thank you:)

1 reply

B
Forum|alt.badge.img+19
  • Bill_French
  • Inspiring
  • 3263 replies
  • September 12, 2020

Sort’a like this, or this I suspect.

I believe you are looking for this exact process leveraging Google Apps Script in G-Suite with Google Docs and Google Drive. I build these all the time where solutions like Integromat and Zapier are unable to meet all of the workflow requirements. But, you may want to give these tools a try first by reading this first.


Terms & ConditionsAccessibility statement