In this tutorial, we will show you how to convert a Google Sheet to PDF with Landscape orientation using PDF.co and Zapier.

  1. Add Google Drive App
  2. Setup Trigger
  3. Test Trigger
  4. Trigger Result
  5. Add PDF.co App
  6. Setup Action
  7. Test Action
  8. Output URL
  9. PDF Output

Step 1 – Add Google Drive App

To begin, let’s choose Google Drive as the App and the New File in Folder as the Event.

Add Google Drive As Trigger

Step 2 – Setup Trigger

In the Drive field, select the My Google Drive and in the Folder field, choose the folder name where you stored the Google Sheet.

Select Google Drive Folder

Step 3 – Test Trigger

Let’s test the trigger to make sure that we set up the account correctly.

Test Trigger

Step 4 – Trigger Result

Great! Google Drive returned the information of the Google Sheet that we will use for this demo.

Google Drive Returned File

Step 5 – Add PDF.co App

Now, let’s add an action step. Let’s choose PDF.co as the App and the Anything to PDF Converter as the Event.

Add PDF.co Anything To PDF Converter

Step 6 – Setup Action

Let’s configure the Anything to PDF Converter action.

  • In the Input Type field, select the Link to a CSV, XLS, XLSX, TXT spreadsheet file, or filetoken:// link option.
  • In the Input field, copy this link https://docs.google.com/spreadsheets/d/INSERT_FILE_ID/export?format=pdf&portrait=false and replace the INSERT_FILE_ID with your File ID.

Add File ID

PLEASE NOTE: The default orientation is Portrait. You can remove the &portrait=false to switch back to the Portrait orientation.

Step 7 – Test Action

Let’s send our setup to PDF.co to convert the Google Sheet to PDF.

Test PDF.co

Step 8 – Output URL

Great! Copy and paste the output URL to view the result. The link is only temporary and expires after an hour by default. We highly recommend that you add another action step to store the output in permanent cloud storage.

PDF.co PDF Output

Step 9 – PDF Output

Here’s the PDF output in Landscape orientation that we converted from Google Sheet.

PDF Output
PDF Output

In this tutorial, you learned how to convert Google Sheet to PDF with Landscape orientation using PDF.co and Zapier. You learned how to reference the Google Sheet file by its ID. You also learned how to switch between Landscape and Portrait orientation.

Related Pages:

Related Samples: