Free Google Sheets template

Free Lead Tracker Template for Google Sheets (B2B Lead List)

A lead tracker and B2B lead list in one sheet: who each prospect is, where they work, how to contact them and where they stand in your pipeline.

Copy the template → View the Google Sheet

Free, no signup. Google opens a “Make a copy” screen and the file lands in your own Drive.

Updated September 2026

Preview01 / 06

What the template looks like

	A	B	C	D	E	F	G	H	I	J	K	L	M	N
2	First name	Last name	Company	LinkedIn URL	Job title	Company domain	Work email	Email status	Mobile phone	Industry	Headcount	Location	Status	Notes
3					Derrick: Enrich Leads →	Derrick: Enrich Companies →	Derrick: Email Finder →	Derrick: Email Verification →	Derrick: Phone Finder →	Derrick: Enrich Companies →	Derrick: Enrich Companies →	Derrick: Enrich Leads →
4	Claire	Martin	Northwind Robotics	https://www.linkedin.com/in/example-claire-martin	Head of Sales	northwind-robotics.example	claire.martin@northwind-robotics.example	valid	+33 6 00 00 00 01	Industrial Automation	51-200	Lyon, France	To contact
5	Tom	Becker	Bluepeak Software	https://www.linkedin.com/in/example-tom-becker	VP Marketing	bluepeak.example	tom@bluepeak.example	valid		Software Development	11-50	Berlin, Germany	Contacted
6	Sofia	Rossi	Lumen Health	https://www.linkedin.com/in/example-sofia-rossi	Founder & CEO	lumenhealth.example	sofia@lumenhealth.example	catch-all		Hospitals and Health Care	2-10	Milan, Italy	Replied
7
8

Example rows are fictitious. Blue headers are the columns Derrick can fill, with the feature that does it right under the header.

What's inside02 / 06

What's inside the template

Built for founders, SDRs and small sales teams who keep their prospects in a spreadsheet and want a clean, consistent format before they start calling or emailing. Paste a name and a company, or only a LinkedIn URL, and the rest of the row has a place waiting for it.

Tabs

Start here: how to use it, the colour legend and links to each feature.
Leads: your list: 14 columns, 8 of them blue (filled by Derrick). 300 rows ready to fill, header and first column frozen, filters on.

Dropdowns

Status: To contact, Contacted, Replied, Meeting booked, Not interested

The columns

First name
Last name
Company
LinkedIn URL
Job title
Company domain
Work email
Email status
Mobile phone
Industry
Headcount
Location
Status
Notes

How to use it03 / 06

How to use it in 3 steps

Make a copy (File > Make a copy) and open the Leads tab.
Paste what you already have: a name and a company, or just a LinkedIn profile URL.
Let Derrick fill the blue columns, then work the list with the Status column.

Copy the template →

Blue columns04 / 06

How Derrick fills the blue columns

Every blue column maps to one Derrick feature. Run it on your rows and the column fills itself, row by row. The black columns are yours.

Enrich Leads Fills: Job title, Location
Reads a LinkedIn profile URL and returns the person's current job title, location and profile details. 1 credit per profile.
Enrich Companies Fills: Company domain, Industry, Headcount
Returns a company's website domain, industry, headcount and headquarters from its name or LinkedIn page. 1 credit per company.
Email Finder Fills: Work email
Finds the work email of a person from a name and a company or domain, with a multi-source lookup. 5 credits per email found.
Email Verification Fills: Email status
Checks whether an email address can receive mail and labels it (valid, catch-all, invalid) before you send. 1 credit per email.
Phone Finder Fills: Mobile phone
Finds a direct mobile number for a person from their LinkedIn profile. 200 credits per number found.

Your list, any surface05 / 06

Fill it in Google Sheets or in the Derrick web app

Derrick is a B2B data platform with four entries on one engine: the web app (nothing to install), the Google Sheets sidebar, Claude or ChatGPT through the Derrick MCP, and the REST API. Keep the template in Sheets and use the sidebar (Extensions > Derrick), or import the same list in the web app. The free plan gives you 100 credits every month, no credit card.

Try the app free

or use it in

Google Sheets

Claude

API

More templates06 / 06

More free Google Sheets templates

Free Google Sheets template
Target Account List Template (ABM)

One row per company: firmographics, tech stack, hiring signal, decision maker and a Tier to prioritise.

13 columns · 8 filled by Derrick

Open the template → Copy the template
Free Google Sheets template
Cold Outreach Tracker Template

Log every email and LinkedIn touch, see follow-ups due and read your reply and meeting rates on a dashboard.

12 columns · 2 filled by Derrick · Dashboard

Open the template → Copy the template

See all templates →

What should a B2B lead list include?

At minimum: first and last name, company, job title, a work email and a way to track status. This template adds the LinkedIn URL, the company domain, an email status, a mobile number, industry, headcount and location, so you can segment the list and personalise your message.

Is this template really free?

Yes. The template is free, with no signup and no credit card: click “Copy the template”, Google asks you to make a copy and the file becomes yours, in your own Drive.

Do I need Derrick to use it?

No. The template works on its own: you can fill every column by hand, and the dropdowns work without installing anything. Derrick is there to fill the 8 blue columns automatically instead of you looking up each data point.

How much does it cost to fill the blue columns?

Each feature has its own credit cost, shown on its page (for example 5 credits per email found with Email Finder). Derrick's free plan gives you 100 credits every month, no credit card, enough to test it on your first rows.

Can I use the template in Excel?

Yes. In Google Sheets, go to File > Download > Microsoft Excel (.xlsx). Columns, example rows and dropdowns come along. To fill the blue columns outside Sheets, import the list as a CSV in the Derrick web app.

Can I add or rename columns?

Yes, the copy is yours. Add your own columns on the right and rename the ones that do not fit. Just keep one input per row (name and company, LinkedIn URL or website) so Derrick knows what to look up.