← Back to Skills Marketplace
neo1307

Price Monitor & Daily Excel Report Bot

by neo1307 · GitHub ↗ · v1.0.2 · MIT-0
cross-platform ✓ Security Clean
148
Downloads
0
Stars
0
Active Installs
3
Versions
Install in OpenClaw
/install argus-price-monitor
Description
Monitors product prices across e-commerce sites daily, detects price drops, and emails a formatted Excel report automatically every morning.
README (SKILL.md)

Price Monitor & Daily Excel Report Bot

Overview

Automated price tracking system that monitors products across competitor websites, detects price drops, and delivers a formatted Excel report via email every morning at 8 AM. Saves 3+ hours of manual work per day.

What It Does

  • Scrapes prices from target URLs using Selenium (handles JavaScript-rendered pages)
  • Compares against previous day's prices automatically
  • Highlights price drops >5% in red, increases in green inside Excel
  • Emails formatted report to specified recipients on schedule
  • Logs all runs with timestamps for auditing

Required Environment Variables

Set these in OpenClaw's Secrets manager before running:

Variable Description Example
SMTP_HOST SMTP server hostname smtp.gmail.com
SMTP_PORT SMTP port number 587
SMTP_USER Sender email address [email protected]
SMTP_PASS Email password or app-specific password xxxx xxxx xxxx xxxx
REPORT_RECIPIENT Where to send the daily report [email protected]

Setup

  1. Add target product URLs to config/urls.txt (one URL per line)
  2. Set all environment variables above in OpenClaw Secrets
  3. Set run schedule in OpenClaw: daily at 08:00
  4. Chromium must be available on the host for Selenium headless mode

Usage

"Start monitoring prices for these URLs and email me a report every morning" "Check competitor prices and send Excel summary to [email protected]" "Run price tracker now and show me today's drops" "Add this product URL to the monitoring list"

Output

  • price_report_YYYY-MM-DD.xlsx — color-coded Excel report
  • Email with report attached sent to configured recipient
  • Console summary: total products, drops found, errors

Rules

  • Never send more than 1 request per second to any domain
  • Always save raw scraped data before processing (in data/raw/)
  • If email delivery fails, save report to data/reports/ and retry once after 10 minutes
  • If a URL returns 403/blocked, skip and log — do not retry more than 3 times
  • Report must include: product name, URL, yesterday's price, today's price, % change

Example Config (urls.txt)

https://www.amazon.com/dp/B08N5WRWNW
https://www.amazon.com/dp/B09G9FPHY6
https://www.bestbuy.com/site/product/123456
Usage Guidance
This skill appears internally consistent and implements what it claims, but review and consider the following before installing: - SMTP credentials: Use a dedicated sending account and an app-specific password where possible (do not reuse a personal account password). Limit that account's privileges. - Chromium / ChromeDriver: The script requires a working headless Chromium + chromedriver on the host; SKILL.md mentions webdriver-manager but the script does not use it — ensure your environment supplies a compatible driver. - Rate limiting & legality: The script scrapes third-party sites; confirm you have the right to scrape the target sites and obey their robots/ToS. The script enforces a 1.2s delay and a 1 req/sec guideline, but you should verify that rate is acceptable for your targets. - Data storage: Scraped data and reports are written locally under data/raw and data/reports; ensure sensitive data is stored securely and that recipients are correct to avoid accidental data leaks. - Testing: Run initially with demo/test URLs and with a safe recipient to validate parsing (price extraction is heuristic and may mis-parse some sites). Monitor logs for frequent errors (403s, parsing failures). - Minor code hygiene: The script imports requests and lists webdriver-manager as required even though neither is used; this likely reflects leftover dependencies rather than malicious intent. If you need tighter control, consider: restricting the SMTP account, running the scraper in an isolated environment, and auditing the URL list before running.
Capability Analysis
Type: OpenClaw Skill Name: argus-price-monitor Version: 1.0.2 The skill is a standard price monitoring automation tool that uses Selenium for web scraping and SMTP for email reporting. The implementation in `scripts/run.py` is consistent with the functionality described in `SKILL.md`, and it follows good practices such as rate limiting and error logging. No evidence of malicious intent, data exfiltration, or prompt injection was found.
Capability Assessment
Purpose & Capability
Name/description match the implementation: Selenium scraping, pandas/openpyxl for Excel, and SMTP for email. Required secrets (SMTP_HOST/PORT/USER/PASS and REPORT_RECIPIENT) are appropriate for sending reports.
Instruction Scope
SKILL.md instructs the agent to read config/urls.txt, run scheduled scraping, save raw data under data/raw, and email reports — all of which the script implements. The instructions do not request unrelated files, system credentials, or external endpoints beyond SMTP.
Install Mechanism
This is an instruction-only skill with no install spec, so nothing is downloaded on install (low install risk). Minor mismatch: SKILL.md lists webdriver-manager as a dependency but the provided script does not use webdriver-manager; the script assumes a usable Chromium + chromedriver environment. Users must ensure host has Chromium and a Chrome driver available for Selenium.
Credentials
Only SMTP credentials and a recipient address are required; this is proportionate to sending report emails. No unrelated secrets or broad cloud credentials are requested.
Persistence & Privilege
always is false and the skill does not request any elevated or persistent system-wide privileges, nor does it modify other skills or system configs. It stores scraped data locally under data/ and reports under data/reports.
How to Use
  1. Make sure OpenClaw is installed (local or Docker)
  2. Run the install command in chat: /install argus-price-monitor
  3. After installation, invoke the skill by name or use /argus-price-monitor
  4. Provide required inputs per the skill's parameter spec and get structured output
Version History
v1.0.2
Fix: remove non-standard frontmatter fields, document env vars in markdown body
v1.0.1
Fix: added env vars and runtime declarations for security scan
v1.0.0
Initial release
Metadata
Slug argus-price-monitor
Version 1.0.2
License MIT-0
All-time Installs 0
Active Installs 0
Total Versions 3
Frequently Asked Questions

What is Price Monitor & Daily Excel Report Bot?

Monitors product prices across e-commerce sites daily, detects price drops, and emails a formatted Excel report automatically every morning. It is an AI Agent Skill for Claude Code / OpenClaw, with 148 downloads so far.

How do I install Price Monitor & Daily Excel Report Bot?

Run "/install argus-price-monitor" in the OpenClaw or Claude Code chat to install it in one step — no extra setup required.

Is Price Monitor & Daily Excel Report Bot free?

Yes, Price Monitor & Daily Excel Report Bot is completely free, licensed under MIT-0. You can download, install and use it at no cost.

Which platforms does Price Monitor & Daily Excel Report Bot support?

Price Monitor & Daily Excel Report Bot is cross-platform and runs anywhere OpenClaw / Claude Code is available (cross-platform).

Who created Price Monitor & Daily Excel Report Bot?

It is built and maintained by neo1307 (@neo1307); the current version is v1.0.2.

💬 Comments