Web scraping in Google Sheets: IMPORTXML, JavaScript pages, and what scales

Web scraping in Google Sheets, which Sorzio calls enriching URLs, means pulling data off web pages and writing it into rows and columns without code. Native IMPORTXML and IMPORTHTML functions are free for static pages, but stall on JavaScript-rendered sites and break around 50 calls per sheet. Sorzio runs enrichment server-side across Google Sheets, Hosted Lists, and the Claude or ChatGPT MCP connector, handling thousands of URLs, enriching up to 6 key website subpages at $0 extra, supporting both Company LinkedIn ($7.50/1k) and Personal LinkedIn /in/ profiles ($10/1k), and charging only for rows that return data. This guide covers each method, where it breaks, the exact costs, and how to run enrichment responsibly.

What are the ways to pull a website into Google Sheets?

There are three practical shapes, and they suit different jobs.

1. Native import functions. IMPORTXML, IMPORTHTML, and IMPORTDATA live inside Sheets and need no setup. You write a formula, point it at a URL and an XPath or a table index, and the result lands in the cell. Free, instant, and fine for a handful of static pages.
2. A sidebar add-on. You select a column of URLs, the add-on fetches each page on a server outside the spreadsheet, and results stream back into a new column. This is the approach that survives at thousands of rows and on JavaScript-heavy sites, because the work never touches Apps Script.
3. A scraping API. A developer writes code that calls a scraping service, parses the response, and pushes rows into Sheets through the Sheets API. Maximum control, but it is a build project, not a spreadsheet task.

Sorzio is the second shape, a URL enrichment engine that runs from inside Google Sheets. Its Enrich feature also bundles the API providers so you can route a run through whichever engine fits the target site, without writing any code yourself.

How do IMPORTXML and IMPORTHTML work, and why do they fail on JavaScript pages?

The native functions are the obvious starting point because they cost nothing and need no install. IMPORTHTML pulls a table or list by index. IMPORTXML pulls any element you can target with an XPath query. A typical formula looks like this:

=IMPORTXML("https://example.com/about", "//h1")
=IMPORTHTML("https://example.com/pricing", "table", 1)

The XPath in the first formula, //h1, grabs the first level-one heading on the page. You can target nested nodes too, for example a div inside an article, written as a path expression in the XPath string. For a static page with clean HTML, this works and it is genuinely useful.

The problems show up the moment you scale or hit a modern site:

• JavaScript-rendered pages return nothing. IMPORTXML reads the raw HTML the server sends, not the page a browser builds after running scripts. Most large, modern sites render their content with JavaScript, so the data you want simply is not in the HTML the function sees. You get an empty cell or an error.
• Roughly 50 calls per sheet. Each spreadsheet can run only about 50 import calls before they start failing, and each call returns up to 50,000 characters. A list of 500 URLs is out of reach on the native functions alone.
• Unpredictable refresh and slowdowns. The import functions re-check for updates roughly every hour while the document is open, and once you have more than a dozen of them the sheet slows down and behaves erratically because every edit can trigger a recalculation.
• No retries, no rendering, no error handling. When a page is slow, blocks the request, or needs a header, the formula just fails. There is nowhere to add a retry or a fallback.
• Rate limiting and #N/A. Hammer a site with formulas and Google throttles you, returning errors that look like the data does not exist.

IMPORTXML is the right tool for a quick one-off on a static page. It is the wrong tool for enriching a lead list, monitoring competitor pages, or anything that runs more than a few dozen times.

What is the 6-minute Apps Script limit and why does it matter?

If the native functions are not enough, the next instinct is to write a custom Apps Script that loops over your URLs and fetches each one. This hits a hard wall: Google caps a single Apps Script execution at six minutes. Fetch a page, parse it, write the row, repeat, and you will burn through that budget after a few hundred URLs at best, often far fewer if the pages are slow. The script dies mid-run and you are left with a half-filled column and no clean way to resume.

You can work around it with time-based triggers that chunk the work into six-minute slices, but now you are maintaining a brittle queue-and-resume system instead of scraping. This is the core reason a serious scrape does not belong inside Apps Script. The fix is to move the fetching off the spreadsheet entirely. Sorzio runs every request on its own servers, so the six-minute limit never applies and a run of fifty thousand URLs is just a longer run, not a broken one.

Is web scraping legal and how do I do it ethically?

Scraping publicly available data is broadly legal in the US and EU, but the way you do it matters more than whether you do it. The landmark hiQ Labs v. LinkedIn case established that accessing a page anyone can view without logging in is not "unauthorized access" under US anti-hacking law, a position the Ninth Circuit reaffirmed in 2022. That does not make scraping a free-for-all. The same case ended in a settlement where hiQ destroyed its scraped data, and newer disputes, such as Reddit's late-2025 suit against Perplexity, turn on whether technical access controls were bypassed rather than on whether the data was public.

A few rules keep you on the right side of both the law and basic courtesy:

• Respect robots.txt. It is not a contract, and ignoring it is not hacking, but it signals intent. Honoring it is the clearest sign of good faith and the easiest way to avoid being blocked.
• Rate-limit yourself. Scraping fast enough to degrade a site can count as trespass to chattels. A common rule of thumb is no more than one request per second per domain. Sorzio paces requests and backs off rather than flooding a host.
• Do not scrape personal data without a lawful basis. GDPR and CCPA apply to names, emails, and photos regardless of whether the page was public. The Clearview AI fines, over 91 million euros across 15 jurisdictions by 2025, are the cautionary tale.
• Scrape behind no login. Public pages only. Anything behind a sign-in wall changes the legal picture entirely.

The short version: scrape public pages, slowly, honor the site's stated wishes, and never collect personal data you have no basis to hold.

How do I run Enrich in Sorzio, step by step?

The flow is the same whether you run from the Google Sheets sidebar, a Hosted List, or Claude and ChatGPT MCP:

1. Put your target URLs in a column and open Extensions, Sorzio, Open sidebar (or upload a Hosted List).
2. Select the range of URLs and leave the mode on Auto, which classifies website URLs, LinkedIn /company/ URLs, and personal LinkedIn /in/ URLs per row automatically.
3. For company websites, optionally enable subpage categories (about, products, case_studies, pricing, careers) to bundle up to 6 key pages into one cell at $0 extra.
4. Review the cost preview for your exact URL count and click Run. Results stream back row by row on Sorzio servers.

Because every URL is its own server-side request, a page that blocks or times out fails on its own row without stopping the rest, and you only pay for URLs that return data.

What does Enrich cost in Sorzio?

Sorzio prices each enrichment mode per succeeded row:

• Website Enrich (Auto), $0.006 per URL ($6.00 per 1,000 URLs), including $0 extra 6-page subpage enrichment across about, products, case_studies, pricing, and careers.
• Company LinkedIn (/company/), $0.0075 per row ($7.50 per 1,000 rows).
• Personal LinkedIn (/in/), $0.01 per row ($10 per 1,000 rows; #not_found profiles cost $0).
• Jina, $0.005 per URL for rendered JavaScript text ($0 platform fee with BYOK on Scale).
• Firecrawl, $0.0075 per URL for complex dynamic web apps ($0 platform fee with BYOK on Scale).

You see the price for your exact URL count before anything runs, and only succeeded URLs are charged. New workspaces unlock up to $20 in free credit ($5 at signup + $15 on card verification). Model a full run alongside AI and verification in the cost calculator.

What can you actually do with enriched data in a sheet?

Two patterns cover most of the real work.

Enrich a list. You have a column of company URLs and you want context: what the company does, where it is based, a recent headline. Pull the about page or homepage into a text column with an Enrich step, then run an AI prompt over it to extract clean fields or write a personalized line. This is the engine behind lead enrichment in Google Sheets, where one retrieved fact turns a generic opener into one that could only apply to a single prospect.

Monitor pages over time. Enrich a set of competitor pricing pages, product pages, or job boards on a schedule and diff the results against last week. A change in a price, a new job posting, or a removed product line shows up as a changed cell. Because the output is a normal column, any spreadsheet trick still works: conditional formatting to flag changes, a filter to isolate movers, a formula to count differences.

In both cases the Enrich step is rarely the finish line. It feeds an AI step or a Verify step, and because it all happens in one sheet there is no exporting and re-importing between tools.

Common questions

Can IMPORTXML scrape JavaScript-rendered pages?

No. IMPORTXML reads the raw HTML the server returns, before any JavaScript runs. Most modern sites build their content with JavaScript, so the data is not in that raw HTML and the formula returns an empty cell or an error. A server-side scraper that renders the page, like the Sorzio Firecrawl engine, is the way to reach that content.

How many URLs can I scrape in Google Sheets?

With native functions, roughly 50 import calls per spreadsheet before they start failing. With a server-side add-on like Sorzio, there is no spreadsheet-side cap, because the requests run off the sheet. Runs of thousands of URLs are normal.

Why does my IMPORTXML formula return an error or #N/A?

Usually one of three reasons: the page is JavaScript-rendered so the content is not in the raw HTML, you have exceeded the per-sheet import limit, or Google is rate-limiting your requests. The native functions give you no way to retry or render, which is why scale and dynamic pages need a different tool.

Is scraping public web pages legal?

Scraping publicly accessible pages is broadly legal in the US and EU, as established by hiQ Labs v. LinkedIn. The conditions matter: stay on pages with no login, respect robots.txt, rate-limit your requests, and do not collect personal data without a lawful basis under GDPR or CCPA.

Do I pay for URLs that fail?

No. Sorzio only charges for URLs that return data. A page that blocks the request, times out, or is a dead link fails on its own row at no cost, so a messy list does not inflate your bill.

What is the difference between scraping and the native import functions?

The native functions run inside the spreadsheet, are free, and break on JavaScript pages and at about 50 calls. A server-side scraper, which is what Enrich runs on, sends requests from a server, renders dynamic pages, retries failures, and scales to thousands of URLs. See what URL enrichment is for the definition, or start with Sorzio to try it on your own list.