What is a make a copy link?

A make a copy link is a URL pattern that prompts viewers to duplicate your spreadsheet into their Google Drive instead of editing your original. Template sellers use it so each buyer owns a separate file while the master stays protected.

When to use it

Use copy links when selling or sharing templates, trackers, and dashboards where everyone needs their own editable instance.

When to skip it

Use view-only or comment links when you want one canonical live dashboard everyone references.

How it works

  1. 1

    Finish master template with protections on formula areas.

  2. 2

    Generate copy link from sharing UI or URL tool.

  3. 3

    Deliver link after payment via email or Gumroad.

  4. 4

    README tab explains first-run setup steps.

  5. 5

    Rotate link if it leaks on public forums.

  6. 6

    Pair with OnlySheets for automated copy delivery at scale.

Examples in Google Sheets

Template sale

Gumroad thank-you page opens copy link for budget planner master.

Build this without starting from a blank cell

Use a Better Sheets tool for make a copy link, then watch a walkthrough when you want the full pattern.

Better Sheets resources

Common mistakes

  • Accidentally sharing edit link to master.
  • Copy link on file that requires your private add-on without telling buyers.
  • No setup README after copy.

Frequently asked questions

Copy link vs share?
Share opens your file. Copy creates a new file in the visitor's Drive.
Copy link vs OnlySheets?
OnlySheets automates copy delivery and access; copy link is the core Google mechanism.

Related Tutorials

Watch how make a copy link works

Browse more tutorials
Google Sheets Easter Eggs Beyond PRIDE

Google Sheets Easter Eggs Beyond PRIDE

Going beyond PRIDE, to show you some undocumented google sheets hacks th...
Creating a Custom URL Link for Your Spreadsheet

Creating a Custom URL Link for Your Spreadsheet

Create an apps script function that gets the url of your spreadsheet int...
How do I prevent people from sharing my spreadsheets by making a copy?

How do I prevent people from sharing my spreadsheets by making a copy?

A video I did summarizing the 3 things you can do to help people who sha...
Automatically Copy Spreadsheet Tab to New File with Values Only, No Formulas

Automatically Copy Spreadsheet Tab to New File with Values Only, No Formulas

Automatically copy a spreadsheet tab to a whole new spreadsheet file, ge...
Ali Abdaal's Google Sheet | Year at a Glance

Ali Abdaal's Google Sheet | Year at a Glance

Ali gave away a free Google Sheet Template. In this tutorial I step thro...
LinkTree in a Google Sheet

LinkTree in a Google Sheet

This tool will allows you to share multiple links on your social media.

Related blog posts

Guides that explain make a copy link in more depth.

Browse the blog

Related glossary terms

clone a spreadsheet

Cloning creates a new Google Sheets file from an existing one so you start from a proven layout without editing the master template. Use File > Make a copy inside the sheet or copy from Google Drive. The clone usually brings tabs, formatting, named ranges, and bound Apps Script, but sharing permissions reset.

Read guide →

publish Google Sheets

Publishing puts a read-only snapshot or live view of your sheet on the web at a public URL. File > Share > Publish to web lets you choose a tab and format (web page, CSV, TSV, PDF). Published links do not require Google login, which is powerful for embeds and data feeds but risky if you publish the wrong range.

Read guide →

monetize Google Sheets templates

Monetizing a Google Sheets template means selling a licensed copy, not sharing your master file. You package a polished workbook, set a price, deliver via copy link or automated email after payment, and keep support boundaries clear so buyers know what updates they receive.

Read guide →

OnlySheets

OnlySheets is a Better Sheets product for selling spreadsheet templates without giving buyers edit access to your master file. It connects checkout tools like Gumroad and Stripe to controlled copy delivery, license ideas, and seller workflows so template businesses scale beyond manual email fulfillment.

Read guide →

Google Sheets URL

A Google Sheets URL is the web address for a spreadsheet file or a specific view of it. Share URLs control who can open the file. Export URLs download CSV or PDF snapshots. Hackable URL parameters can jump to a tab, pre-fill filters, or embed a chart if you know the pattern. Treat URLs like keys when edit or copy access is enabled.

Read guide →

Done reading about make a copy link?

Membership unlocks 636+ tutorials, unlimited generators, and every template. Practical lessons. Zero fluff.

Need this once

Jump to a free tool or a single tutorial for this topic.

Learning Sheets for real

Unlock the full library, generators, and templates with membership.