How to convert a Downloaded Google Sheet file from HTML To PDF

[figuresandnumbers]

This is a follow up to this request to @Inte-graciya.expert

Automatically convert a page of a Google Sheet into a PDF through Make?

Hi Andre, Use the Google drive module “download file” and use “convert file” in the advanced settings and select convert to PDF and voila

1. I am able to open a google sheet as a PDF in the browser by using this URL type format: https://docs.google.com/spreadsheets/d/ /export?format=pdf&gid=[GID Number]

2. Now my problem is when I use the HTTP module “Get a File”, it only downloads an HTML file. It seems to completely ignore that this is actually a PDF file. The header starts with the HTML file type opener.

3. What’s missing is the conversion from HTTP to PDF

4. I only found Paid Modules that can convert HTML to PDF, requiring an account and sign-up

My question is, is there a way to do this conversion within one of the free HTTP call modules within Make? - I just think this is basic. Not really ready to get a subscription for something like this.

Thank you

[Arnoud_WorkNinjas]

Don’t use the HTTP Get a File module, but use the Google drive “Download file” module.

Enter the file id and select advanced to configure the wanted output file. You wiull then be able to map the output file in the next modules.

[figuresandnumbers]

Hi there,

I don’t think this will work for me as my google sheet has multiple worksheets. If I use your solution, it will print multiple worksheets. I use this to create invoices for calendly calls and need to pull some data from one sheet to another. So I need to have different worksheets within the same file. I only want to print one worksheet if I can. Is there any way to do this?

[samliew]

Welcome to the Make community!

Yes, that is possible. You’ll need a minimum of three modules:

This is just an example. Your final solution may or may not look like this depending on your requirements.

Example Spreadsheet

Read-only link to spreadsheet with multiple sheets:
Make Test Spreadsheet - Google Sheets

Example Output

As you can see from the above example spreadsheet, it is possible to select which sheet from the document you want to export as PDF.

• First sheet PDF: Make_Test_Spreadsheet_2024-08-22_14-08.pdf - Google Drive
• Second sheet PDF: Make_Test_Spreadsheet_2024-08-22_14-10.pdf - Google Drive

References

For more information and examples, see references:

• How to download single sheet as PDF to my local device directly (not export to Google Drive)? - Stack Overflow
• google apps script - Export Individual Sheet to PDF - Stack Overflow
• Exporting Google sheet to PDF - Stack Overflow
• Export Single Sheet to PDF in Apps Script - Stack Overflow
• Google Apps Script - EXPORT all sheets INDIVIDUALLY to PDF - Stack Overflow
• Google sheets script - export to PDF as fit to page - Stack Overflow
• Save to PDF script in Google Sheet - Stack Overflow
• google apps script - Exporting Specific Range of Cells to PDF - Stack Overflow
• python - Export Google Sheets as PDF with custom setting - Stack Overflow
• php - How to export Google Sheets to PDF in a custom format with Google Api v3? - Stack Overflow

Hope this helps! Let me know if there are any further questions or issues.

— @samliew

---

P.S.: Did you know, the concepts of about 70% of questions asked on this forum are already covered in the Make Academy. Investing some effort into it will save you lots of time and frustration using Make later!

[loic.wiseflow]

@figuresandnumbers If you use the “Download file” module as suggested by @Arnoud_WorkNinjas you will get the PDF with all the sheets (the “download a file” module does not create one PDF file per sheet, I just double-checked).