Automate Amazon Price Tracking & Alerts with Google Sheets & ScrapeOps
detail.loadingPreview
Automatically track Amazon product prices, calculate changes, and receive email alerts for significant price fluctuations using Google Sheets and ScrapeOps.
🚀Ready to Deploy This Workflow?
🚀 Run Without Servers
Too complicated to set up? Run this workflow instantly on AIWord.
Run on AIWord Cloud ☁️About This Workflow
How it works
This n8n workflow automates Amazon product price tracking and alert generation. It begins by reading a list of products (ASINs) and their alert thresholds from a Google Sheet. Each product is then processed individually. The workflow uses the ScrapeOps API to fetch real-time product data, including the current price. It then calculates the price difference (absolute and percentage) compared to the last recorded price and checks if the percentage change exceeds the defined high or low alert thresholds. If a significant change is detected, an email alert is sent with detailed information. Finally, it updates the main product tracking sheet with the latest price, change metrics, and alert status, and logs the price history in a separate Google Sheet.
Key Features
- Monitor prices of multiple Amazon products automatically.
- Calculate and track price changes (absolute and percentage).
- Set custom high/low thresholds for price alerts.
- Receive email notifications for significant price fluctuations.
- Maintain a detailed price history log.
- Update product information directly in Google Sheets.
How To Use
- Prerequisites: Ensure you have a Google account with access to Google Sheets and an active ScrapeOps API key.
- Setup Google Sheets:
- Create a Google Sheet named "Products to Monitor".
- Add columns:
asin,alert_threshold_high,alert_threshold_low. - Create another Google Sheet named "Price History" (this will be automatically populated).
- Configure n8n Credentials:
- Set up your Google Sheets credentials in n8n.
- Set up your SMTP credentials for sending emails.
- Configure Workflow Nodes:
- Products to Monitor (Google Sheets): Connect your Google Sheets account and select the "Products to Monitor" sheet. Ensure the
documentIdpoints to your spreadsheet. - Scrapeops - Amazon Product (HTTP Request): Input your ScrapeOps API key from your n8n credentials.
- Update - Products to Monitor (Google Sheets): Configure this node to
updaterows in your "Products to Monitor" sheet. Ensure thedocumentIdpoints to your spreadsheet and thematchingColumnsis set toasin. - Insert - Price History (Google Sheets): Configure this node to
appenddata to your "Price History" sheet. Ensure thedocumentIdpoints to your spreadsheet. - Send Email (Email Send): Configure your
toEmail,fromEmail, and SMTP credentials. Thesubjectandhtmlfields dynamically pull data from previous nodes.
- Products to Monitor (Google Sheets): Connect your Google Sheets account and select the "Products to Monitor" sheet. Ensure the
- Set Alert Thresholds: In your "Products to Monitor" Google Sheet, define the
alert_threshold_highandalert_threshold_lowfor each product you want to track.
Apps Used
Workflow JSON
{
"id": "0f31aabd-2a97-4f31-9d5d-45ef08b807e8",
"name": "Automate Amazon Price Tracking & Alerts with Google Sheets & ScrapeOps",
"nodes": 0,
"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.
🚀 Run Without Servers
Use our managed AI Automation Cloud. No DevOps, no errors. Start for free.
- Anti-detect Browser
- Managed Proxies
- 24/7 Uptime
Get This Workflow
ID: 0f31aabd-2a97...
About the Author
N8N_Community_Pick
Curator
Hand-picked high quality workflows from the global community.
Statistics
Related Integrations
- Google Sheets + Schedule Trigger(394 workflows)
- Google Sheets + Split Out(277 workflows)
- Google Sheets + Slack(268 workflows)
- Gmail + Google Sheets(245 workflows)
- Google Drive + Google Sheets(203 workflows)
- Form Trigger + Google Sheets(163 workflows)
- Google Drive + Google Drive Trigger(135 workflows)
- Google Drive + Split Out(134 workflows)
- Google Sheets + Telegram(118 workflows)
- Execute Workflow Trigger + Google Sheets(101 workflows)
Related Workflows
Discover more workflows you might like
Amazon Product Price Tracker with Real-time Alerts
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.
Google Calendar to Sheets Sync: Real-time Event Tracking
This n8n workflow automates the real-time synchronization of your Google Calendar events directly into a Google Sheet. It intelligently checks for new and updated events, ensuring your spreadsheet always has the most current and accurate information without manual data entry.
Automate JSON Data Import to Google Sheets
Seamlessly import data from local JSON files directly into Google Sheets. This workflow automates the process of reading structured JSON data and appending it to your chosen spreadsheet, keeping your data up-to-date effortlessly.
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.
Effortlessly Fetch All Shopify Products with GraphQL Cursor Pagination
This n8n workflow provides a robust solution for fetching all products from your Shopify store using GraphQL's cursor-based pagination. It expertly navigates the Shopify API to ensure complete data retrieval, overcoming the standard GraphQL node's limitations for paginated queries.
AI Stock Analyst Telegram Bot with Technical Charting
Empower your Telegram with an AI Stock Analyst! This workflow enables users to request on-demand technical analysis and interactive stock charts directly through a conversational bot, making financial insights accessible and engaging.