FREE N8N TEMPLATE · MARKETING & CONTENT

This n8n workflow reads a watchlist of competitor product pages from Google Sheets each morning, fetches each page, extracts the price with a CSS selector and compares it with the last recorded price. It updates the sheet with the new price and check time, then sends one Slack message summarising every change and any page where the price could not be found.

DIFFICULTY
Intermediate
SET-UP TIME
About 1 hour, depending on how many pages you track
NODES
11
CHECKED AGAINST
n8n 2.41
  • Google Sheets
  • HTTP Request
  • OpenAI or Anthropic
  • Slack

LAST REVIEWED OCTOBER 2026

competitor-price-monitoring.n8n.jsonLOCKED

Get the free workflow

Leave your email to copy the workflow and paste it straight onto your n8n canvas.

FREE · NO CREDENTIALS INCLUDED · CLOUD OR SELF-HOSTED

001 / HOW IT WORKS

Step by step, node by node

  1. 01Run every morning

    A Schedule Trigger starts the workflow at 7am in the workflow's Australia/Sydney timezone. Change the hour or add weekday rules as needed.

  2. 02Read the watchlist

    The Google Sheets node reads every row from the Watchlist tab: product name, competitor, page URL, the CSS selector for the price, the last price and the last check time.

  3. 03Fetch each competitor page

    An HTTP Request node downloads each page one at a time with a short pause between requests and an identifying User-Agent, so the workflow behaves politely.

  4. 04Extract the price

    The HTML node applies the row's CSS selector to the page and returns the text of the price element.

  5. 05Compare with the last price

    A Code node strips currency symbols, converts the price to a number, compares it with the stored price and marks the row as changed, unchanged or price not found.

  6. 06Update the watchlist

    Google Sheets updates each row, matched on URL, with the current price, check time and status, so the sheet always holds the latest known price.

  7. 07Keep only changes and problems

    A Filter node passes on rows where the price changed or could not be found, then an Aggregate node combines them into one list.

  8. 08Summarise and alert in Slack

    A Basic LLM Chain with an OpenAI or Anthropic chat model writes a short summary from the data only, and Slack posts it to your pricing channel.

COMPETITOR PRICE MONITORING WITH GOOGLE SHEETS AND SLACK ALERTS
◷Every Morning▦Read Watchlist↯Fetch CompetitorPage<>Extract Price{}Compare With LastPrice▦Update Watchlist▽Changed orBroken?⊞Combine Changes✦Summarise PriceChanges◆OpenAI Chat Model#Send Slack Alert

THE REAL WORKFLOW YOU IMPORT · NODE NAMES AS THEY APPEAR IN N8N

002 / WHY IT EXISTS

Retailers and ecommerce brands often learn about a competitor's price cut from a customer, or from a drop in their own sales. Checking competitor pages by hand works for a few products but falls apart once the list grows, and it is the kind of task nobody remembers to do on a busy Monday.

This template suits online retailers, wholesalers, and service businesses with published price lists that want a simple daily record of what competitors charge. It uses plain HTTP requests and a Google Sheet you control, so there is no separate scraping subscription for straightforward pages. You get a price history in the sheet and a short Slack summary only when something moves.

WHO IT'S FOR

  • →Online retailers watching a handful of direct competitors on key products
  • →Shopify and WooCommerce store owners who want to know when rivals run a sale
  • →Category and pricing managers who need a daily record of competitor prices
  • →Service businesses tracking published package prices from local competitors

003 / WHAT YOU NEED

Tick them off as you go. Nothing is saved; it's just a checklist.

004 / SET IT UP

  1. 01

    Create the Google Sheet with a Watchlist tab and the seven column headers listed above, then add a few products.

  2. 02

    For each product, open the competitor page, right-click the price, choose Inspect and copy a stable selector such as .price or [itemprop=price] into price_selector.

  3. 03

    Check each competitor site's robots.txt and terms of use, and remove any site that does not permit automated access.

  4. 04

    Import the workflow, connect Google Sheets in Read Watchlist and Update Watchlist, and replace YOUR_GOOGLE_SHEET_ID.

  5. 05

    In Fetch Competitor Page, replace the contact address in the User-Agent header with your own business address.

  6. 06

    Add your OpenAI key, or swap the chat model for an Anthropic Chat Model connected to Summarise Price Changes.

  7. 07

    Connect Slack in Send Slack Alert and change the #competitor-prices channel to your own.

  8. 08

    Run the workflow once to record starting prices, edit a last_price value to test an alert, then activate it.

Get the workflow↑

005 / MAKE IT YOURS

  • +Add an email alert with Gmail or Outlook for team members who are not on Slack.
  • +Append every check to a separate History tab to chart price trends over time.
  • +Use a scraping API or headless browser service for pages that load prices with JavaScript.
  • +Add a stock status selector to track when competitors sell out as well as price moves.
  • +Only alert when the change exceeds a set dollar amount by adding a condition to the Filter node.

FOR AUSTRALIAN BUSINESSES

Only monitor publicly available pages, and check each site's robots.txt and terms of use first. Robots.txt is a convention rather than a law, but site terms can prohibit automated access, and ignoring them can create contract and access risks. Collect prices only; product descriptions and images are likely protected by copyright under the Copyright Act 1968. Watching competitors' public prices is ordinary practice, but discussing or agreeing prices with a competitor can be cartel conduct under the Competition and Consumer Act 2010. If you change your own prices in response, the Australian Consumer Law still applies: displayed prices must be accurate, include mandatory fees, and any was/now comparison must reflect a genuine previous price. The schedule runs in Australia/Sydney time; adjust for Perth or Brisbane.

Need it hosted in Australia? →

006 / TOOLS IN THIS WORKFLOW

007 / QUESTIONS

Anything else is quicker to answer on a call. Thirty minutes, free, with the people who would build it.

Yes. The HTTP Request node fetches a page and the HTML node extracts text using a CSS selector. This works for pages where the price is in the HTML. Pages that build prices with JavaScript need a headless browser or scraping API service instead.

We set up n8n end to end: hosting in Australia, connecting your systems, testing with real data and handing over documentation.

Book a free call→