I need help with the following problem. I use a webhook to read our bookings. This data is stored and then entered into the appropriate fields of a corresponding template. This template is then stored in OneDrive with the appropriate name. A public link is also created via which a PDF converter can access the file. Now to my problem. The document has 7 pages. In the first step, I want to convert page 3 of the Excel file to a PDF and then have it sent by email. In the last step, pages 3-6 should also be converted to PDF and sent by email. I have tried everything possible, but the PDF converters cannot produce a decent layout. Everything just shifts around.
Question
How to convert specific pages of an Excel file to PDF for email delivery
+6- Zapier Solution Partner
Hey
If you were to use Google Drive you could use the native action of Export file to convert the file to pdf.
But for Onedrive there is no native action for that but there is a workaround by directly querying the API using the Webhooks in Zapier action. Here is the API documentation for the endpoint- https://learn.microsoft.com/en-us/graph/api/driveitem-get-content-format. Here is a helpful article about querying API using Webhooks in Zapier- https://help.zapier.com/hc/en-us/articles/8496326446989-Send-webhooks-in-Zaps.
I know it can get a bit more technical and complex but if it’s important for you, you can give this approach a try. Hope it helps!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.