Tool Tutorials

How to Use Google Sheets for Link Building (With Formulas)

By BacklinkPrice Team · Nov 22, 2026 · 6 min read
Illustrated cover for How to Use Google Sheets for Link Building (With Formulas)

A practical Google Sheets setup for link building, with ready formulas for cleaning domains, tracking outreach and checking that earned links are still live.

Use Google Sheets for link building as a free prospect list, outreach tracker and link monitor. Clean domains with REGEXEXTRACT, remove duplicates with UNIQUE, pull page titles and links with IMPORTXML, flag statuses with data validation and conditional formatting, and check whether earned links are still live.

Sheets won't replace an outreach tool for large teams, but it covers most of what a small team or freelancer needs, and everyone already knows how to use it.

Key takeaways

  • IMPORTXML pulls data from web pages using XPath, such as titles, meta descriptions and links.
  • Google raised the Sheets limit to 20 million cells per spreadsheet in September 2026.
  • REGEXEXTRACT and UNIQUE turn messy URL exports into clean, de-duplicated domain lists.
  • Data validation dropdowns and conditional formatting make status tracking quick to scan.
  • IMPORTXML can't read content loaded by JavaScript, so some checks need a crawler instead.
TabWhat goes in itKey columns
ProspectsSites you might pitchURL, domain, topic, contact page, status
OutreachEvery email sentDomain, contact, date sent, follow-up date, reply
LinksLinks you've earnedLinking page, target URL, anchor, rel, date found
ChecksAutomated live checksLinking page, link found, rel value, last checked
SettingsLists for dropdownsStatus values, owners, campaign names

Why use Sheets at all

It's free, shared and flexible.

Most link builders already export data from SEO tools as CSV files. Sheets lets you combine those exports, clean them and share them with a client or team in one place.

It also scales further than many people think. Google's Workspace blog announced in September 2026 that Sheets now supports up to 20 million cells per spreadsheet, double the previous limit.

The trade-off is that you build the structure yourself. That's fine for most campaigns, and it means the sheet fits your process instead of the other way round.

Step 1: Clean prospect lists

Get to one row per domain.

Exports from backlink tools usually list full URLs. To pull out the domain, use a formula like this in a new column:

=REGEXEXTRACT(A2,"^(?:https?://)?(?:www\.)?([^/]+)")

Then build a clean list with =UNIQUE(B2:B) on another tab. This removes duplicates, so you don't pitch the same site twice from different URLs.

Add a column for topic or category, and filter out sites that don't fit. Our guide on finding backlink opportunities covers where to source prospects in the first place.

Step 2: Pull page data with IMPORTXML

Check prospects without opening every tab.

Google's help page explains that IMPORTXML imports data from structured sources such as HTML, using an XPath query. That lets you pull basic details from each prospect page.

Some useful examples:

  • Page title: =IMPORTXML(A2,"//title")
  • Meta description: =IMPORTXML(A2,"//meta[@name='description']/@content")
  • First heading: =IMPORTXML(A2,"//h1")
  • All links on a page: =IMPORTXML(A2,"//a/@href")

Zapier's IMPORTXML guide walks through finding the right tags on a page. Lido's XPath tutorial shows how to target elements by class, which helps on more complex pages.

Step 3: Track outreach

One row per contact, one status per row.

On the Outreach tab, log the domain, contact name, email, date sent and next follow-up date. Use Data > Data validation to add a dropdown for status: Not contacted, Sent, Followed up, Replied, Won, Lost.

Add a follow-up formula so dates calculate themselves:

=IF(D2="","",D2+5)

This sets a follow-up five days after the send date in column D. Our guide on following up on outreach emails explains how many follow-ups to send and when.

Step 4: Highlight what needs attention

Let colour do the scanning.

Use Format > Conditional formatting to colour rows by status. For example, turn a row amber when the follow-up date is today or earlier and the status is still Sent:

=AND($F2<=TODAY(),$G2="Sent")

Turn rows green when status is Won and grey when Lost. A quick glance then shows what to do next without filtering.

Links disappear. Catch it early.

On the Checks tab, list each linking page in column A. Then test whether your domain appears among the page's links:

=IFERROR(IF(COUNTIF(IMPORTXML(A2,"//a/@href"),"*yourdomain.com*")>0,"Live","Missing"),"Error")

To see the rel value of your link, try:

=IFERROR(IMPORTXML(A2,"//a[contains(@href,'yourdomain.com')]/@rel"),"none")

A blank or "none" usually means a normal followed link. "nofollow", "sponsored" or "ugc" tell you how the link is qualified. Our guide to finding broken backlinks covers what to do when a link goes missing.

Step 6: Report results

Summarise with simple formulas.

On a summary tab, count outcomes with =COUNTIF(Outreach!G:G,"Won") and reply rates with =COUNTIF(Outreach!G:G,"Replied")/COUNTA(Outreach!A2:A).

Group links by month or campaign with a pivot table. Clients usually want to see links won, referring domains, and which pages received links.

Our guide on measuring outreach performance lists the metrics worth reporting.

Limits to know

IMPORTXML is handy, not a crawler.

IMPORTXML reads the HTML a page sends. It can't see content added later by JavaScript, so some modern sites return blanks or errors.

Large numbers of IMPORTXML formulas can slow a sheet down and may stop refreshing reliably. Keep live checks to a few hundred rows per sheet, or split them across tabs.

IONOS's importXML guide notes that the function reads structured data from pages into cells. For heavier work, such as crawling thousands of pages, use a dedicated crawler and import its export into Sheets.

Keep personal data tidy

Only store what you need.

Outreach sheets hold names and email addresses. Share them only with people who need access, and remove contacts who ask not to be emailed again.

Our guide on finding email addresses for outreach covers sourcing contacts responsibly.

When to move beyond Sheets

When the team or volume grows.

If several people send hundreds of emails a week, a dedicated outreach tool saves time with sending, tracking and reminders built in. Sheets then works best as a reporting layer or a master list of earned links.

For solo link builders and small teams, though, a well-built sheet is often all you need. It's free, transparent and easy to hand over to a client.

Frequently Asked Questions

Yes. IMPORTXML can pull a page's links, and COUNTIF can check whether your domain appears. It won't work on pages that load links with JavaScript.

What is the best formula to extract domains from URLs in Sheets?

REGEXEXTRACT with a pattern that strips the protocol and "www" works well. Follow it with UNIQUE to remove duplicates.

Why does IMPORTXML return an error?

Common causes are a wrong XPath, content loaded by JavaScript, or the site blocking automated requests. Test the XPath on a simple page first.

Sheets supports up to 20 million cells per file, but sheets with many IMPORTXML formulas slow down well before that.

Is Google Sheets enough for an agency?

For small teams, often yes. Larger agencies usually add an outreach tool and use Sheets for reporting.

Sources

BacklinkPrice Team
Written by
BacklinkPrice Team
Link building and backlink pricing research

The BacklinkPrice Team researches backlink prices, publisher sites and link building tools. We check prices and plans against each provider's own pages and date them, so you know how current the numbers are.

More from BacklinkPrice Team

Related guides