n8n

How to Automate Gmail Price Alerts?

Watch Zalando product prices and get an email when a deal meets your target. All links live in Google Sheets so your team can add items and set alert levels in one place. Perfect for marketers, buyers, affiliates, and resellers who want fast alerts without checking pages all day.

A simple form collects the product link and alert price and saves both to a Links sheet. On a schedule you choose, the system reads each row, loads the product page, and pulls key details like price and name. It updates the Links sheet, logs every check in a Price History sheet, and compares the live price to your alert value. When the price is low enough, Gmail sends a clear message with the product name, the new price, and your alert level.

Setup needs Google Sheets and Gmail access and a sheet with two tabs called Links and Price History. Choose a safe check frequency and set your email address in the Gmail node so alerts go to your inbox. Expect fewer manual checks, a clean price history for trends, and faster reaction to discounts across many items.

What are the key features?

  • Web form to add product links and target alert prices into Google Sheets
  • Scheduled checks that read every row in the Links sheet at set times
  • Live fetch of each product page to capture current price and details
  • Simple parsing that extracts price and name from page content
  • Updates the Links sheet with the latest price and product info
  • Logs each check in a Price History sheet for trend tracking
  • Compares live price to your alert value before sending any email
  • Sends clear Gmail alerts with product name, new price, and threshold

What are the benefits?

  • Reduce manual checks from 60 minutes per day to 5 minutes
  • Automate 100 percent of daily price monitoring
  • Build a complete price history for every product link
  • Send timely alerts from Gmail to the right inbox
  • Connect Google Sheets and Gmail with no code
  • Scale to hundreds of products by adding rows to the sheet
  • Cut copy paste errors by up to 90 percent with automatic scraping

How do you set it up?

  1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
  2. You'll need accounts with Google Sheets and Gmail. See the Tools Required section above for links to create accounts with these services.
  3. In the n8n credentials manager, create a Google Sheets credential. You can also double click any Google Sheets node, choose 'Credential to connect with', click 'Create new credential', then follow the on screen steps to connect your Google account.
  4. Create a Gmail credential. Double click the Gmail node, choose 'Credential to connect with', click 'Create new credential', then follow the on screen steps to grant access.
  5. Prepare your spreadsheet with two tabs named Links and Price History. In Links, include at least the columns link and price_alert. Keep the sheet accessible to the Google account used in credentials.
  6. Open the Add Product node and ensure it points to your spreadsheet and the Links tab. Confirm link and price_alert map to the correct columns.
  7. Open the List Products node and select the same spreadsheet and the Links tab so all saved links are read on each run.
  8. Open the Update Products Infos node and map fields to update current product data such as price and name on the Links tab.
  9. Open the Add Log in History node and select the Price History tab. Map fields like product url, name, price, and date so each check is recorded.
  10. Configure the Schedule Trigger to run daily or at a safe interval. Very frequent checks may require extra timing fields or rate limits.
  11. Open the Gmail node and set Send To to your email address. Adjust the subject and message template if needed so it includes the product name and new price.
  12. Enable the workflow. Copy the public URL of the form trigger, submit a test link and alert price, then click Execute on List Products to run once. Confirm the Links and Price History tabs update and that a test email arrives when the price is below the alert.
  13. Troubleshooting: If no email arrives, lower the alert value to force a match and test again. If scraping fails, review the parsing in the Format Product node. If Sheets do not update, recheck document and tab selections in each Google Sheets node. If the schedule does not run, ensure the workflow is active and the instance is online.

Tools Required

$24 / mo or $20 / mo billed annually to use n8n in the cloud. However, the local or self-hosted n8n Community Edition is free.

Gmail

Sign up

No cost: Personal Gmail (Gmail API has no usage-based pricing; quotas apply)

Google Sheets

Sign up

Free: $0 (Google Sheets API usage has no additional cost; quota limits apply)

Credits:
Crafted by n8n.ninja

Similar Templates

Join Futurise to access 1,200+ automation templates

Get instant access to ready-made automation workflows for n8n, Make.com, AI agents, and more. Download, customise, and deploy in minutes.