Latenode
Google sheets
Telegram

Scrape competitor prices, sync to Google Sheets, get Telegram alerts

This Latenode automation allows users to monitor the prices of competitor products and automatically update a Google Sheets spreadsheet and send price change alerts to a Telegram channel.

It works by fetching a list of product URLs and last known prices from a Google Sheet, scraping the current prices from the competitor websites, computing the price changes, and then logging the price history to the Google Sheet while sending notifications via Telegram for any significant price drops or increases. This helps users stay informed about their competitors' pricing strategies and make more informed decisions about their own product offerings.

Updated Apr 6, 2026Est. run: 26sEst. cost: $0.0703
How Latenode estimates time and cost

Latenode bills workflow runs in credits: 1 credit = 30 seconds of processing. Minimum charge per run depends on your plan. Plug-and-Play (PnP) AI nodes are billed separately—each PnP token is $1 USD, charged pay-as-you-go at vendor cost plus a small processing fee, with no API keys required.

Full pricing — how credits work →
Scraping & data collection

Workflow preview

What this template does

  • Extracts current competitor product prices from websites
  • Normalizes price data and logs changes to a Google Sheet
  • Sends price change alerts to a Telegram channel
  • Enables tracking of competitor pricing strategies
  • Generates a spreadsheet with historical pricing data

How it works

1
Trigger

Scheduled Trigger

The automation runs once a day at 8 AM (server time) to monitor competitor product prices.

2
Action

Fetch Product List

The automation reads the list of product URLs and last known prices from a Google Sheets spreadsheet.

3
Logic

Process Products

The automation processes each product in the list one at a time, with a 20-second delay between requests to avoid overloading the competitor websites.

4
Action

Load Product Page

For each product, the automation uses a headless browser to fetch the HTML of the current product page.

5
Action

Extract Current Price

The automation parses the HTML to find the current product price.

6
Logic

Compute Price Change

The automation calculates the percentage change from the last known price.

7
Action

Clean Up Data

The automation normalizes and formats the extracted price data.

8
Logic

Is Price Changed?

The automation checks if the current price is different from the last known price.

9
Action

Log Price History

If the price has changed, the automation records the current price in the Google Sheets spreadsheet.

10
Logic

Delay Before Updating Sheet

The automation pauses for 1 minute before updating the master Google Sheets spreadsheet to avoid rate-limiting issues.

11
Action

Update Last Price

The automation saves the current price to the master Google Sheets spreadsheet.

12
Action

Send Price Alert

If the price has changed significantly, the automation sends a notification to a Telegram channel to alert the user.

Setup guide

1

Add Google Sheets Credential

In the Latenode Credentials panel, add a new Google Sheets credential. Authenticate with your Google account and grant the necessary permissions for the workflow to access your Google Sheets data.

2

Add Telegram Credential

In the Latenode Credentials panel, add a new Telegram credential. Provide your Telegram bot token and the chat ID where you want to receive the price alerts.

3

Configure Product Data Sheet

In the Latenode visual builder, add a Google Sheets node. Configure the node to read the 'master' sheet containing the list of product URLs and their last known prices.

4

Set up Web Scraping with Apify

In the Latenode Credentials panel, add an Apify credential. Then, in the Latenode visual builder, add an Apify node and configure it with the Apify actor, URLs, and other relevant settings to scrape the competitor product pages.

5

Configure Price History Logging

In the Latenode visual builder, add another Google Sheets node to log the price history (product URL, current price, price change percentage) to a separate 'price_history' sheet.

Requirements

A Google Sheets spreadsheet set up to store the product pricing data
A Telegram bot API token to send price update notifications
A list of competitor product URLs to scrape from
An Apify account and API key to access the web scraping functionality

FAQ

Common questions about this template

Each run uses credits on your Latenode plan. We charge for processing time (1 credit = 30 seconds). Your actual cost depends on your plan and how long the run takes. See pricing plans for plans and how credits work.
Contact support →

More templates

You might also like

Browse all templates →
Scraping & data collection

Automatically Sync Google Maps Business Data to a Spreadsheet

This automation workflow allows users to efficiently scrape business data from Google Maps, including names, contact details, and reviews, and export the structured information into a spreadsheet or database. The workflow uses the SerpAPI service to retrieve Google Maps search results, which are then transformed and appended to a Google Sheet. This enables users to generate leads, conduct market analysis, and gain valuable insights from the collected data in a cost-effective and scalable manner.

26s$0.0703
Scraping & data collection

Scrape Zillow property data and sync to Google Sheets automatically

This Latenode automation extracts real estate listing details from Zillow and automatically populates a Google Sheets spreadsheet with the property data. It leverages the Scrape.do web scraping API to bypass anti-bot protections and fetch the full HTML of Zillow listings, then parses key information like price, address, days on Zillow, and Zestimate, and saves the structured results into a Google Sheet. This solution is designed for real estate professionals, investors, and market analysts who need to collect property data at scale without manual effort, enabling better market research, portfolio tracking, and lead generation.

9s$0.0006
Scraping & data collection

Automatically scrape and store Booking.com hotel data

This workflow automates the search and extraction of hotel data from Booking.com, triggered by a chat message. It uses a combination of web scraping with Bright Data's Web Scraper and AI-powered data processing with OpenRouter to deliver a concise, human-friendly list of hotels, including the title, address, original price, and final price. The final output is a clean and formatted report, making it a valuable tool for travelers, event planners, and business professionals who need to quickly find accommodation.

26s$0.0703