Contract Renewal and Alerting Automation for Openclaw

Since this is a fully self-contained skill, setting up your integration with Openclaw Skills is straightforward and requires no external packages besides standard Python Excel parsing dependencies.

1. Prerequisite Installation

Ensure you have openpyxl installed in your environment to read the spreadsheet:

pip install openpyxl

2. Add the Skill Configuration

Include the following configuration parameters inside your agent's config file (e.g., config.json), replacing the paths and webhook key with your real environment parameters:

{
  "contract_renewal": {
    "excel_path": "/Users/mac/美兰中心C+服务.xlsx",
    "alert_days_before": 90,
    "plan_generation_days_before": 60,
    "auto_generate_plan": true,
    "wecom_webhook": "https://qyapi.weixin.qq.com/cgi-bin/webhook/send?key=YOUR_WECOM_WEBHOOK_KEY"
  }
}

3. Setup the Cron Schedule

To run the daily morning contract audit at 09:00 AM (Asia/Shanghai), configure the following cron trigger inside your agent scheduler:

{
  "name": "Contract Renewal Alert",
  "schedule": {
    "kind": "cron",
    "expr": "0 9 * * *",
    "tz": "Asia/Shanghai"
  },
  "payload": {
    "kind": "agentTurn",
    "message": "Check contract expiry dates, flag renewal warnings 3 months ahead, and generate renewal proposals 2 months ahead"
  },
  "sessionTarget": "isolated"
}

The skill interacts with a unified Microsoft Excel workbook containing structured worksheets that map to distinct business modules:

Customer Value Evaluation Parameters

• Rental Contribution (30% Weight): Evaluated annually based on unit area size and rate (High: >= 500k, Mid: 200k-500k, Low: < 100k CNY).
• Enterprise Qualification (25% Weight): Scores the company type (High scores for high-tech or listed companies; moderate for trade or services).
• Payment Punctuality (20% Weight): Calculated as (Paid Fees / Total Invoiced Fees). Points scaled based on ratio (>=95% receives maximum score).
• Service Satisfaction (15% Weight): Based on registered mood ratings during visits.
• Transaction Contribution (10% Weight): Quantifies the cross-selling conversion rate.