Is there a non paid method to send data as a PDF format to an email? A potential client wants to automate printing packing slips from Shopify orders.
The volume would be around 3.5 - 4K slips printed per month. From my end I’m just recreating their existing invoice in HTML and converting that to a PDF format.
The automation would:
Grab all order numbers specified in a Google sheet
Get the order details from shopify
Populate the html template
Send an email with all pdfs
It’s a manual process at the moment and they would like to print the packing slips in one go.
My next question is sending a bulk email like this would be inefficient, maybe could be sent to a google drive folder with the a time stamped folder, and an email with a link to that folder.
Would I also need to add a sleep timer? As this would be downloading more than 100 in one go.
Just thinking how to optimise this entire process so they don’t blast through operations
Basically they don’t want to have to go into shopify and manually print each order packing slip for each order one at a time.
They’d rather print all in one go, so having all packing slip pdfs ready to print would be ideal for them.
As there’s no way to connect to Shopify apps, I was thinking of recreating the packing slip PDF as a Google doc then mapping the data from Shopify to all the sections in the doc.
From there I would convert that to a PDF and then send that as an email. This would be done for all they always on a daily basis, which runs into the hundreds.
They don’t want to pay too much for a third party pdf tool, so I’m trying to go down this route instead.
Also thinking of possible rate limits in doing this and whether I need a sleep module just in case.
Yeah you can get the Google doc as pdf directly, no need to use third party converters.
And the rate limit you might reach is the Make 45 mine timeout if there are too many items that need processing, but you will need to test this further.