IMPORTANT: You can convert Google Docs/Sheets/Slides to PDF for free. All you need to do is modify the link to export the document to PDF. Check out our guide here.
In this demo, we will see the step-by-step process of converting Google Sheets into PDF using PDF.co and Zapier.
- Configure the Input Spreadsheet from Google Drive
- Click the Test Trigger Under Customize Worksheet
- Test Trigger
- Select App and Event
- Select Anything to PDF Converter
- Configure Input Parameters
- Generate URL
- Test Inputs
- Expected Result
- Video tutorial: Convert Google Sheets to PDF using Zapier
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 1: Configure the Input Spreadsheet from Google Drive
- Specify your preferred Google Drive spreadsheet and click continue.
Step 2: Click the Test Trigger Under Customize Worksheet
- 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.
Step 3: Test Trigger
- After hitting Test Trigger, it will fetch the spreadsheet with all attributes such as id, selflink, etc.
Step 4: Select App and Event
- Once the data is ready, we can then proceed to set up events. Select PDF.co from Choose App & Event.
Step 5: Select Anything to PDF Converter
- 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.
Step 6: Configure Input Parameters
- 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.
Step 7: Generate URL
- In the Input field, enter a downloadable public-facing Excel URL. You can generate this URL by providing a spreadsheet ID in the URL, as we displayed below.
NOTE: To change the page orientation to Landscape, add &portrait=false at the end. The input URL should now look like this: https://docs.google.com/spreadsheets/d/INSERT_FILE_ID/export?format=pdf&portrait=false
Step 8: Test Inputs
- We can now proceed to test the inputs.
Step 9: Expected Result
- 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.
- In summary, below is a glance at the whole process when you convert spreadsheets to PDFs.
NOTE: You can set up the next step to save the generated file in Google Drive or Dropbox depending on your requirement.
- Now, you know how to convert Google Sheets to PDF using Zapier and PDF.co integration.
