CRM 管理器:本地 CSV 漏斗管理 - Openclaw Skills
作者:互联网
2026-03-29
什么是 CRM 管理器?
CRM 管理器是专为 Openclaw Skills 生态系统设计的专业实用工具,它使用便携的本地 CSV 文件取代了繁重的 SaaS CRM 平台。它使您的 AI 代理能够在不离开开发环境的情况下,维护潜在客户、公司和交易的结构化数据库。通过利用简单的平面文件架构,它确保您的销售数据保持私密、可进行版本控制,并且易于用于自动化报告。
该技能非常适合需要维护整洁、有序的销售漏斗,且无需承担复杂软件开销的开发者和个人创业者。凭借对从初始潜在客户到成交入账各阶段的内置支持,它将您的 AI 代理转化为一个主动的销售助理,管理每个联系人的全生命周期。
下载入口:https://github.com/openclaw/skills/tree/main/skills/1kalin/afrexai-crm-updater
安装与下载
1. ClawHub CLI
从源直接安装技能的最快方式。
npx clawhub@latest install afrexai-crm-updater
2. 手动安装
将技能文件夹复制到以下位置之一
全局模式~/.openclaw/skills/
工作区
/skills/
优先级:工作区 > 本地 > 内置
3. 提示词安装
将此提示词复制到 OpenClaw 即可自动安装。
请帮我使用 Clawhub 安装 afrexai-crm-updater。如果尚未安装 Clawhub,请先安装(npm i -g clawhub)。
CRM 管理器 应用场景
- 跟踪新潜在客户并通过自定义漏斗阶段进行筛选。
- 以仅追加格式记录会议笔记和交互历史。
- 直接从您的工作区管理交易价值并预测收入。
- 自动安排跟进操作,确保不会忽略任何潜在客户。
- 生成即时漏斗摘要,快速检查销售健康状况。
- 代理初始化或读取位于本地工作区的 crm.csv 文件。
- 添加联系人时,该技能生成唯一 ID 并将初始阶段设置为 lead(潜在客户)。
- 对于更新,代理执行查找,修改相关字段,并自动更新时间戳。
- 在进行任何批量或关键修改之前,该技能会创建带有时间戳的 CSV 文件备份。
- 代理应用漏斗健康逻辑,为用户标记逾期任务或停滞交易。
CRM 管理器 配置指南
要使用 Openclaw Skills 将此功能集成到您的工作流中,请确保已安装 CRM 更新程序组件。您可以通过 CLI 安装:
clawhub install afrexai-crm-updater
确保工作区根目录中存在 crm.csv 文件。如果是重新开始,请使用以下标题行初始化文件: id,name,company,email,phone,stage,deal_value,source,last_contact,next_action,next_action_date,notes,created,updated
CRM 管理器 数据架构与分类体系
CRM 管理器利用结构化的 CSV 格式来确保不同 Openclaw Skills 之间的兼容性。模式包括:
| 字段 | 类型 | 描述 |
|---|---|---|
| id | 整数 | 自动递增的唯一标识符 |
| stage | 字符串 | 当前漏斗状态(例如:lead, proposal, closed-won) |
| deal_value | 数值 | 机会的预计美元价值 |
| next_action_date | 日期 | 计划的跟进日期 (YYYY-MM-DD) |
| notes | 字符串 | 以竖线分隔的交互历史 |
| updated | 日期 | 自动生成的最后修改时间戳 |
name: CRM Manager
description: Manages a local CSV-based CRM with pipeline tracking
CRM Manager
You manage a lightweight CRM stored as a local CSV file. No Salesforce needed — just a clean, organized pipeline you can actually maintain.
CRM File Location
Default: crm.csv in the workspace. Create from crm-template.csv if it doesn't exist.
CSV Structure
id,name,company,email,phone,stage,deal_value,source,last_contact,next_action,next_action_date,notes,created,updated
Fields
| Field | Description | Required |
|---|---|---|
| id | Auto-increment integer | Yes |
| name | Contact's full name | Yes |
| company | Company name | Yes |
| Email address | No | |
| phone | Phone number | No |
| stage | Pipeline stage (see below) | Yes |
| deal_value | Estimated deal value in USD | No |
| source | How they found you / you found them | No |
| last_contact | Date of last interaction (YYYY-MM-DD) | Yes |
| next_action | What to do next | Yes |
| next_action_date | When to do it (YYYY-MM-DD) | Yes |
| notes | Freeform notes, pipe-separated for multiple | No |
| created | Date added (YYYY-MM-DD) | Yes |
| updated | Date last modified (YYYY-MM-DD) | Yes |
Pipeline Stages
- lead — New contact, not yet qualified
- qualified — Confirmed they have budget, need, and authority
- meeting — Meeting scheduled or completed
- proposal — Proposal/quote sent
- negotiation — Working out terms
- closed-won — Deal done
- closed-lost — Didn't work out
- nurture — Not ready now, stay in touch
Commands
When the user asks you to manage CRM data, handle these actions:
Add a Contact
"Add [name] from [company] to the CRM" → Create a new row, set stage to "lead", set created/updated to today.
Update a Contact
"Update [name] — had a call today, moving to proposal stage" → Update stage, last_contact, next_action, notes, updated date.
Show Pipeline
"Show me my pipeline" / "What's in my CRM?" → Display contacts grouped by stage with deal values.
Follow-up Reminders
"What follow-ups are due?" / "Who should I contact?" → Show contacts where next_action_date ≤ today, sorted by date.
Pipeline Summary
"Pipeline summary" → Show: total contacts per stage, total deal value per stage, overdue follow-ups count.
Search
"Find [name/company]" → Search across name and company fields.
Move Stage
"Move [name] to [stage]" → Update stage and updated date.
Rules
- Always read the CSV before making changes (don't assume state)
- Always update the
updatedfield when modifying a row - Never delete rows — move to closed-lost or nurture instead
- Keep notes append-only (add new notes with pipe separator, don't overwrite)
- When showing pipeline, format as a clean table
- Warn if a contact has no next_action_date or it's overdue
- Back up the CSV before bulk operations (copy to crm-backup-YYYY-MM-DD.csv)
Pipeline Health Checks
Periodically flag:
- Contacts with no activity in 14+ days
- Deals stuck in the same stage for 30+ days
- Missing next actions
- Leads with no follow-up scheduled
?? More AfrexAI Skills (Free on ClawHub)
| Skill | Install |
|---|---|
| AI Humanizer | clawhub install afrexai-humanizer |
| SEO Writer | clawhub install afrexai-seo-writer |
| Email Crafter | clawhub install afrexai-email-crafter |
| Proposal Generator | clawhub install afrexai-proposal-gen |
| Invoice Generator | clawhub install afrexai-invoice-gen |
| Lead Scorer | clawhub install afrexai-lead-scorer |
| Client Onboarding | clawhub install afrexai-onboarding |
| Meeting Prep | clawhub install afrexai-meeting-prep |
| Social Repurposer | clawhub install afrexai-social-repurposer |
| FAQ Builder | clawhub install afrexai-faq-builder |
| Review Responder | clawhub install afrexai-review-responder |
| Report Builder | clawhub install afrexai-report-builder |
| CRM Updater | clawhub install afrexai-crm-updater |
| Pitch Deck Reviewer | clawhub install afrexai-pitch-deck-reviewer |
| Contract Analyzer | clawhub install afrexai-contract-analyzer |
| Pricing Optimizer | clawhub install afrexai-pricing-optimizer |
| Testimonial Collector | clawhub install afrexai-testimonial-collector |
| Competitor Monitor | clawhub install afrexai-competitor-monitor |
?? Go Pro: Industry Context Packs ($47/pack)
Make your AI agent a true industry expert with deep domain knowledge.
→ Browse Context Packs
Free tools: AI Revenue Calculator | Agent Setup Wizard
Built by AfrexAI ????
相关推荐
专题
+ 收藏
+ 收藏
+ 收藏
+ 收藏
+ 收藏
最新数据
相关文章
信号管道:自动化营销情报工具 - Openclaw Skills
技能收益追踪器:监控 Openclaw 技能并实现变现
AI 合规准备就绪度:评估与治理工具 - Openclaw Skills
FOSMVVM ServerRequest 测试生成器:自动化 API 测试 - Openclaw Skills
酒店搜索器:AI 赋能的住宿与位置情报 - Openclaw Skills
Dub 链接 API:程序化链接管理 - Openclaw Skills
IntercomSwap:P2P BTC 与 USDT 跨链兑换 - Openclaw Skills
spotplay:macOS 原生 Spotify 播放控制 - Openclaw Skills
DeepSeek OCR:AI驱动的图像文本识别 - Openclaw Skills
Web Navigator:自动化网页研究与浏览 - Openclaw Skills
AI精选
