How to Build a Google Sheets Email Outreach Tracker Template

Running an outreach campaign without tracking it is the single most common reason UK marketers send the same contact twice, miss follow-up windows, and have no idea which subject lines are actually working. According to Hunter.io’s 2026 State of Email Outreach report, which analysed 31 million emails, campaigns with structured follow-up processes produce reply rates up to 49% higher than single-send approaches. That gap does not come from better copy. It comes from knowing who to contact next and when.

A well-built google sheets email outreach tracker template costs nothing, takes under an hour to set up, and gives small UK teams the visibility they need without paying for a CRM they will not use properly for months.

Why Most UK Outreach Campaigns Fall Apart Without a Tracker

The problem is not the emails. It is what happens after they are sent. Without a central record, three things go wrong quickly. First, contacts get emailed twice by different team members because nobody knows what has already been sent. Second, follow-ups get missed because the information lives across inboxes, spreadsheets started and abandoned, and memory. Third, there is no data to learn from. If you cannot see which sites replied and which did not, you are repeating the same mistakes at scale.

UK digital PR and link building teams face this particularly hard. A campaign targeting 40 to 60 sites might run across three to four weeks. By week two, without a tracker, most people have lost the thread. The google sheets email outreach tracker template solves this because it is shared, real-time, and requires no software installation or subscription. Every team member can update it from anywhere, including on a phone during a commute.

If your campaigns involve cold link building specifically, the guide on email outreach link building best practices covers the targeting and legal compliance points that sit upstream of the tracker itself.

The 8 Columns Your Tracker Actually Needs

Most outreach tracker templates get cluttered with fields nobody updates. The result is a spreadsheet that looks useful and gets abandoned within two weeks. Keep it lean. These eight columns cover everything a UK outreach campaign needs:

Column A: Website or Contact Name. The target site or individual. Use the publication name, not the URL, for readability.

Column B: Contact Email Address. The specific editor or contributor email, not a generic contact form. Verify these with Hunter.io before adding.

Column C: Domain Authority or DR Score. Pull this from Ahrefs or Moz before outreach. It lets you prioritise follow-ups and filter results later.

Column D: Date First Contacted. The date your initial email was sent. Use a consistent date format across the whole sheet, DD/MM/YYYY works for UK teams.

Column E: Outreach Status. A dropdown column with six options: Not Contacted, Emailed, Followed Up, Replied, Accepted, Declined. Use Google Sheets data validation to create the dropdown so nobody types freehand and breaks your filters.

Column F: Date of Last Contact. Updated every time you email or follow up. This is the column that tells you who is overdue for a follow-up.

Column G: Follow-Up Due Date. A calculated field using a simple formula. If you follow a 3-7-7 cadence (first follow-up 3 days after initial contact, second 7 days after that), you can write this as =F2+7 and format the column with conditional formatting so overdue rows turn red.

Column H: Notes. Free text. Use it to record what the blogger specifically covers, any previous contact history, or any personalisation detail relevant to the next email.

That is the complete tracker. Everything else is noise for campaigns under 200 contacts.

How to Set Up the Dropdown Status Column Correctly

This is where most self-built trackers fail. People add a status column, type different things into it each time, and then cannot filter or analyse anything. To add a validated dropdown in Google Sheets:

1. Highlight the entire Column E from E2 downward.
2. Click Data in the top menu, then Data Validation.
3. Under Criteria, select List of items.
4. Type your status options separated by commas: Not Contacted, Emailed, Followed Up, Replied, Accepted, Declined.
5. Tick “Show dropdown list in cell” and save.

Now every update to the status column is consistent, filterable, and reportable. You can use Data > Filter to show only contacts with a status of “Emailed” and a follow-up due date before today, which gives you your daily follow-up list in under 10 seconds.

Adding Conditional Formatting to Flag Overdue Follow-Ups

The difference between a tracker people use and one people ignore is whether it tells them what to do. Conditional formatting on the follow-up due date column does this automatically.

Highlight Column G, then click Format > Conditional Formatting. Set a rule: if the date in the cell is before today (use the formula =G2<TODAY()), apply a red fill. Add a second rule: if the date is within three days of today, apply amber. Anything further out stays white. Now anyone opening the sheet can see at a glance what needs attention without scrolling through the entire tracker.

For campaigns tracking influencer or blogger relationships alongside link building, the same formatting logic applies. The influencer outreach email template guide covers how follow-up timing differs for creator relationships specifically, which affects how you set your due date intervals.

The Tab Structure That Keeps Campaigns Separate

A single sheet works for one campaign. For UK agencies or in-house teams running multiple concurrent campaigns, use separate tabs within the same Google Sheets file. Label each tab by campaign name and month, for example: LinkBuild-May26, PR-Bloggers-May26.

Add a summary tab at the front that pulls totals from each campaign tab using COUNTIF formulas. The formula =COUNTIFS(‘LinkBuild-May26’!E:E,”Replied”) counts every “Replied” status in that campaign’s sheet and displays it on the summary tab. This gives senior team members a one-glance view of campaign performance without needing to open individual tabs.

If you are also tracking blogger outreach specifically, the formats and language differ enough from influencer and link building campaigns to warrant a separate tab. The article on blogger outreach email templates explains how the pitch structure and goals differ, which also affects how you label your status stages.

When Google Sheets Is Not Enough

A google sheets email outreach tracker template handles most UK small-to-mid-size campaigns well. The realistic limit is around 150 to 200 contacts per campaign before updating the sheet manually becomes the bottleneck rather than the outreach itself.

At that point, tools like Pitchbox, Mailshake, or BuzzStream handle sequencing and status tracking automatically. They integrate with Gmail and update contact records when a reply is received, which removes the manual update step entirely.

The tradeoff is cost: Pitchbox starts at around £350 per month, Mailshake at around £45 per user per month. For a solo UK freelancer or a small agency running two or three campaigns simultaneously, Google Sheets paired with Hunter.io for contact verification and Ahrefs for prospecting covers most needs at near-zero cost.

Building your outreach asset library alongside your tracker is equally important. The guide on easy content creation for UK businesses covers how to produce linkable content consistently without it consuming your whole week.

Frequently Asked Questions

Q: How do I track email outreach in Google Sheets? A: Create a sheet with columns for contact name, email, domain rating, date first contacted, outreach status (as a validated dropdown), date of last contact, follow-up due date, and notes. Use conditional formatting on the follow-up date column to flag overdue contacts in red.

Q: What is a cold email outreach tracker? A: A cold email outreach tracker is a spreadsheet or tool that records every contact you have emailed, the date you sent it, their response status, and when you need to follow up. It prevents missed follow-ups and duplicate sends across a campaign.

Q: How do I create an email tracking spreadsheet? A: Open a new Google Sheet, set up eight columns covering contact details, outreach dates, status, and notes, apply data validation to the status column to create a dropdown, add a conditional formatting rule to flag overdue follow-ups in red, and share the sheet with your team via Google Drive.

Q: Can you use Google Sheets as a CRM for outreach? A: Yes, for campaigns under 150 to 200 contacts. Google Sheets handles contact management, status tracking, and follow-up scheduling effectively at that scale. Beyond that, purpose-built tools like Mailshake or Pitchbox handle automation and status updates more reliably.

Q: How do I track cold email responses? A: Add a Status column with a validated dropdown (Not Contacted, Emailed, Followed Up, Replied, Accepted, Declined) and update it each time you send or receive a reply. Pair this with a Last Contacted date column so you always know the most recent interaction.

Final Thoughts

After running outreach for UK clients across SEO, digital PR, and content campaigns, the pattern is consistent: teams that track in a shared sheet produce more follow-ups, waste less time on duplicate contact, and can see within a week which sites are worth pursuing further. The setup takes less than an hour, and the gain in campaign visibility is immediate.

Build the eight-column tracker, apply the conditional formatting, and share it with anyone touching the campaign before the first email goes out. If you want a validated starting point, the Google Sheets template gallery includes free spreadsheet formats you can adapt, and Google’s own documentation covers data validation and conditional formatting in detail. Start with the tracker. The rest of the campaign gets easier once you can see it clearly.