Amazon Product Price Tracker with Real-time Alerts
detail.loadingPreview
Automatically track Amazon product prices, get alerted when they change, and maintain a historical record in Google Sheets. This workflow enables smart buying decisions and competitive monitoring without manual effort.
About This Workflow
Never miss a deal or a competitor's price change again! This n8n workflow provides a robust solution for automating Amazon product price monitoring. Simply list your desired product ASINs in a Google Sheet, and the workflow takes over. It periodically scrapes the current prices, compares them to your last recorded values, and calculates the precise changes. Custom alert thresholds empower you to receive notifications for significant price drops or increases, ensuring you're always informed. All data, including a detailed, timestamped price history, is meticulously logged back into Google Sheets for easy analysis and trend identification. It's an indispensable tool for shoppers, resellers, and market analysts alike.
Key Features
- Automated Price Monitoring: Set up scheduled checks to automatically fetch Amazon product prices, eliminating manual tracking.
- Customizable Alert System: Define specific percentage-based high and low thresholds in Google Sheets to trigger alerts for meaningful price fluctuations.
- Comprehensive Price History: Automatically append every scraped price point along with a timestamp to a dedicated Google Sheet tab for insightful historical analysis.
- Seamless Google Sheets Integration: Manage your product list, store updated prices, and log history all within a single, familiar Google Sheet.
- Real-time Data Capture: Utilizes a powerful scraping API (Scrapeops) to reliably extract current product names and pricing from Amazon.
How To Use
- Google Sheets Setup:
- Create a new Google Sheet. Rename the first tab to
Products to Monitor. Add columns:asin,last_pricing(initial or last known price),alert_threshold_high(e.g.,0.1for 10% increase),alert_threshold_low(e.g.,-0.05for 5% drop). Populate with your Amazon ASINs. - Create a second tab named
Price History. Add columns:asin,pricing,timestamp.
- Create a new Google Sheet. Rename the first tab to
- n8n Credentials:
- Add your Google Sheets OAuth2 API credentials.
- Obtain an API key from Scrapeops.io and create a new "HTTP Request API Key" credential in n8n, pasting your key.
- Setup Node (Assumed):
- At the beginning of your workflow, add a "Set" node and name it
Setup. - Add two
assignmentsto this node:spreadsheet_url(Type:string): Paste the full URL of your Google Sheet.scrapeops_apikey(Type:string): Select your Scrapeops API Key credential.
- At the beginning of your workflow, add a "Set" node and name it
- Google Sheets ('Products to Monitor') Node:
- Ensure its credential uses your Google Sheets account.
- Set
Document IDtoExpressionand enter={{ $json.spreadsheet_url }}. - Set
Sheet NametoProducts to Monitor.
- Scrapeops - Amazon Product Node:
- Verify that
queryParameterscorrectly references theasinfromLoop Over Items(={{ $('Loop Over Items').item.json.asin }}) andapi_keyfrom yourSetupnode (={{ $('Setup').item.json.scrapeops_apikey }}).
- Verify that
- Update - Products to Monitor Node (Parameters Inferred due to truncated JSON):
- Configure
OperationtoUpdate. - Set
Sheet NametoProducts to Monitor. - Set
Document IDtoExpressionand enter={{ $('Setup').item.json.spreadsheet_url }}. - Under
Columns, selectDefine below. ForMatching Columns, chooseasinand set its value to={{ $('Loop Over Items').item.json.asin }}. - For
Columns to Update, maplast_pricingto={{ $('Fields').item.json.pricing }}and add alast_checkedcolumn mapped to={{ $now.format("MM/dd/yyyy HH:mm:ss") }}(you'll need to addlast_checkedas a column in your Google Sheet).
- Configure
- Insert - Price History Node:
- Configure
OperationtoAppend. - Set
Sheet NametoPrice History. - Set
Document IDtoExpressionand enter={{ $('Setup').item.json.spreadsheet_url }}. - Under
Columns, mapasinto={{ $('Loop Over Items').item.json.asin }},pricingto={{ $('Fields').item.json.pricing }}, andtimestampto={{ $now.format("MM/dd/yyyy HH:mm:ss") }}.
- Configure
- Activate and Schedule: Activate the workflow. Consider adding a
Crontrigger node at the start to run this workflow on a recurring schedule (e.g., daily or hourly) for continuous monitoring.
Apps Used
Workflow JSON
{
"id": "70e82636-ff7a-47a2-b6ec-272ddb53926b",
"name": "Amazon Product Price Tracker with Real-time Alerts",
"nodes": 7,
"category": "Operations",
"status": "active",
"version": "1.0.0"
}Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.
Get This Workflow
ID: 70e82636-ff7a...
About the Author
SaaS_Connector
Integration Guru
Connecting CRM, Notion, and Slack to automate your life.
Statistics
Related Workflows
Discover more workflows you might like
Google Sheets to Icypeas: Automated Bulk Domain Scanning
This workflow streamlines the process of performing bulk domain scans by integrating your Google Sheets data directly with the Icypeas platform. Automate the submission of company names from your spreadsheet to Icypeas for comprehensive domain information, saving valuable time and effort.
Instant WooCommerce Order Notifications via Telegram
When a new order is placed on your WooCommerce store, instantly receive detailed notifications directly to your Telegram chat. Stay on top of your e-commerce operations with real-time alerts, including order specifics and a direct link to view the order.
On-Demand Microsoft SQL Query Execution
This workflow allows you to manually trigger and execute any SQL query against your Microsoft SQL Server database. Perfect for ad-hoc data lookups, administrative tasks, or quick tests, giving you direct control over your database operations.