In this tutorial, we will show you how to convert specific excel worksheets to PDF using and Make. We will use a sample invoice from Google Sheet for the source file.

  1. Create New Scenario
  2. Add App
  3. Make an API Call
  4. Make an API Call Configuration
  5. Run Scenario Result
  6. Converted PDF Output
Sample Source File
Sample Source File

Step 1: Create New Scenario

To begin, let’s start by creating a new scenario.

Step 2: Add App

Next, search and select the app.

Add App

Step 3: Make an API Call

Then, choose the Make an API Call module.

Make An API Call

Step 4: Make an API Call Configuration

Let’s set up the 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. Make An API Call Configuration Make An API CallConfiguration

After setting up the configuration, let’s run the scenario.

Step 5: Run Scenario Result

Excellent! We successfully run the scenario. You can copy the URL and paste it into your browser to view the output.

Run Scenario Result

Step 6: Converted PDF Output

Here’s what the converted PDF output looks like.

Converted PDF Output
Converted PDF Output

In this tutorial, you learned how to convert a specific excel worksheet to PDF using and Make. You learned how to use the /v1/xls/convert/to/pdf endpoint to convert XLS to PDF format. You also learned how to use the Custom API Call Web API to generate PDF.