Get price alerts without constant checking. The setup watches Amazon product prices, logs each check in Google Sheets, and emails you when a change hits your own thresholds. It fits ecommerce teams and buyers who track costs and margins.

A schedule starts each run. Product rows load from a Products to Monitor sheet, then each ASIN is sent to the ScrapeOps product endpoint to fetch structured data. The flow cleans the price, validates it, and compares it to the last price. It calculates price change and percent change, updates the main sheet, writes a new row to a Price History sheet, and sends an email only when the change crosses your high or low trigger.

You will need a ScrapeOps API key, Google Sheets access, and SMTP email. In the Setup node, store your spreadsheet link, API key, and email settings, then activate the schedule. Expect to cut manual checks and respond faster to discount drops, competitor moves, and inventory buy signals. It is useful for sellers, brands, and procurement teams who must react quickly to price shifts.

• Scheduled runs check all products at set times with no manual work.
• Reads ASINs and alert thresholds from a Google Sheets list.
• Calls the ScrapeOps Amazon product endpoint to get clean structured data.
• Validates and cleans pricing values before calculations.
• Calculates price change and percent change for each product.
• Updates the master sheet and adds a new row to a Price History sheet.
• Sends an email alert only when the change crosses your high or low threshold.
• Loops through items in batches to control load and stay reliable.

• Reduce manual price checks from 2 hours to 5 minutes per day
• Automate 95 percent of price tracking work
• Improve price data accuracy by removing copy and paste steps
• Handle 10 times more product SKUs with the same team
• Connect Google Sheets, ScrapeOps, and email in one flow

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, ScrapeOps and SMTP Email. See the Tools Required section above for links to create accounts with these services.
3. Prepare your Google Sheet with two tabs named Products to Monitor and Price History. Include columns for asin, last_pricing, alert_threshold_high, and alert_threshold_low in Products to Monitor.
4. Open the Setup node in n8n and fill in spreadsheet_url with your sheet link, scrapeops_apikey with your API key, and to_email and from_email for alerts.
5. Double click the Products to Monitor Google Sheets node, choose the spreadsheet URL mode, then in the Credential dropdown click Create new credential and follow the on screen steps to connect your Google account.
6. Double click the Insert - Price History and Update - Products to Monitor nodes and select the same Google Sheets credential to ensure both reads and writes work.
7. Double click the Scrapeops - Amazon Product HTTP Request node and confirm the URL and query fields use asin from the loop and your API key from the Setup node.
8. Open the Send Email node, select Create new credential in the Credential dropdown, and enter your SMTP server, port, username, and password. Use the Test option to send a test email.
9. Set the Schedule Trigger to a safe interval, such as every hour. For a quick test, choose a short interval and activate the workflow.
10. Populate the Products to Monitor sheet with a few ASINs and threshold values. Start with realistic thresholds like 5 for high and -5 for low percent change.
11. Run a test cycle and confirm the Products to Monitor sheet updates the name, pricing, and change fields and that the Price History sheet appends a new row for each check.
12. If prices do not appear, verify the ASIN is correct, your ScrapeOps API key is valid and within quota, and the Google Sheet is shared with the account connected to n8n. Check the If node paths for invalid or empty prices.