← 返回 Skills 市场

Price Monitor & Daily Excel Report Bot

Name: Price Monitor & Daily Excel Report Bot
Author: neo1307

作者 neo1307 · GitHub ↗ · v1.0.2 · MIT-0

cross-platform ✓ 安全检测通过

148

总下载

当前安装

版本数

在 OpenClaw 中安装

/install argus-price-monitor

功能描述

Monitors product prices across e-commerce sites daily, detects price drops, and emails a formatted Excel report automatically every morning.

使用说明 (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

Add target product URLs to config/urls.txt (one URL per line)
Set all environment variables above in OpenClaw Secrets
Set run schedule in OpenClaw: daily at 08:00
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

安全使用建议

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.

功能分析

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.

能力评估

✓ 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.

如何使用

确保已安装 OpenClaw（本地或 Docker 部署）
在对话框中输入安装命令：/install argus-price-monitor
安装完成后，直接呼叫该 Skill 的名称或使用 /argus-price-monitor 触发
根据 Skill 的参数说明提供必要输入，即可获得结构化输出

版本历史

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

元数据

Slug argus-price-monitor

版本 1.0.2

许可证 MIT-0

累计安装 0

当前安装数 0

历史版本数 3

常见问题