--- title: "How to Link PDF in Google Sheets in 2026: Complete Step-by-Step Guide" lang: en canonical_url: https://www.peony.ink/blog/link-pdf-in-google-sheets description: "Step-by-step guide to linking PDFs in Google Sheets in 2026. Compare 5 methods (HYPERLINK, smart chips, Peony, FileDrop), new Gemini features, Drive security changes, and export workarounds." date: "2026-06-22T12:00:00.000Z" last_updated: "2026-08-20T12:00:00.000Z" author: "Deqian Jia" --- 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**](https://www.peony.ink/) (free, $0) is an AI-powered data room (VDR) that provides [secure, trackable PDF links](https://www.peony.ink/features/datarooms) with [page-level analytics](https://www.peony.ink/features/page-analytics) and [access controls](https://www.peony.ink/features/manage-links) — 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**](https://www.peony.ink/) (free, $0) with [page-level analytics](https://www.peony.ink/features/page-analytics) and [access controls](https://www.peony.ink/features/manage-links). 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: | Change | Date | Impact on PDF Linking | | ----------------------------------------- | --------- | ------------------------------------------------------------------------------------------------------------------------------- | | **=AI() / Gemini function** | June 2025 | Auto-generate descriptive labels for PDF links from filenames | | **Gemini multi-step editing** | Oct 2025 | Set up an entire PDF link column (hyperlinks + formatting + frozen headers) from one prompt | | **Drive permission inheritance** | Sept 2025 | Files inside shared folders now inherit parent permissions — you can no longer restrict individual files below the folder level | | **Sharing expirations for shared drives** | Nov 2025 | Set expiration dates on shared file access directly in the sharing dialog (Workspace paid plans only) | | **Smart chips for third-party apps** | Oct 2024 | Asana, Jira, Canva, Loom links get rich previews in cells — but custom URLs (Peony, Dropbox) still do not | | **PDF export still strips hyperlinks** | Unchanged | No fix announced — a persistent limitation since inception | > **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](https://workspaceupdates.googleblog.com/2025/09/upcoming-change-to-drive-sharing.html). ## 5 Ways to Link PDFs in Google Sheets (Ranked) ### Method 1: HYPERLINK Formula (Most Reliable) ```gs =HYPERLINK("/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 ```gs =HYPERLINK("/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 | Method | Starting Price | Works With Any URL | Rich Preview | Bulk-Friendly | Analytics | Security Controls | | --------------------------- | --------------------- | ------------------ | ------------ | ------------- | -------------------------------------------- | ---------------------------------------------------------------------------------------------------------------------- | | **Peony link + HYPERLINK** | **Free ($0)** | Yes | No | Yes | Yes ([page-level](https://www.peony.ink/features/page-analytics)) | Yes ([watermarks](https://www.peony.ink/features/watermarks), [passwords](https://www.peony.ink/features/password-protection), [expiry](https://www.peony.ink/features/manage-links)) | | **Drive link + Smart Chip** | Free (with Workspace) | Google Drive only | Yes (hover) | No | Limited (same-domain only) | Basic (no watermarks, no passwords) | | **Insert Link UI** | Free | Yes | No | No | Depends on host | Depends on host | | **FileDrop add-on** | Free tier | Google Drive only | Partial | Yes | No | Basic (Drive permissions only) | | **IMAGE + HYPERLINK** | Free | Yes | Custom icon | Yes | Depends on host | Depends on host | > **Bottom line:** For sensitive or external-facing PDFs (investor decks, contracts, client deliverables), [**Peony**](https://www.peony.ink/) + 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](https://www.peony.ink/): 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](https://www.peony.ink/features/manage-links). - Set **view-only** as default for anything sensitive. - Turn on **[dynamic watermarking](https://www.peony.ink/features/watermarks)** to tie every page view to a viewer identity. - Enable **[screenshot protection](https://www.peony.ink/features/screenshot-protection)** for highly sensitive content. - Add a **[password](https://www.peony.ink/features/password-protection)** 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: ```gs =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](https://www.peony.ink/features/manage-links); the cell link no longer works for them. - If you want to see engagement → view [document analytics](https://www.peony.ink/features/page-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](https://workspaceupdates.googleblog.com/2025/09/upcoming-change-to-drive-sharing.html) 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](https://www.peony.ink/blog/yes-you-can-how-to-password-protect-a-google-drive-folder)), or host them on [Peony](https://www.peony.ink/features/security) where every document has independent, granular access controls regardless of folder structure. ### Sharing Expirations for Shared Drives (November 2025) Google [added expiration dates](https://workspaceupdates.googleblog.com/2025/11/set-sharing-expirations-files-and-folders.html) 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. | Export Format | Hyperlinks Preserved? | | ------------------------- | -------------------------- | | Google Sheets (native) | Yes | | Download as Excel (.xlsx) | Mostly yes | | Download as PDF | **Usually no** | | Download as CSV | No (plain text only) | | Download as HTML | Yes | | Print to PDF (browser) | **No** (flattens to image) | **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](https://www.peony.ink/features/watermarks) or [screenshot protection](https://www.peony.ink/features/screenshot-protection) - No [password protection](https://www.peony.ink/features/password-protection) on individual files (see [how to password protect PDF without Adobe](https://www.peony.ink/blog/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](https://www.peony.ink/blog/top-10-google-drive-alternatives) ### 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](https://www.peony.ink/blog/how-to-send-confidential-documents-via-email). ### 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](https://www.peony.ink/features/watermarks), [screenshot protection](https://www.peony.ink/features/screenshot-protection), [identity-bound access](https://www.peony.ink/features/manage-links)) 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**](https://www.peony.ink/) (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**](https://www.peony.ink/) provides secure, trackable URLs with [analytics](https://www.peony.ink/features/page-analytics), [watermarking](https://www.peony.ink/features/watermarks), and [password protection](https://www.peony.ink/features/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**](https://www.peony.ink/) tracks all viewers — including external users — with [page-level analytics](https://www.peony.ink/features/page-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**](https://www.peony.ink/) (free tier available) to host PDFs with [identity-bound access](https://www.peony.ink/features/manage-links) and [page-level analytics](https://www.peony.ink/features/page-analytics), plus [password protection](https://www.peony.ink/features/password-protection) on the Business plan ($30/admin/month) and [dynamic watermarking](https://www.peony.ink/features/watermarks) on the Data Room plan ($52/admin/month). 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**](https://www.peony.ink/) (free) for [page-level viewing data](https://www.peony.ink/features/page-analytics) regardless of which spreadsheet tool you use. ## Related Resources - [How to Insert a PDF Into Google Docs (2026)](https://www.peony.ink/blog/how-to-insert-pdf-into-google-docs) — the Docs sibling: file chips, image conversion, and the 2 MB OCR import - [How to Link PDF in Canva](https://www.peony.ink/blog/link-pdf-in-canva-complete-guide) - [How to Password Protect a Video](https://www.peony.ink/blog/password-protect-video-guide) - [How to Securely Send Documents via Email](https://www.peony.ink/blog/how-to-send-confidential-documents-via-email) - [How to Password Protect PDF Without Adobe](https://www.peony.ink/blog/password-protect-pdf-without-adobe) - [How to Prevent PDF Forwarding](https://www.peony.ink/blog/how-to-prevent-pdf-forwarding) - [How to Password Protect a Google Drive Folder](https://www.peony.ink/blog/yes-you-can-how-to-password-protect-a-google-drive-folder) - [Secure Document Sharing Best Practices](https://www.peony.ink/features/datarooms) ## FAQ ### What changed in Google Sheets for PDF linking in 2025-2026? Key changes include: the =AI() / Gemini function for generating link labels (June 2025), Gemini multi-step editing for setting up link columns in one prompt (October 2025), expanded smart chips for third-party apps (October 2024), Google Drive permission inheritance changes that affect linked file security (September 2025), and sharing expirations for shared drives (November 2025). The HYPERLINK function itself is unchanged. --- _Markdown version of [https://www.peony.ink/blog/link-pdf-in-google-sheets](https://www.peony.ink/blog/link-pdf-in-google-sheets.md) for AI agents and LLMs; canonical HTML: https://www.peony.ink/blog/link-pdf-in-google-sheets. Every page on peony.ink is available as markdown — append `.md` to the URL or request it with `Accept: text/markdown`. More: [llms.txt](https://www.peony.ink/llms.txt)._