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
- How to convert Google Forms to PDF with PDF.co using Zapier https://pdf.co/how-to-convert-google-forms-to-pdf-using-zapier
Step-by-step guide
1. Configure the input spreadsheet from Google drive. Specify your preferred Google drive spreadsheet and click continue.
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.
3. After hitting Test Trigger, it will fetch the spreadsheet with all attributes such as id, selflink, etc.
4. Once the data is ready, we can then proceed to set up events. Select PDF.co from Choose App & Event.
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.
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.
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:
8. We can now proceed to test the inputs.
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.
10. In summary, below is a glance at the whole process when you convert spreadsheets to PDF.
NOTE: You can set up the next step to save the generated file in Google Drive or Dropbox depending on your requirement.