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 Trigger

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

Fetch spreadsheet

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

Select PDF.co

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.

Anything to PDF Converter

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

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.

Test output

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

Summary

Related Pages: