Lead Magnet: Build One Free with Google Docs, Forms and Sheets

A lead magnet is a small free resource, such as a checklist, a template or a short guide, that you give away in exchange for an email address. The free way to run one takes three Google apps: write the lead magnet in Google Docs, collect sign-ups with a Google Form that saves to a Google Sheet, and hand over the link on the form's confirmation screen. It works well for a new list. It breaks when you need confirmed addresses, automatic follow-up emails and a clean consent record.

What makes a lead magnet work

A good lead magnet does one job. It solves one specific problem for one kind of reader, and it delivers a quick win they can use the same day. A one-page checklist that gets a reader through a task tonight beats a forty-page ebook they save and never open. Short also means you can finish it this week. Most failed magnets are too big, too vague, or unrelated to what the list is about.

The third rule matters most for an email list. The magnet has to match the list's topic. If your newsletter is about home baking, a sourdough troubleshooting sheet brings in bakers. A generic gift card raffle brings in raffle hunters who unsubscribe after the first issue. The people who download the magnet are the people your next ten emails must interest. Pick the magnet by asking what your future issues will talk about, then give away the first useful step.

Three quick tests before you build:

1. Can you name the reader in one phrase, such as first-time puppy owners?
2. Does it promise one outcome, not a whole course?
3. Will your regular emails continue the same subject?

If any answer is no, narrow the idea. Narrow magnets convert better.

Lead magnet ideas and examples that fit on one page

You do not need design software. Each of these formats fits in a single Google Doc, and each delivers a result fast. The examples are illustrations for small businesses and creators.

Notice the pattern. Each one names a reader, promises a result in a short time, and leads into what the sender writes about next. A mistakes to avoid list is another easy format: five errors your reader is making, each with a one-line fix.

Make the lead magnet in Google Docs and share it

Write the resource in a Google Doc. Put the promise in the title, keep it to one or two pages, and end with one line pointing to your newsletter, so the reader knows what comes next. Then make it openable by anyone who signs up, without asking them to request access.

Google Drive lets you share a file with a link. Set the access like this, following Google's steps ^[1]:

1. Select the Doc and click Share.
2. Under General access, click the down arrow.
3. Choose Anyone with the link.
4. Select the Viewer role, so people can view the file but cannot change it, comment or share it.
5. Click Copy link, then Done.

Anyone on the internet who has that link can open the file without signing in to a Google Account. That is what makes delivery easy, and it is also the first weak spot, covered below. Keep the copied link handy; it goes into the form next.

Build an email sign up form in Google Forms

Start a new form in Google Forms and keep it short. A first-name question and the email address are enough. Add one checkbox question that states what people will receive, for example Send me the checklist and the weekly newsletter. That checkbox, saved with each answer, is your only consent record.

Turn on email collection in the settings. By default, a Google Form does not collect email addresses. Google offers two settings: Verified, which requires people to be signed in to a Google account, and Responder input, which asks people to type their address ^[2]. Choose Responder input, so people without a Google account can sign up. Google notes that a typed address cannot be verified.

Next, send the answers to a spreadsheet. Google's steps are ^[3]:

1. Open the form and click Responses, then Summary.
2. At the top right, click More, then Select destination for responses.
3. Choose Create a new spreadsheet, or Select existing spreadsheet.
4. Click Create or Select.

Google Sheets then puts the responses into a table automatically. That sheet is now your email list. Unlinking it later stops new responses from arriving, but the existing rows stay.

Deliver it on the confirmation screen

Google Forms shows a message after someone submits, and you can customize it. This is the free delivery step. Google's steps ^[4]:

1. At the top of the form, click Settings.
2. Next to Presentation, click the down arrow.
3. Next to Confirmation message, click Edit.
4. Enter your message, paste the Doc link into it, and click Save.

Then publish. Click Publish at the top right, give access to anyone with a link under General access, and click Done, then Publish. To get the sign-up link, click Published, then Copy responder link; you can tick Shorten URL first. Google also lets you share a form by email or social media, or embed it on a website or blog.

Leave Limit to 1 response off. Google's page says that setting makes people sign in to a Google Account to fill out the form, which loses sign-ups.

A worked lead magnet example: a dog trainer's puppy checklist

This is an illustration with round, invented numbers. A dog trainer writes a one-page First Week With a New Puppy checklist in Google Docs. She shares it as Viewer with anyone who has the link. Her form asks for a first name, an email address, and a consent checkbox. The confirmation message reads: Here is your checklist, followed by the Doc link. She puts the short form link in her social profiles and on her business cards.

Say 40 people sign up in a month. Each sees the checklist instantly, and each lands as a row in her sheet. Now the work begins. Her plan is a welcome email to each new subscriber. At about two minutes per personal email, that is 80 minutes a month. Then comes the monthly newsletter to a growing list from her own mailbox. Every unsubscribe request means finding a row and deleting it by hand. The magnet works. The list management is now a second job.

Where the free lead magnet setup breaks

The Google setup handles the giveaway well. It does not handle what comes after the sign-up. Four things break, and they break earlier than most people expect.

Delivery is open, not personal. The link in the confirmation message is a public link. Anyone who has it can open the file, so a forwarded or posted link hands out the magnet without a sign-up. You cannot tell who opened it.

No double opt-in. A typed address is not checked. Typos, fake addresses and other people's addresses land in your sheet, and nothing asks the owner of the address to confirm. Emailing unconfirmed addresses raises bounces and spam complaints, which hurts every future send.

No automatic follow-up. The sheet stores a row and stops there. Welcome emails, a short series that introduces you, and the next issue all go out by hand. Past a few sign-ups a week, the follow-up lags and new subscribers forget why they joined.

Consent and unsubscribes are on you. Your proof of consent is a checkbox column in a spreadsheet. Every marketing email needs a working way to opt out, and the Google setup gives you no unsubscribe link, no suppression list and no record of who left.

So the threshold is concrete. A brand-new list with a handful of sign-ups a week can run on Docs, Forms and Sheets. Once you want every subscriber to confirm, receive a welcome email on their own, and leave with one click, you need an email platform. Kit delivers a free resource from a landing page with double opt-in, MailerLite connects a landing-page form to a group whose automation sends the guide, and Beehiiv offers a guide or template as a digital product lead magnet. The full comparison is in our guide to email list building tools.

Still deciding where the magnet fits in your growth plan? Start with how to build an email list and come back for the build.

The bottom line

A lead magnet works when it is specific, delivers a quick win, and matches what your list is about. You can build one free: write it in Google Docs, share it as Viewer with a link, collect sign-ups with a Google Form saved to Sheets, and show the link on the confirmation screen. That carries a new list through its first sign-ups. When you need confirmed addresses, automatic welcome emails and clean unsubscribes, move the magnet to an email platform.