The Formula Builder

The New tab is where you set up a scrape. You don't need to write a formula yourself. Instead, you point WebToSheets at a page, tick what you want, and it writes one for you.

Choosing the source

You may begin in one of two ways, depending on the site you want to scrape.

From a featured platform

If you want to scrape one of the platforms WebToSheets features (Amazon, eBay, Walmart, and more), click its name. WebToSheets then asks only for the part that matters (a ticker symbol, a search term, an item number) and assembles the URL for you.

Pasting a link

For any other site, paste the URL of the page you would like to scrape.

Choosing your data

Selectors

Tick the data you want to extract. Each field you tick becomes a column in your sheet, left to right.

Even a page with no dedicated extractor gives you the basics (title, headings, tables, links, emails and images), with the rarer ones tucked under Advanced.

XPath

To target one exact element, open Target an exact element (XPath) and paste an XPath. For more information, see Any website, which shows how to grab one from your browser.

Inserting the formula

When the formula looks right, click the cell in your Google Sheet you want it in and hit Insert in cell. The data fills in from there.