Want to extract Walmart product pages straight into your spreadsheet?
You can see below the selectors to use within your =IMPORTFROMWEB() function; just pick them up and write your function as follows:
=IMPORTFROMWEB("Walmart product URL", "title, price")
=IMPORTFROMWEB(A2,B1:C1)
| Selector | Description |
|---|---|
| title | Product name |
| brand | Product brand |
| brandLink | Link to the brand page of the product |
| buybox_winner | Seller who gets the buybox |
| price* | Product price |
| ratings | Average rating |
| reviews_count | Number of reviews |
| categoryN** | Category of the product (replace N by the desired value) |
| categories | All product categories (make sure to leave empty cells below) |
| featured_image_source | Collects the main image source for each product listed |
| availability | Availability of the product |
| imageN_source | Image of the product page (replace N by the image number) |
| images_source | All the images of the product page (make sure to leave empty cells below) |
*Pricing information: Prices, terms, and availability may vary according to the region. Items sold online by Walmart may be eligible for price match, while items sold by Marketplace Sellers are not eligible for price match. Therefore, as the server can be located elsewhere than where you are, the price may be different.
**The categories of the product are ranked from the 1st (Home) to the last one (up to 8). 