Peony LogoPeony

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

Deqian Jia
Deqian Jia
Connect with me on LinkedIn! I want to help you :)
Google SheetsPDFDocument LinkingSpreadsheetsProductivity

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 who has which document, what version was sent, or where a deal is in the pipeline.
  • You want a simple “View PDF” link in each row that people can trust.

And yet it feels weirdly clunky to set up.

Let's unpack why that is, and then build a setup you can actually rely on.

1. Why adding PDFs to Google Sheets feels harder than it should

The core problem is this:

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

A cell can hold:

  • Plain text
  • Numbers or dates
  • A formula like =SUM(A1:A10)
  • A hyperlink formula like =HYPERLINK(url, label)

It cannot hold “a PDF file” the way your filesystem does. There is no concept of “embed this PDF binary into this cell.” Under the hood, Sheets is just a structured table with 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 stops being a single source of truth and becomes a patchwork of random links.

On top of that, modern security research keeps pointing out how misconfigured sharing links and "just send a file link" habits are a major source of accidental data exposure. Secure document sharing platforms provide identity-bound access and page-level analytics to prevent this.

So your frustration is valid. You are trying to use Sheets as an index of PDFs, but the "file" part lives somewhere else, and that "somewhere else" is where most of the risk and chaos sits.

2. What you actually want instead

If we translate your situation into requirements, you probably want:

  1. A stable, human-meaningful link per document

    • One URL that represents “this PDF,” no matter where you reference it (Sheets, email, CRM).
    • When the content updates, you change it once at the source, not in 20 rows.

  2. A good experience for the clicker

    • They click “View PDF” and it opens cleanly in their browser on desktop or mobile.
    • No confusing login loops or “you don’t have access” surprises.

  3. Control that matches the sensitivity of the content

  4. Visibility

    • For higher-stakes PDFs (investor decks, proposals, internal strategy), you'd like to know if people actually opened them with page-level analytics.

  5. Sheets as an index, not a file dump

    • The spreadsheet tracks who should see what and where things are.
    • A separate, purpose-built layer actually hosts and protects the PDFs.

This is exactly the gap that Peony + Google Sheets can fill cleanly.

3. How to use a Peony link in Google Sheets (step by step)

Here is a workflow you can standardise across your team.

Step 1 – Put your PDF under Peony’s control

In Peony:

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

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

  2. Upload your PDFs into that room using secure document sharing platforms.

  3. For each document/room, configure security:

    • Add their email addresses or approved domains using identity-bound access.
    • Add passwords to Peony rooms for an additional layer of protection—you can require both identity verification and a password.
    • View-only as your default for anything sensitive.
    • Allow download only where it is genuinely needed.
    • Turn on dynamic watermarking if you want every page tied to an identity (email/name).
    • Enable screenshot protection for highly sensitive content.
    • Add a passcode using password protection if you want a "password-protected" feel on top.

Now your PDFs live in a controlled viewer, with encryption, access control, and audit rather than as loose files.

Step 2 – Generate a share link from Peony

From the Peony UI:

  • Copy the share link for the file or the room.
  • Decide whether it should be:
    • Accessible only by invited emails or domains using identity-bound access, or
    • Open to anyone with the link, but with view-only + watermark to reduce risk.

This URL becomes your canonical reference for that PDF everywhere.

Step 3 – Insert the link into Google Sheets

In your sheet, you can:

Option A – Use the Insert link UI

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

Option B – Use the HYPERLINK formula

If you want a bit more structure:

  1. Put the Peony URL in a “URL” column, say B2.
  2. In another column, say C2, add:
=HYPERLINK($B2, "View PDF")

The HYPERLINK function is designed to create a clickable hyperlink in a cell from a URL and a label.

You can drag this down for as many rows as you need.

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 kill the link in Peony using access management; the cell link no longer opens 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. See who accessed PDFs with page-level analytics: when, how long they viewed them, and which parts they engaged with.

4. Other methods if you can’t use Peony – and why they are compromises

If Peony is not yet available in your setup, you still have options, but they are weaker on control and long-term sanity.

A) Generic cloud or file-sharing links

You can host PDFs on whatever cloud/file-sharing service your company already uses and paste those URLs into Sheets.

This works, but:

B) Internal wiki or portal links

Some teams upload PDFs into an internal wiki, portal, or intranet, then link those pages from Sheets.

  • This can be fine for low-risk internal documentation.
  • It is still less ideal for sensitive or external-facing PDFs where you need proper access control, single links, and analytics.

C) Email attachments only

You can avoid links and track everything by “we emailed it once.” In practice:

  • Your sheet stops being a reliable map; it is just a status tracker.
  • Version control and access control get pushed entirely into inboxes and sent folders, which is where things go to die.

So yes, all of these can “send a PDF,” but they do not solve the underlying problems of control, visibility, and a single source of truth.

5. Practical tips to make your setup calm and reliable

A few simple habits will make this whole system feel much lighter:

  • Create a dedicated link column Have one column for the raw URL (even if hidden), and one for the user-facing HYPERLINK label. That keeps formulas clean and bulk edits easy.

  • Name documents and rooms like a future-you will understand Client – ACME – MSA 2025-01 is far better than contract_new_final.pdf when you revisit the sheet six months later.

  • Test links as a normal user Use a non-admin account or incognito window, click a handful of links, and make sure the experience matches what you intend.

  • Decide which PDFs are “sensitive” vs “just convenient” Be stricter with investor docs, internal strategy, and anything with personal or financial data. A lot of file-sharing incidents come from treating everything as casual.

  • Let Google Sheets stay what it's good at Use it as an index, tracker, and dashboard. Let Peony (or an equivalent secure layer) be the actual home for PDFs.

Once you adopt this pattern, "how do I link a PDF in Google Sheets?" becomes a one-minute, repeatable move: drop the document into Peony, grab the link, wire it into your sheet, and trust that the document behind that link is controlled, up to date, and not quietly leaking somewhere you forgot about.

Frequently Asked Questions

How do you link a PDF in Google Sheets?

Google Sheets can't store PDFs directly—it needs a web URL. Peony is best: upload your PDF to a secure Peony room, get a clean URL, then use Insert → Link or HYPERLINK formula in Sheets to create a clickable link.

Can you embed a PDF in Google Sheets?

No, Google Sheets can't embed PDFs directly. You can link to PDFs hosted elsewhere. Peony provides a secure URL with identity-bound access, password protection, and tracking for PDFs linked in Sheets.

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

Select the cell, press Ctrl/Cmd + K or use Insert → Link, paste your Peony PDF URL, and set the display text. Alternatively, use =HYPERLINK(url, "View PDF"). Peony provides secure PDF hosting with watermarking and analytics.

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

Google Sheets doesn't track PDF link clicks. Peony provides complete visibility: see who accessed PDFs, when, how long they viewed them, and which parts they engaged with.

What's the best way to link PDFs in Google Sheets?

Peony is best: upload PDFs to a secure Peony room with identity-bound access, password protection, watermarking, and tracking, then use Insert → Link or HYPERLINK formula in Sheets.

Related Resources