Generate Google Sheets PDF link via Google Drive
The ubiquity of PDF files and its ability to easily copy, paste, edit and send it as a PDF link is what makes it so popular. Not many people are aware of this hidden trick of sharing your Google Docs or Google Sheets as PDF versions readily. All you need to do to make this trick work is slightly modify the generated URLs. Here’s the trick. The Google Docs or Google Sheets-to-PDF conversion works best for files you would like to share just for viewing purposes rather than editing.
1] Select the Google Doc or Google Sheet
Open Google Drive and choose the document you would like to share.
Hit the ‘Share’ button visible in the upper right-corner of the screen. Enter the name or email address of the person to whom you would like to send or share the document with.
Choose the permission level (edit, comment, view) you want to grant.
2] Modify the URL
Click on ‘Copy Link’ in the share box. Paste the link in your email body. After you paste the link in your message body, simply replace the end part of the URL before sending it.
Place the mouse cursor before the following text edit?usp=sharing and replace it with this new string of text export?format=pdf.
Now, when the recipient receives the email and clicks on the link provided. The Google Sheet or Google Doc link you had sent will open as a PDF file. The benefits of using this trick is,
You can save email storage space and avoid attachment size limitsDo away with the step of re-sharing PDFs or updating PDF links when you change the source file. The link always goes to the most recent version.No need to keep multiple versions of your files, such as a PDF and a source file—all the versions are stored in a single file.
Hope you can get this to work.