How to Convert Google Sheets to PDF with PDF.co Using Zapier

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.

In this demo, we will see the step-by-step process of converting Google Sheets into PDF using PDF.co and Zapier.

Useful resources

Step 1: Configure the Input Spreadsheet from Google Drive

Specify your preferred Google Drive spreadsheet and click continue.

Zapier - New Worksheet
Zapier - New Worksheet

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.

Zapier - Find Data
Zapier - Find Data

Step 3: Test Trigger

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

Test result data
Test result data

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.

Zapier - Choose App & Event
Zapier - 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.

Zapier - Choose Anything to PDF Converter
Zapier - Choose Anything to PDF Converter

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.

Choosing Link to a CSV,XLS,XLSX, TXT
Choosing Link to a CSV,XLS,XLSX, TXT

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.

Selecting the Input
Selecting the Input

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.

Sending the test
Sending the test

Step 9: Expected Result

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

Final result data
Final result data

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

Video Guide