TL;DR:

1. Configure the input spreadsheet from Google drive.
2. Next, under Customize Worksheet click the Test trigger to find out whether Zapier can fetch the input spreadsheet or not.
3. After hitting Test Trigger, it will fetch the spreadsheet with all attributes such as id, selflink, etc.
4. Select PDF.co from Choose App & Event.
5. In the event section, select Anything to PDF converter.
6. Once the action Anything to PDF converter is selected, it is now time to provide the inputs.
7. In the Input field, enter a downloadable public-facing excel URL.
8. We can now proceed to test the inputs.
9. The output response should look similar to the screenshot below.
10. In summary, below is a glance at the whole process when you convert spreadsheets to PDF.

Useful resources

Step-by-step guide

1. Configure the input spreadsheet from Google drive. Specify your preferred Google drive spreadsheet and click continue.

Specify Google Sheet

2. Next, under Customize Worksheet click the Test trigger to find out whether Zapier can fetch the input spreadsheet or not. Once you find your spreadsheet and data, you are OK to proceed. Please note, that your spreadsheet should be public-facing, that way the access is exclusive through PDF.co’s APIs.

Test New Google Sheet Trigger

3. After hitting Test Trigger, it will fetch the spreadsheet with all attributes such as id, selflink, etc.

New Spreadsheet Found Result

4. Once the data is ready, we can then proceed to set up events. Select PDF.co from Choose App & Event.

Setup PDF.co Step

5. In the event section, select Anything to PDF converter. As the name suggests, this action can convert file formats such as URL, HTML, document, spreadsheet, presentation, image, etc. to PDF.

Set Anything to PDF Converter As The Action Step

6. Once the action Anything to PDF converter is selected, it is now time to provide the inputs. First is the Source Type, for this demo, we will be doing spreadsheet to PDF, so choose Link to a CSV, XLS, XLSX, TXT spreadsheet file.

Customize Anything to PDF With Spreadsheet Data

7. In the Input field, enter a downloadable public-facing excel URL. You can generate this URL by providing spreadsheet ID in the URL, as displayed below:

Enter link to Input Field

8. We can now proceed to test the inputs.

Send Test Anything To PDF To PDF.co

9. The output response should look similar to the screenshot below. It contains the URL, no. of page count, output document name, remaining PDF.co credits, etc.

PDF.co Request Processed Successfully

10. In summary, below is a glance at the whole process when you convert spreadsheets to PDF.

Zapier And PDF.co Setup Summary

NOTE: You can set up the next step to save the generated file in Google Drive or Dropbox depending on your requirement.