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.

  1. Configure the Input Spreadsheet from Google Drive
  2. Click the Test Trigger Under Customize Worksheet
  3. Test Trigger
  4. Select App and Event
  5. Select Anything to PDF Converter
  6. Configure Input Parameters
  7. Generate URL
  8. Test Inputs
  9. Expected Result
  10. Video tutorial: Convert Google Sheets to PDF using Zapier

Useful resources

 1: Configure the Input Spreadsheet from Google Drive

Specify your preferred Google drive spreadsheet and click continue.

Specify Google Sheet

 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.

Test New Google Sheet Trigger

 3: Test Trigger

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

New Spreadsheet Found Result

 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.

Setup PDF.co 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.

Set Anything to PDF Converter As The Action 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.
Customize Anything to PDF With Spreadsheet Data

 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 displayed below
Enter link to Input Field

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

 8: Test Inputs

We can now proceed to test the inputs.

Send Test Anything To PDF To PDF.co

 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.

PDF.co Request Processed Successfully

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

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.

Now, you know how to convert Google Sheets to PDF using Zapier and PDF.co integration.

Step 10: Convert Google Sheets to PDF using Zapier – Video