Manually collecting product data from Walmart gets old fast, especially when you need price history or want to track changes over time. Walmart product pages rely on JavaScript rendering and anti-bot protections, so home-grown scrapers break often.
This n8n workflow uses the Walmart Product API to fetch structured JSON from any product URL and append it to Google Sheets, no proxies, headless browsers, or HTML parsers to maintain.
Why use an API instead of scraping directly?
- Product pages load data dynamically and block naive HTTP requests
- CSS selectors change frequently, which breaks custom scripts
- The API returns clean fields (SKU, price, ratings) ready for spreadsheets or dashboards
What does this workflow do?
- Triggered via a webhook with a Walmart product URL
- Calls the Walmart Product API to retrieve detailed listing data
- Extracts and stores:
- SKU
- Product name
- Brand
- Price and currency
- Description
- Average rating and review count
- Review content
- Product URL
- Model
- Main image
- Appends each run to Google Sheets with the current date
- Re-running the same URL builds a price and review history over time
How to set it up
- Import the workflow JSON into n8n
- Add your Piloterr API key to the HTTP Request node (Header Auth)
- Connect your Google Sheets account and point the node to your spreadsheet
- Activate the workflow and copy the webhook URL
- Call the webhook with
?product=https://www.walmart.com/ip/...
Useful for price monitoring, competitive analysis, and building product catalogs on Walmart. For large-scale datasets, see the Walmart Dataset.
