How to Link PDF in Google Sheets in 2026: Complete Step-by-Step Guide

If you are here, you are probably doing something very reasonable: you have contracts, invoices, reports, or pitch decks as PDFs, you use Google Sheets to track them, and you want a clean "View PDF" link in each row. Peony (free, $0) is an AI-native data room (VDR) that provides secure, trackable PDF links with page-level analytics and access controls — upload your PDF, grab the link, paste it into Sheets, done.

This guide covers the five ways to link PDFs in Google Sheets in 2026, what changed with Gemini and Drive security, and how to avoid the most common mistakes.

TL;DR: Google Sheets cannot embed PDFs — you must host them externally and link via URL. The =HYPERLINK() formula is the most reliable method. For tracking, security, and access control, use Peony (free, $0) with page-level analytics and access controls. Gemini can now automate the setup. PDF export still strips hyperlinks in 2026.

Key Facts

• Google Sheets supports 5 methods for linking to PDFs but zero methods for embedding PDFs natively.
• As of March 2026, Google Sheets PDF export still strips hyperlinks — a limitation present since the product launched.
• Google Drive's Activity Dashboard tracks file opens only for same-domain Workspace users. External viewers generate zero analytics data.
• As of October 2025, Google Drive applies parent-folder permissions retroactively to all child files, eliminating per-file permission restrictions within shared folders.

What's New in 2026

Google Sheets still cannot embed PDFs natively — that fundamental limitation has not changed. But several updates in 2025–2026 affect how you work with linked documents:

Bottom line: The core workflow is the same as 2024 — host your PDF somewhere, link it in Sheets. What improved is the setup speed (Gemini) and Drive security (expirations, permission changes). What has NOT improved is PDF export and non-Google-ecosystem smart chip support.

Why Adding PDFs to Google Sheets Feels Harder Than It Should

The core problem:

Google Sheets does not store files natively. It only stores text, numbers, formulas, and links.

A cell can hold plain text, numbers, dates, formulas like =SUM(A1:A10), and hyperlink formulas like =HYPERLINK(url, label). It cannot hold a PDF file. You cannot attach a PDF to Google Sheets the way you would attach a file to an email — Sheets is a structured table of references, not a file container.

So the real workflow is always:

1. Put the PDF somewhere that can serve it over the web.
2. Get a URL that points to that PDF.
3. Put that URL into a cell (using Insert → Link or HYPERLINK).

What makes it annoying in practice:

• You end up with messy raw URLs instead of tidy "View PDF" labels unless you use formulas or rich-text links.
• If you ever move or replace the PDF, links quietly go stale.
• Different people on the team start hosting PDFs in different places, so your sheet becomes a patchwork of random links instead of a single source of truth.

And as of September 2025, Google Drive's permission changes made this worse: files inside shared folders now inherit the parent folder's permissions, meaning you can no longer restrict access on individual files below the folder level. If your PDFs live in a broadly shared folder, they are broadly accessible — whether you intended that or not.

5 Ways to Link PDFs in Google Sheets (Ranked)

Method 1: HYPERLINK Formula (Most Reliable)

=HYPERLINK("https://peony.ink/room/abc123", "View PDF")

• Pros: Structured, formula-driven, easy to bulk-apply, labels stay tidy
• Cons: Raw URL is hidden (keep it in a separate column for reference)
• Best for: Spreadsheets with many PDF links, templated workflows

Method 2: Insert Link UI (Ctrl/Cmd + K)

1. Click the cell where you want the link.
2. Press Ctrl/Cmd + K or use Insert → Link.
3. Paste your PDF URL.
4. Change the display text to something like View PDF or Open Deck.

• Pros: Quick for one-off links, no formula knowledge needed
• Cons: Harder to bulk-manage, URL not separately accessible for auditing
• Best for: Quick additions, non-technical users

Method 3: Smart Chips (Google Drive Files Only)

Paste a Google Drive file URL into a cell and Sheets prompts you to convert it into a rich smart chip with file icon, title, owner, and last-modified date on hover.

• Pros: Rich previews with metadata, cleaner than plain hyperlinks
• Cons: Only works for Google Drive URLs — Peony, Dropbox, and other external links do NOT get smart chip treatment
• Best for: Teams fully within the Google ecosystem

Method 4: FileDrop Add-on (Third-Party)

Install from the Workspace Marketplace. Drag-and-drop files into cells — FileDrop stores them in a Google Drive folder and links them automatically.

• Pros: Feels like embedding a file directly into a cell
• Cons: Requires add-on installation, files stored in Drive (no extra security), no analytics or watermarking
• Best for: Teams wanting a file-attachment UX without formulas

Method 5: IMAGE + HYPERLINK Combo

=HYPERLINK("https://peony.ink/room/abc123", IMAGE("https://example.com/pdf-icon.png"))

• Pros: Visual clickable icon in the cell
• Cons: IMAGE function can be finicky with sizing, requires hosting the icon
• Best for: Visually-driven dashboards

Methods Compared

Bottom line: For sensitive or external-facing PDFs (investor decks, contracts, client deliverables), Peony + HYPERLINK gives you the best combination of tracking, security, and control — starting free. For casual internal docs already in Google Drive, smart chips work fine.

How to Use Peony Links in Google Sheets (Step by Step)

Here is a workflow you can standardize across your team.

Step 1 — Upload your PDF to Peony

In Peony:

1. Create a room that matches the context, for example:

   • Investor – Seed Deck (Live)
   • Clients – Signed Contracts
   • Finance – 2026 Reports

2. Upload your PDFs into that room.

3. For each document/room, configure security:

   • Add email addresses or approved domains using identity-bound access.
   • Set view-only as default for anything sensitive.
   • Turn on dynamic watermarking to tie every page view to a viewer identity.
   • Enable screenshot protection for highly sensitive content.
   • Add a password if you want an extra layer on top of identity verification.

Step 2 — Copy the share link

From the Peony UI, copy the share link for the file or room. This URL becomes your canonical reference for that PDF everywhere — Sheets, email, CRM, Slack.

Step 3 — Insert the link into Google Sheets

Option A — HYPERLINK formula (recommended for bulk):

1. Put the Peony URL in a "URL" column, say B2.
2. In another column, say C2, add:

=HYPERLINK($B2, "View PDF")

Drag this down for as many rows as you need.

Option B — Insert Link UI (quick one-offs):

1. Click the cell.
2. Press Ctrl/Cmd + K.
3. Paste your Peony URL.
4. Change the display text to View PDF or Open Deck.

New in 2026 — Gemini shortcut:

If you have Gemini enabled (Business Standard+), you can prompt: "Add a 'View PDF' hyperlink column that links to the URLs in column B, format it as blue underlined text, and freeze the header row" — and Gemini handles all steps at once.

Step 4 — Let Peony handle updates and revocation

From this point on:

• If the PDF changes → replace or update it in Peony; the link in Sheets stays valid.
• If someone should lose access → change permissions or revoke the link in Peony using access management; the cell link no longer works for them.
• If you want to see engagement → view document analytics in Peony instead of guessing from email replies.

Your sheet becomes a clean index, while Peony is the actual document vault and gatekeeper.

Google Drive Security Changes That Affect Your PDFs (2025)

Two major changes in late 2025 impact how linked PDFs are secured:

Permission Inheritance (September 2025)

Google eliminated the ability to restrict access on individual files within a shared folder below the parent folder's permission level. This means:

• If a shared folder grants "Editor" access to your team, you cannot set an individual PDF inside it to "Viewer only" for that team
• Sensitive PDFs must now live in separate folders with tighter access — not alongside general team files
• This was applied retroactively in October 2025

What to do: Move sensitive PDFs to dedicated folders with restricted sharing (see our guide to password protecting a Google Drive folder), or host them on Peony where every document has independent, granular access controls regardless of folder structure.

Sharing Expirations for Shared Drives (November 2025)

Google added expiration dates for file and folder access in shared drives. Previously this only worked for My Drive files.

• Set an expiration date when sharing → access is automatically revoked after that date
• Works for Viewer role on folders, any role on files
• Available on web and Android (not iOS yet)
• Only works for named-user sharing — NOT for "Anyone with the link" shares
• Requires Workspace paid plans (not free Google accounts)

The PDF Export Problem (Still Broken in 2026)

When you export a Google Sheet to PDF (File → Download → PDF), hyperlinks are stripped. This is a longstanding limitation with no fix announced as of March 2026.

Workarounds:

1. Export as HTML first, then convert to PDF — preserves hyperlinks better than direct PDF export
2. Use File → Download → PDF, not Print → PDF — slightly better but still unreliable
3. Display raw URLs as text instead of HYPERLINK labels — raw text URLs may be clickable in some PDF readers even if hyperlink metadata is lost
4. Copy the table into Google Docs first — Docs preserves hyperlinks in PDF export more reliably than Sheets
5. Use Apps Script to generate PDFs via the Google Drive API with specific export parameters

Other Methods If You Can't Use Peony

Google Drive links

Host PDFs on Drive and paste those URLs into Sheets. You get smart chip previews for Drive files, but:

• No page-level analytics (only "did they open it" for same-domain Workspace users)
• No watermarking or screenshot protection
• No password protection on individual files (see how to password protect PDF without Adobe)
• "Anyone with the link" shares have zero viewer tracking
• Permission inheritance (Sept 2025) can accidentally broaden access
• If these limitations affect you, see Google Drive alternatives for founders

Internal wiki or portal links

Upload PDFs to an internal wiki or intranet and link from Sheets. Fine for low-risk internal documentation. Not ideal for sensitive or external-facing PDFs where you need proper access control and analytics.

Email attachments only

Skip links entirely and track documents via "we emailed it." In practice:

• Your sheet stops being a reliable map — it becomes a status tracker with no live links
• Version control and access management get pushed entirely into inboxes, which is where things go to die

Practical Tips for a Reliable Setup

• Create a dedicated link column — Raw URLs in one column (can be hidden), HYPERLINK labels in another. Keeps formulas clean and bulk edits easy.
• Name documents like future-you will understand — Client – ACME – MSA 2026-01 beats contract_new_final.pdf six months from now.
• Test links as a normal user — Use incognito or a non-admin account. Verify the experience matches what you intend.
• Classify sensitivity — Stricter controls (watermarks, screenshot protection, identity-bound access) for investor docs, financials, and legal. Lighter controls for internal convenience files.
• One hosting platform per team — Pick Peony, Drive, or whatever works — but pick ONE. Scattered hosting across Dropbox, email, and local shares is where chaos lives.

Frequently Asked Questions

How do you link a PDF in Google Sheets?

Google Sheets cannot store PDFs directly — it needs a web URL. Upload your PDF to a secure hosting platform like Peony (free), copy the share link, then use Insert → Link (Ctrl/Cmd + K) or the =HYPERLINK(url, "View PDF") formula to create a clickable link in any cell.

Can you embed a PDF in Google Sheets?

No. As of 2026, Google Sheets still cannot embed PDF files natively. Cells hold text, numbers, formulas, and hyperlinks — not file binaries. You must host the PDF elsewhere and link to it. Smart chips provide richer previews for Google Drive files, but still do not embed the actual PDF content.

How do you add a clickable PDF link in Google Sheets?

Select the cell, press Ctrl/Cmd + K or use Insert → Link, paste your PDF URL, and set the display text to "View PDF." For bulk links, use =HYPERLINK(B2, "View PDF") with URLs in a dedicated column. Peony provides secure, trackable URLs with analytics, watermarking, and password protection.

Can you see who clicked a PDF link in Google Sheets?

Google Sheets itself does not track link clicks. Google Drive's Activity Dashboard only tracks same-domain Workspace users and provides no page-level data. Peony tracks all viewers — including external users — with page-level analytics showing who viewed which page, for how long, and from what device.

Why do hyperlinks disappear when I export Google Sheets to PDF?

This is a longstanding Google Sheets limitation with no fix as of 2026. File → Download → PDF strips hyperlink metadata. Workarounds: export as HTML first (then convert to PDF), use Apps Script with the Drive API, or display raw URLs as visible text so they remain readable in the exported PDF.

What changed in Google Sheets for PDF linking in 2025–2026?

Key changes: the =AI() / Gemini function for generating link labels (June 2025), Gemini multi-step editing for setting up link columns in one prompt (October 2025), Drive permission inheritance that affects linked file security (September 2025), and sharing expirations for shared drives (November 2025). The HYPERLINK function itself is unchanged.

What is the best way to securely link PDFs in Google Sheets?

Use Peony (free tier available) to host PDFs with identity-bound access, password protection, dynamic watermarking, and page-level analytics. Paste the Peony share link into Google Sheets using =HYPERLINK(). This gives you control, visibility, and a single source of truth — features Google Drive does not provide natively.

Google Sheets vs Excel: Which handles PDF links better?

Both use HYPERLINK formulas with similar syntax. The key difference is PDF export: Excel preserves hyperlinks in PDF export more reliably than Google Sheets, which strips them. Google Sheets offers smart chip previews for Drive files (Excel does not), and Gemini can now auto-generate link setups. For security and tracking, neither has built-in analytics — use Peony (free) for page-level viewing data regardless of which spreadsheet tool you use.

Related Resources

• How to Link PDF in Canva
• How to Password Protect a Video
• How to Send Large PDF Files via Email
• How to Securely Send Documents via Email
• How to Password Protect PDF Without Adobe
• How to Prevent PDF Forwarding
• How to Password Protect a Google Drive Folder
• Secure Document Sharing Best Practices