Latenode
Google sheets
Gmail

Sync Google Shopping prices to your Google Sheet and get email alerts

This comprehensive n8n automation template monitors product prices on Google Shopping daily using Bright Data's web scraping service. It retrieves a list of product URLs from a Google Sheet, extracts the current pricing and other details, and compares them to the previous data.

When a price drop is detected, the workflow sends a personalized email alert to the user, allowing them to take advantage of the change. This template is well-suited for e-commerce businesses and online retailers who want to stay on top of competitor pricing and offer the best deals to their customers.

Updated Apr 12, 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

  • Retrieves a list of product URLs from a Google Sheet
  • Extracts current pricing and details from Google Shopping using Bright Data's scraping service
  • Compares new data to previous pricing to detect price drops
  • Sends personalized email alerts to users when price changes are detected
  • Provides a data-driven tool for e-commerce businesses to monitor competitor pricing

How it works

1
Trigger

Daily Workflow Trigger

The workflow runs automatically every day at 9:00 AM, triggering the daily price monitoring process.

2
Action

Retrieve Product URLs from Google Sheet

The workflow reads a list of product URLs from a Google Sheet, which contains the URLs for the products to be monitored on Google Shopping.

3
Action

Extract Product Details using Bright Data

The workflow utilizes Bright Data's web scraping service to fetch the current pricing and other details for each product from Google Shopping.

4
Action

Update Google Sheet with New Prices

The latest product data, including the new prices, is written back to the Google Sheet for record-keeping and comparison purposes.

5
Logic

Detect Price Drops

The workflow compares the new product prices to the previous data stored in the Google Sheet, identifying any instances where the price has decreased.

6
Action

Notify Price Drops via Email

For each product where a price drop is detected, the workflow sends a personalized email alert to the user, informing them of the price change and allowing them to take advantage of the deal.

7
Logic

Pause Between Emails

The workflow waits for 5 minutes before sending the next price drop email, ensuring a smooth and controlled notification process.

Setup guide

1

Add Google Sheets Credential

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

2

Add Bright Data Credential

In the Latenode Credentials panel, add a new credential for Bright Data. Enter your Bright Data API key or complete the OAuth flow to authenticate.

3

Add Gmail Credential

In the Latenode Credentials panel, add a new credential for Gmail. Authenticate with your Google account and grant the required access permissions.

4

Configure Google Sheets Node

In the Latenode builder, add a Google Sheets node. Configure the node to use the Google Sheets credential you created earlier and specify the Google Sheet URL and worksheet name containing the product URLs.

5

Configure Bright Data Node

In the Latenode builder, add a Bright Data node. Configure the node to use the Bright Data credential you created earlier and specify the product URLs to scrape.

Requirements

A Google Sheets account with a spreadsheet containing the list of product URLs to monitor
A Bright Data account with API access to their web scraping service
A Gmail account set up to send email alerts
Allow Bright Data's IP addresses to access the Google Shopping product URLs
For providers without a native connector in Latenode, use the JavaScript step with that service's API credentials (stored in Latenode Keys / Secrets).

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