Walmart Price Tracker with Apify & Google Sheets (n8n)

Track Walmart price drops automatically—every week, straight into Google Sheets

This n8n workflow runs a weekly Walmart Price Tracker using the Apify Walmart API and logs results into Google Sheets. It creates a weekly price history, highlights advertised deals, and separates marketplace/third-party offers—no price tracker subscription and no retailer API approval.

What this workflow does

• Schedules weekly: Executes every Monday morning via a scheduled trigger.
• Searches Walmart by your terms: Reads a list of search terms and performs one Walmart search per term using the Apify actor johnvc~walmart-api.
• Filters real products: Filters the Apify dataset to keep only rows that represent real products.
• Normalizes and enriches data: Normalizes fields (including price and was price), stamps each row with the run date, and calculates sale flags and discount percentages.
• Routes results into three Google Sheets tabs:
  • Price history: appends every product row each run.
  • Deals: routes discounted items (advertised price cuts).
  • Marketplace offers: routes items not sold by Walmart (third-party offers).

Use cases

• Monitor specific Walmart listings weekly to spot price drops and build a reliable price history for your buying decisions.
• Separate Walmart-sold deals from marketplace offers so you can compare like-for-like pricing.
• Give SaaS operations or e-commerce teams a spreadsheet-backed view of discounts without manual checking.

Technical details

• Apify: Requires an Apify account and an Apify API token credential in n8n; runs the actor johnvc~walmart-api.
• Google Sheets: Connects to your target spreadsheet and updates three tabs (price history, deals, marketplace offers).
• Optional alerts: You can wire up Slack notifications using Slack credentials and a channel, or set an HTTP endpoint for alerting from the discounted-items output.
• n8n nodes used: set, code, slack (optional), filter, switch, split out.