Skip to main content

Page Designer automation?


Forum|alt.badge.img+6

Is there a way to automatically generate and download/send a pdf of a page designer? Or has anyone found a way to do this with zapier or similar?

Our use case: We generate several reports a night which need to be sent to a distribution list. Right now an employee has to manually print as pdf and re-upload it to airtable โ€“ after that the automation sends it out. It would be amazing if we could skip that one last manual step.

10 replies

  • New Participant
  • 1 reply
  • December 9, 2018

I just sent a similar inquiry to Airtable support. I have a similar use case whereby I have a new record created via Zapier and would like Page Designer to autogenerate the pdf report and save it into a field under that same record. Then I could use the email integration to autosend the report with an email template to the corresponding record email address. How sweet would that beโ€ฆ


jowan_qupty
Forum|alt.badge.img+10
  • Known Participant
  • 25 replies
  • December 9, 2018

It is possible with Integromat:

Youโ€™d have to create the following scenario:

  1. receive trigger from Airtable
  2. create PDF of the data using the PDF module (This will take an HTML template and create a pdf out of it)
  3. send the pdf through gmail/mail module Or do anything else youโ€™d like (upload to Airtable/driveโ€ฆ)

  • New Participant
  • 1 reply
  • December 31, 2018
jowan_qupty wrote:

It is possible with Integromat:

Youโ€™d have to create the following scenario:

  1. receive trigger from Airtable
  2. create PDF of the data using the PDF module (This will take an HTML template and create a pdf out of it)
  3. send the pdf through gmail/mail module Or do anything else youโ€™d like (upload to Airtable/driveโ€ฆ)

Hi Jowan. Could you please elaborate a little more on this scenario? I had never heard of Integromat but it looks amazing. Iโ€™m trying to build a PDF from airtable uploaded media (photos). Do you have any good links for instructions on how to connect Airtable to produce PDF reports with Integromat?
Thanks


jowan_qupty
Forum|alt.badge.img+10
  • Known Participant
  • 25 replies
  • January 15, 2019
Pablo_Ambram wrote:

Hi Jowan. Could you please elaborate a little more on this scenario? I had never heard of Integromat but it looks amazing. Iโ€™m trying to build a PDF from airtable uploaded media (photos). Do you have any good links for instructions on how to connect Airtable to produce PDF reports with Integromat?
Thanks


Hi Pablo,

Apologies for the late reply.
Iโ€™m not aware of any online tutorials that show you how to automate this process but hope this can help.

Below is my Integromat Scenario which does the following:

  1. (Trigger: Using Airtable Module): You watch for a new record in a view.

  2. (Action: Using the PDF Module): You create a pdf using HTML (or plain text), therefore allowing you to bypass the page designer block until they release an API for it. This is a very helpful tool that will convert to HTML if you donโ€™t know HTML --> https://wordtohtml.net/

  3. (Action: Using the Google Drive Module) Ideally, we would directly upload that pdf straight to Airtable. However, since the previous PDF module can only spit out a url for the newly created pdf and not the actual file, then what I did was upload this url into Google drive, which you can then fetch as an actual attachment.

  4. (Action: Using the Airtable Module): You fetch the attachment from Google Drive, and upload it to wherever youโ€™d like in Airtable.

  5. From here itโ€™s really up to you. You can do whatever youโ€™d like. you can send the attachment by email, smsโ€ฆetc or automate anything else.

Hope this helps.


Forum|alt.badge.img+3
jowan_qupty wrote:

Hi Pablo,

Apologies for the late reply.
Iโ€™m not aware of any online tutorials that show you how to automate this process but hope this can help.

Below is my Integromat Scenario which does the following:

  1. (Trigger: Using Airtable Module): You watch for a new record in a view.

  2. (Action: Using the PDF Module): You create a pdf using HTML (or plain text), therefore allowing you to bypass the page designer block until they release an API for it. This is a very helpful tool that will convert to HTML if you donโ€™t know HTML --> https://wordtohtml.net/

  3. (Action: Using the Google Drive Module) Ideally, we would directly upload that pdf straight to Airtable. However, since the previous PDF module can only spit out a url for the newly created pdf and not the actual file, then what I did was upload this url into Google drive, which you can then fetch as an actual attachment.

  4. (Action: Using the Airtable Module): You fetch the attachment from Google Drive, and upload it to wherever youโ€™d like in Airtable.

  5. From here itโ€™s really up to you. You can do whatever youโ€™d like. you can send the attachment by email, smsโ€ฆetc or automate anything else.

Hope this helps.


Hi, apparently the PDF module isnโ€™t available in Integromat ? Any idea why ?


ScottWorld
Forum|alt.badge.img+33
  • Brainy
  • 8782 replies
  • May 24, 2020
Quentin_Zakoian wrote:

Hi, apparently the PDF module isnโ€™t available in Integromat ? Any idea why ?


Integromat disabled it due to security issues. Here are some other workarounds, using the Integromat platform: https://www.integromat.com/en/requests/requests-to-update-existing-apps/p/pdf

Note that you can also use the Formstack Documents Block (which is built into Airtable) to create PDF files as well, but that does require a paid Formstack Documents account.

Similar thing with this extension and a paid DocuPilot account.


Forum|alt.badge.img+5
  • Participating Frequently
  • 7 replies
  • August 5, 2020

Two new possible solutions.



Hi there! I believe that @Ben_Lillie solved the problem but still decided to share an idea that the job could be done using Zapier and Plumsail Documents. Maybe, someone else would find this useful.
I tried the app to generate reports based on Airtable data. For the case from the question, the Zap could be two-step - Airtable trigger, Plumsail Documents action launching the process of PDF generation. Inside the process, itโ€™s possible to set up various deliveries - sending by email as well.


Forum|alt.badge.img+18

Just wanted to add DocsAutomator to this thread. It's a flexible and powerful solution to turn Airtable data into PDF + Google Docs and has been helping many Airtable users overcome Page Designer's limitations ๐Ÿ™‚ 


Forum|alt.badge.img+8
  • Participating Frequently
  • 68 replies
  • November 30, 2024

As an alternative, you can use typeflow.us. it will help you to generate PDFs based on Airtable data. We use Google Docs as template.
We offer a lifetime plan currently at 150$. This plan lets you generate as many pdf as needed.


Reply