Free Google Sheets template

Free Outreach Tracker Template for Google Sheets (Cold Email & LinkedIn)

Track every cold email and LinkedIn message in one place: who you contacted, on which channel, when to follow up, and your reply rate calculated for you.

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

Preview01 / 06

What the template looks like

Full nameCompanyLinkedIn URLWork emailEmail statusChannelStepLast contactNext follow-upReplyMeeting booked?Notes
Derrick: Email Finder → Derrick: Email Verification →
Claire MartinNorthwind Roboticshttps://www.linkedin.com/in/example-claire-martinclaire.martin@northwind-robotics.examplevalidEmail12026-09-222026-09-29PositiveYes
Tom BeckerBluepeak Softwarehttps://www.linkedin.com/in/example-tom-beckertom@bluepeak.examplevalidLinkedIn22026-09-242026-10-01No replyNo
Sofia RossiLumen Healthhttps://www.linkedin.com/in/example-sofia-rossisofia@lumenhealth.examplecatch-allEmail12026-09-252026-10-02NeutralNo

Dashboard (example)

Prospects contacted
3
Replies received
2
Reply rate
67%
Positive replies
1
Meetings booked
1
Meeting rate
33%
Follow-ups due today
0
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 anyone running cold email or LinkedIn outreach by hand: founders, freelancers, SDRs testing a new segment. One row per prospect, one place to log each touch, and a dashboard that counts for you.

Tabs

  • Start here: how to use it, the colour legend and links to each feature.
  • Outreach: your list: 12 columns, 2 of them blue (filled by Derrick). 300 rows ready to fill, header and first column frozen, filters on.
  • Dashboard: live counts and rates calculated from your tracking tab. Prospects contacted, Replies received, Reply rate, Positive replies, Meetings booked, Meeting rate, Follow-ups due today.

Dropdowns

  • Reply: No reply, Positive, Neutral, Negative
  • Channel: Email, LinkedIn, Phone
  • Meeting booked?: Yes, No

The columns

  • Full name
  • Company
  • LinkedIn URL
  • Work email
  • Email status
  • Channel
  • Step
  • Last contact
  • Next follow-up
  • Reply
  • Meeting booked?
  • Notes

How to use it03 / 06

How to use it in 3 steps

  1. Make a copy (File > Make a copy) and open the Outreach tab.
  2. Add your prospects, then let Derrick find and verify their emails in the blue columns.
  3. Log each touch and reply: the Dashboard tab updates your reply and meeting rates.

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.

  • 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.

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

See all templates →

Frequently asked questions

Fill your list automatically with Derrick.

100 free credits every month, no credit card.

Try the app freeSee pricing

How are the reply rate and the meeting rate calculated?

+
The Dashboard tab counts the prospects in the Outreach tab. Reply rate = replies received (any Reply value other than No reply) divided by prospects contacted. Meeting rate = rows where Meeting booked? is Yes, divided by prospects contacted. Follow-ups due today = rows with no reply whose next follow-up date is today or earlier.

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 and the dashboard work without installing anything. Derrick is there to fill the 2 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.