Updated: May 11
Have you ever created a document that is frequently updated and needs to be saved as a PDF so it can be distributed to others? If so, you’ll understand why creating a PDF download link from your Google Sheet is so helpful.
I have a few PDFs that I regularly update, then export as a PDF, and upload to a website where users can download the most up to day version.
I recently figured out a way to eliminate the need to export the Google Sheet as a PDF and then upload it to the website. With this helpful tip, I am able to completely skip those two steps and save quite a bit of time in the process.
Step 1: Grab the Spreadsheet Link
In order to create your PDF downloadable link from a Google Sheet, you’ll first need to the base link that we will use information from to create the downloadable PDF link.
You can do this by simply copying the URL of the page. You DO NOT need to create a shareable link by clicking the green share button on the upper right.
You should have a link that looks like this:
Step 2: Create the new Download/Export URL
The link above contains two important elements that you will need in order to create your downloadable PDF link.
You will need the KEY and the GID from the URL above.
The KEY is the string of numbers and letters that appear after /d/ and before the next / in the URL.
The GID is much easier to find because it appears at the end of the URL after gid=. The GID is unique in that it is a number that represents the sheet within the spreadsheet that you want to display. The first sheet will usually have a 0 as the sheet ID (GID) and the following sheets will have a longer number.
If you want to export all sheets within the PDF, you’ll simply leave out the GID from the URL we will build below. Don’t worry, I’ll show you how!