Convert a Specific Excel Worksheet to PDF Using PDF.co and Zapier

Step 1: Set Up the Trigger

Upload a sample Excel workbook containing at least two worksheets to a Google Drive folder.

Create a Zap and select Google Drive → New File in Folder. Connect your account, choose the folder, and test the trigger to retrieve your sample workbook.

Keep the file in Excel format rather than converting it to a native Google Sheets document.

Step 2: Connect PDF.co

Add PDF.co → Anything to PDF.

Connect your PDF.co account using OAuth by signing in and authorizing Zapier.

Step 3: Select the Worksheet

Configure the conversion:

• Input Format: Select the spreadsheet conversion option for XLS/XLSX files.
• Input Source: Map the workbook’s downloadable file URL from the trigger. PDF.co must be able to access it without signing in.
• Output PDF Name: Enter selected-worksheet.pdf.
• Worksheet Index: Enter 1 to convert the second worksheet.

Worksheet indexes start at 0: the first worksheet is 0, the second is 1, and the third is 2. Leave this field blank only if you want to convert all worksheets.

See the Anything to PDF documentation for field details.

Step 4: Test the Conversion

Test the PDF.co action and open the returned url.

Confirm that the PDF contains only the selected worksheet. A worksheet may span multiple PDF pages depending on its content and print settings.

Step 5: Save the PDF

Add Google Drive → Upload File.

Choose an output folder and map the PDF.co result’s url to File. Use a different folder from the watched input folder to avoid triggering the workflow again.

Test the upload, then publish the Zap. New Excel workbooks added to the input folder will have the worksheet at the specified index converted automatically.