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!