The Scenario
It's a Wednesday afternoon and you're three hours into a market entry presentation for the UK fintech space. Your manager asked for a slide showing the major players — specifically, the top 30 fintech websites ranked by UK traffic. You assumed SimilarWeb would have this. It does. What you didn't assume is that getting it into your Google Sheet — where the rest of the analysis lives — would require exporting, reformatting, and reconciling a file that doesn't quite match your column structure.
The bad version:
- Navigate to SimilarWeb's top-sites tool, apply the Finance category and United Kingdom filters, screenshot or manually note the top results because the export option requires a higher-tier plan.
- Open the sheet, create two columns (Domain, Global Rank), and start typing in what you saw on the screen — pausing every few rows to flip back to the browser and verify you didn't miss one.
- Realize the slide needs to show both the domain and the rank number, go back, add the rank column, and re-enter or copy-paste the ranks for all 30 rows.
The presentation is going to your director tomorrow morning. Reformatting data by hand at 4pm is not what you signed up for.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the sheet and talks to the SimilarWeb DigitalRank API on your behalf — including the filtered top-sites endpoint that lets you scope by country and category.
Fetch the top 30 websites from SimilarWeb filtered to the Finance category and United Kingdom and write each site's domain and global rank into columns A and B.
What You Get
- Column A fills with 30 domain names, starting at the top-ranked UK fintech site.
- Column B fills with each site's global rank — the numeric position SimilarWeb assigns globally, even though the filter scoped the list to UK Finance.
- The data lands in row order (rank 1 at the top), ready to copy into your slide or continue analyzing in the sheet.
What If the Data Is Not Quite Ready
You need multiple countries in the same sheet
Fetch the top 20 websites from SimilarWeb for each country listed in column A (filtered to Finance) and write domain, global rank, and country as rows grouped by country into columns B, C, and D.
You want the top sites for several categories, not just Finance
For each category name in column A of my sheet, fetch the top 10 globally ranked websites in that category from SimilarWeb and write the domain names and global ranks as rows grouped by category into columns B and C.
You need to cross-reference the results against your existing watchlist
Fetch the top 50 websites from SimilarWeb filtered to Finance and United Kingdom, write domain and global rank into columns A and B, then check each domain against my 'Watchlist' tab in column A and flag any matches with "ON WATCHLIST" in column C.
Full kill-chain: filter, fetch, cross-reference, and summarize
Fetch the top 30 UK Finance websites from SimilarWeb, write domain and global rank into columns A and B, flag any domain that appears in my 'Existing Partners' tab column A with "PARTNER" in column C, then add a summary row at the bottom counting how many of the top 30 are already partners.
One prompt handles the full chain — API call, write-back, cross-reference, and summary — so the analysis is sitting there when you open the sheet next.
Try It
Open a Google Sheet and Get the 7-day free trial of SheetXAI — ask it to pull the top 30 SimilarWeb-ranked Finance sites for any country you're analyzing, written directly into your columns. From there, see how to enrich a competitor domain list with global ranks or return to the SimilarWeb DigitalRank API overview.