Amazon Price Monitoring & Alerts
Monitors Amazon prices from your sheet and alerts you via Telegram or email when costs spike or drop.
What it does
Get instant Telegram or Gmail alerts when Amazon prices spike or drop so you can react immediately. This system reads your Google Sheets for product URLs and baseline costs, then uses Decodo and code logic to notify stakeholders only when significant changes occur.
Step by step
- Configure the Google Sheets node to read specific columns for product URLs and baseline prices.
- Set up the Decodo API connection with the appropriate authentication headers and endpoint URL.
- Write a Code node script that subtracts the current price from the baseline and divides by the baseline to get the percentage change.
Where the LLM does the work
- Generate robust error handling logic for the Code node to manage cases where Decodo returns empty or malformed data.
- Draft personalized message templates for Telegram alerts and Gmail notifications that include dynamic price comparison details.
- Create conditional expressions in the Switch node to accurately categorize significant price increases versus minor fluctuations.
Watch out for
Amazon frequently blocks automated scrapers so you must implement random delays or proxy rotation to avoid IP bans.
Price formats may vary across different product pages, parse the scraped text carefully to ensure numeric calculations remain accurate.
Google Sheets rows might shift or contain blank values, add validation checks in the Code node to skip invalid entries before processing.
Tools that fit
Code Service Calculate percentage difference between prices
The agent brief
Everything your agent needs, including the gotchas. Copy it and go.
You are helping me build the following AI agent workflow. ## Goal Amazon Price Monitoring & Alerts: Monitors Amazon prices from your sheet and alerts you via Telegram or email when costs spike or drop. ## Specification - What it does: Get instant Telegram or Gmail alerts when Amazon prices spike or drop so you can react immediately. This system reads your Google Sheets for product URLs and baseline costs, then uses Decodo and code logic to notify stakeholders only when significant changes occur. - Trigger: On a schedule (Scheduled · continuous loop) - Autonomy: Fully hands-off - Expected setup effort: about an afternoon - Tools/services involved: - Google Sheets: Store product URLs and baseline prices - Decodo: Scrape real-time Amazon price data - Code: Calculate percentage difference between prices - Telegram: Send alerts for high price increases - Gmail: Send rich HTML emails for price drops ## Known pitfalls, handle each one explicitly in your implementation 1. Amazon frequently blocks automated scrapers so you must implement random delays or proxy rotation to avoid IP bans. 2. Price formats may vary across different product pages, parse the scraped text carefully to ensure numeric calculations remain accurate. 3. Google Sheets rows might shift or contain blank values, add validation checks in the Code node to skip invalid entries before processing. ## Reference implementation https://n8n.io/workflows/10925 (workflow template) Fetch and inspect this before building. If it matches my stack, adapt it; if not, rebuild the pattern with my tools. ## Process requirements 1. Before building: ask me which of the listed tools I actually use and what my platform is (n8n / Make / code / other). Do not assume. 2. Adapt the pattern to my answers; do not force the reference stack. 3. Address every pitfall above; tell me how you handled each. 4. Provide a test plan I can run before letting this touch real data. 5. Ask before any step that sends messages, modifies data, or spends money. Source: https://usecasesforagents.com/use-case/automated-amazon-price-monitoring-alerts/ via usecasesforagents.com
Frequently asked questions
Can I use a different Spreadsheet than Google Sheets?
Yes. Google Sheets is only the example spreadsheet in this recipe. The same flow works with Airtable, Baserow and Excel. Swap the spreadsheet connection and keep the rest of the setup as written.
Want this running in your business?
This is what I do. I design and build AI agents like this one, and keep them running. If you want it set up for your team instead of doing it yourself, get in touch.
Who it's for
Also fits E-commerce Operator.
Founders and execs get the same output without having to ask someone else to run it.