Track Amazon price-drop alerts with Scavio and Google Sheets

How it works

Track any number of Amazon products from a Google Sheet. Every 1,2,3... hours, the workflow:

Reads your watchlist sheet (product_url, price_threshold, last_alerted_price) Loops through each product with a 2s throttle (Scavio API rate limit for trail users) Extracts the ASIN and country domain from any Amazon URL format (/dp/, /gp/product/, mobile, shortlinks) Calls Scavio: Amazon Get Product for the live price Decides whether to email: only when current price first hits or further drops below your threshold (edge-triggered, no spam at flat prices) Sends a Gmail alert and writes the alerted price back to the sheet so the same level isn't re-alerted

Set up steps

Setup takes about 10 minutes.

Install the Scavio community node: in n8n, go to Settings -> Community Nodes -> Install and enter n8n-nodes-scavio. Get a free Scavio API key at https://dashboard.scavio.dev (500 credits/month, 1 credit per Amazon Get Product call). Create a Google Sheet with one tab. Add three columns: product_url, price_threshold, last_alerted_price. Add one row per product you want to track (paste the Amazon URL and your max price; leave last_alerted_price blank). Import this template, then attach three credentials: Scavio API, Google Sheets OAuth2, and Gmail OAuth2. Open the Get Watchlist and Update last_alerted_price nodes and pick your spreadsheet/tab. Open the Send Gmail node and set sendTo to your alert recipient. Activate.

To re-arm an alert (e.g. you checked but didn't buy), clear the last_alerted_price cell. To stop tracking, delete the row.