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 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

Step 1: Configure the Input Spreadsheet from Google Drive

  • Specify your preferred Google Drive spreadsheet and click continue.

Specify Google Sheet

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’s APIs.

Test New Google Sheet Trigger

Step 3: Test Trigger

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

New Spreadsheet Found Result

Step 4: Select App and Event

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

Setup Step

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

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

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.

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:

Step 8: Test Inputs

  • We can now proceed to test the inputs.

Send Test Anything To PDF To

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 credits, etc. Request Processed Successfully

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

Zapier And 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 integration.

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