The Scenario
You run demand-gen for a B2B analytics company and you are trying to figure out which competitors and potential partners have been gaining traction over the past year. You have a Google Sheet with 60 domains in column A. Your hypothesis is that web traffic trajectory is a better prioritization signal than headcount alone — but right now the traffic column is empty.
The bad version:
- Pull a Similarweb or Semrush free trial, look up each domain, screenshot the monthly traffic chart, and then type the monthly values into the sheet by hand
- Realize after 10 domains that the free tier only shows a 3-month window, not 12 months, and you need to upgrade to get the full dataset
- Pay for the upgrade, go back and redo the first 10 domains, and discover that Crustdata's web traffic figures and the tool you just paid for disagree on several domains — now you have a methodology question you need to resolve before the analysis can start
That is a day of work before you have written a single formula.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet. It reads your domain list and calls Crustdata's web traffic endpoint for each one, populating monthly values across your sheet in the structure you specify.
For each domain in column A, use Crustdata to fetch monthly web traffic for the past 12 months — write the monthly values into columns B through M labeled with the month, then add a percent change column in N comparing the earliest and most recent months
What You Get
- Columns B through M: monthly unique visitor estimates from Crustdata, each column labeled with the month (May 2025, Apr 2025, etc.)
- Column N: percent change from month 1 to month 12, showing trajectory at a glance
- Any domain where Crustdata has no traffic data gets a note in column O so you know it was not a fetch failure
What If the Data Is Not Quite Ready
Some domains in the list redirect to different domains — the canonical URL is different from what you have
Before fetching traffic data, check each domain in column A against Crustdata's records and note the canonical domain in column B if it differs from the input, then fetch 12 months of web traffic for the canonical domain and write monthly values starting in column C
You only want domains that have over 10,000 monthly visits on average — the rest should be filtered out
Use Crustdata to fetch the past 6 months of web traffic for each domain in column A, calculate the monthly average, write it into column B, then remove all rows where the average is under 10,000 and note how many rows were removed at the bottom of column A
You need to compare traffic across two cohorts — competitors vs. partners — and output them in separate sheets
Fetch 12-month Crustdata web traffic for all domains in column A. Write competitor domains (flagged in column B as "competitor") to a sheet called Competitor Traffic and partner domains (flagged as "partner") to a sheet called Partner Traffic, with monthly columns and a trend column in each
One prompt to normalize domains, pull traffic, calculate trajectory, and rank the list
For each domain in column A, strip www. prefixes to normalize them, then use Crustdata to fetch monthly web traffic for the past 12 months — write the monthly values into columns B through M, calculate the 6-month rolling average in column N, and sort the entire sheet by column N descending so the highest-traffic domains appear at the top
All of that in one instruction.
Try It
Get the 7-day free trial of SheetXAI and open your domain tracking sheet, then ask it to pull 12 months of Crustdata web traffic for each entry and build the trend column automatically. You can also ask it to overlay LinkedIn post activity or job listing counts from the same domain list.