Convert Specific Excel Worksheet to PDF using PDF.co and Make

Step 1: Create New Scenario and the Add PDF.co App

In Make start a new scenario and search and select the PDF.co app.

Step 2: Make an API Call

Then, choose the Make an API Call module.

Step 3: Configure the API Call

Let’s set up the PDF.co Make an API Call module.

• In the API Endpoint Path field, type in /v1/xls/convert/to/pdf the endpoint.
• For the Input Type field, select the Override “url” param with value as an input.
• In the URL field, enter the source file link. The Embed link from Google Sheet works here.
• Type in your desired PDF output name for the Output File Name field.
• Under the Body param, type in the worksheet index parameter as the key. The worksheet index parameter will allow you to specify which specific sheet you’d like to convert to PDF. Then, type the value of the particular sheet you’d like to convert into a PDF. The worksheet index starts at 0 for sheet 1 and the worksheet index 1 represents sheet 2.

Step 4: Run the Scenario

Hit the button to run the scenario. You can copy the URL and paste it into your browser to view the output.

Step 5: Converted PDF Output

Here’s what the converted PDF output looks like.