Free Google Sheets template

Free ABM Template for Google Sheets: Target Account List

Build and prioritise the companies you want to win: firmographics, tech stack, hiring signals and the decision maker to reach, all on one row.

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
2	Company	Website	LinkedIn company URL	Industry	Headcount	HQ	Tech stack	Hiring now?	Decision maker	Decision maker email	Tier	Owner	Notes
3			Derrick: Search Companies →	Derrick: Enrich Companies →	Derrick: Enrich Companies →	Derrick: Enrich Companies →	Derrick: Website Technologies →	Derrick: Company Hiring Signal →	Derrick: Find a company's people →	Derrick: Email Finder →
4	Northwind Robotics	northwind-robotics.example	https://www.linkedin.com/company/example-northwind	Industrial Automation	51-200	Lyon, France	HubSpot, WordPress, Google Analytics	Yes: 3 sales roles	Claire Martin, Head of Sales	claire.martin@northwind-robotics.example	Tier 1
5	Bluepeak Software	bluepeak.example	https://www.linkedin.com/company/example-bluepeak	Software Development	11-50	Berlin, Germany	Salesforce, Webflow, Intercom	Yes: 1 marketing role	Tom Becker, VP Marketing	tom@bluepeak.example	Tier 2
6	Lumen Health	lumenhealth.example	https://www.linkedin.com/company/example-lumen	Hospitals and Health Care	2-10	Milan, Italy	Shopify, Klaviyo	No	Sofia Rossi, Founder & CEO	sofia@lumenhealth.example	Tier 3
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 account-based teams, agencies and founders who sell to a defined list of companies. Start from a list of names or websites, then rank each account with a Tier once the firmographics, the tech stack and the hiring signal are on the row.

Tabs

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

Dropdowns

Tier: Tier 1, Tier 2, Tier 3

The columns

Company
Website
LinkedIn company URL
Industry
Headcount
HQ
Tech stack
Hiring now?
Decision maker
Decision maker email
Tier
Owner
Notes

How to use it03 / 06

How to use it in 3 steps

Make a copy (File > Make a copy) and open the Accounts tab.
Paste your target companies: a name is enough, a website is better.
Let Derrick fill the blue columns, then set a Tier to decide who you call first.

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.

Search Companies Fills: LinkedIn company URL
Finds the LinkedIn company page that matches a company name or website. 1 credit per company.
Enrich Companies Fills: Industry, Headcount, HQ
Returns a company's website domain, industry, headcount and headquarters from its name or LinkedIn page. 1 credit per company.
Website Technologies Fills: Tech stack
Detects the tools a company runs on its website: CMS, analytics, CRM, payment and more. 2 credits per website.
Company Hiring Signal Fills: Hiring now?
Tells you whether a company is hiring right now and for which roles, a strong buying signal. 1 credit per company.
Find a company's people Fills: Decision maker
Lists the people who work at a company, filtered by job title, to pick the right decision maker. 1 credit per person.
Email Finder Fills: Decision maker 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.

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
B2B Lead List Template

One row per prospect: name, company, LinkedIn, job title, work email, phone and pipeline status.

14 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 is a target account list in ABM?

It is the short list of companies your sales and marketing teams agree to go after together. Each account is qualified with firmographics (industry, size, location), signals such as hiring or tech stack, and the people to reach, then ranked by tier so the best fits get the most attention.

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.