Latenode

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

This template reads product URLs from Google Sheets on a schedule, fetches current Google Shopping prices with Bright Data, and writes those prices back to the sheet.

When a price is lower than the last value, Gmail sends you an alert. Connect Google Sheets and Gmail. Put the Bright Data API key in the JavaScript node that calls Bright Data.

Updated Sep 16, 2026Est. run: 14sEst. cost: $0.0009
How Latenode estimates time and cost

Latenode bills workflow runtime in CPU seconds. The first 10,000 CPU seconds are free each month, then usage follows pay-as-you-go CPU-second pricing. 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 CPU seconds work →

Workflow preview

What this template does

  • Refreshes Google Shopping prices into Google Sheets on a schedule
  • Calls Bright Data from JavaScript for the live price
  • Sends a Gmail alert when a price drops
  • Keeps the Bright Data API key in that JavaScript node

How it works

1
Trigger

Run on a schedule

The scenario starts on the cadence you set, such as every morning.

2
Action

Read product URLs

Google Sheets returns the Google Shopping URLs and last prices you keep in the tracking sheet.

3
Logic

Fetch current prices

JavaScript calls Bright Data for each URL and returns the live price. Put the Bright Data API key in that JavaScript node.

4
Action

Update the sheet

Google Sheets writes the new price and check time onto the matching row.

5
Action

Email price drops

When the new price is lower than the stored one, Gmail sends an alert with product and both prices.

Setup guide

1

Connect Google Sheets

Add a Google Sheets connection. Use a sheet with columns for product URL, last price, new price, and last checked.

2

Connect Gmail

Add a Gmail connection for the inbox that should receive drop alerts.

3

Call Bright Data and set the schedule

In JavaScript, send each Google Shopping URL to Bright Data and store the Bright Data API key in that node. Update the matching row, then send Gmail when the new price is lower. Run daily or on another cadence that fits how fast those prices move.

Requirements

A Google Sheet of Google Shopping product URLs Latenode can read and update
A Bright Data API key stored in the JavaScript node
A Gmail account that can send the alert

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. Bright Data bills its own usage separately.