Documentation

WebToSheets brings web scraping into Google Sheets, so you may pull live data from any website straight into your cells with a single formula. No code required, and no separate tools to manage.

What WebToSheets does

WebToSheets provides a convenient way to scrape the web from inside the spreadsheet you already use. You may pull data from any website straight into your cells, with no separate scraper to run.

The add-on gives Google Sheets a single function, =SCRAPE(). The data it returns is ordinary cell content, so your formulas and charts keep working with it. Give it a URL and the fields you want:

=SCRAPE("https://www.amazon.com/dp/B0D1XD1ZV3", "name,pricing,reviews_rating")

Behind the scenes, WebToSheets fetches the page, handles proxies, works around blocked pages, and parses the response on its servers, so you do not need to manage any of that yourself.

You may use WebToSheets on any website. For popular platforms such as Amazon, eBay, Walmart, and more, we provide dedicated selectors, so you may target the data you want by name.

Installation

To get started, you will need a WebToSheets account and the add-on from the Google Workspace Marketplace. You may be up and running in three steps:

1. Create a WebToSheets account.
2. Install the add-on from the Google Workspace Marketplace. The add-on is currently in final Marketplace review; the install link will appear here as soon as it is live.
3. In Google Sheets, open Extensions → WebToSheets → Sign in to link your account.

A quick example

Let's look at a complete example. In the following sheet, a single =SCRAPE() formula pulls a whole list of products and their prices from a Walmart search:

As you can see, you write one formula and WebToSheets returns the live values. To build your own without writing any syntax, see Your first scrape. For the full list of arguments and options, see The =SCRAPE() formula.

Platforms

As mentioned above, several popular platforms have dedicated extractors. Each platform page documents its supported URLs, every available selector, and a worked example:

public Any website arrow_forward Amazon arrow_forward eBay arrow_forward Walmart arrow_forward Google Search arrow_forward Yahoo Finance arrow_forward