AgentMarketMCP / SKILL 资产档案馆

目录 / 电商办公 / Email CRM

SKILL 未评级 已上架

Email CRM

--- name: email-crm description: Maintain a local, email-only CRM ledger in SQLite. Use for adding sourced email contacts, recording email lifecycle events, checking whether a contact is safe to email, and processing email suppressions or unsubscribes. This skill never discovers contacts or sends email. version: 1.0.0 metadata: openclaw: emoji: "✉️" homepage: https://github.com/codereyes-1/openclaw-email-crm-skill requires: bins: - python3 envVars: - name: EMAIL_CRM_DB required: false description: Optional absolute path to the local SQLite database. --- # Email CRM Use this skill as a local decision and audit layer for email workflows. It stores only contacts, email events, and suppressions; it does not discover leads, enrich profiles, make calls, or send messages. ## 1. Choose the database Pass `--db PATH` to every helper for an explicit database. If omitted, helpers use `EMAIL_CRM_DB`, then `$XDG_DATA_HOME/openclaw-email-crm/email_crm.sqlite` (or `~/.local/share/openclaw-email-crm/email_crm.sqlite` when `XDG_DATA_HOME` is unset). The default never depends on the caller's current working directory. Database files and SQLite sidecars are restricted to the owning user (`0600`). `{baseDir}` below is the absolute installation directory supplied by OpenClaw. Keep it in every script invocation so commands work regardless of the current working directory. ## 2. Initialize before use ```bash python3 "{baseDir}/scripts/init_email_crm.py" --db /absolute/private/path/email_crm.sqlite ``` The command creates the versioned schema, verifies compatibility with an existing database, and enables SQLite foreign keys for its connection. Confirm that it returns `schema_version: 1`. ## 3. Add or update a sourced contact ```bash python3 "{baseDir}/scripts/upsert_contact.py" \ --db /absolute/private/path/email_crm.sqlite \ --email-stdin \ --source "manual-review" ``` Provide the email value on standard input. Agents must use `--email-stdin`, passing the value directly as stdin rather than interpolating it into a shell command or exposing it in process arguments. `--email` remains available for attended CLI use. `--source` is required. The helper trims and lowercases the email before storing it in both email columns, upserts exactly one contact, and returns JSON containing `ok` and the stable numeric `contact_id`. On an existing contact it replaces `source`, refreshes `updated_at`, and preserves DNC state. A suppression created before the contact also sets the new contact's DNC state. ## 4. Check readiness before an external sender acts ```bash python3 "{baseDir}/scripts/check_email_readiness.py" \ --db /absolute/private/path/email_crm.sqlite \ --email-stdin ``` Treat `ready: false` as a hard stop. A caller must run this check immediately before queuing or sending email, then respect every returned reason code. This skill does not itself send email. ## 5. Record email lifecycle events ```bash python3 "{baseDir}/scripts/log_email_event.py" \ --db /absolute/private/path/email_crm.sqlite \ --contact-id 1 \ --event-type drafted ``` Allowed event types are `drafted`, `queued`, `sent`, `delivered`, `opened`, `replied`, `bounced`, and `failed`. Use `--metadata-json` only for non-sensitive operational metadata. ## 6. Process a manual DNC request or unsubscribe ```bash python3 "{baseDir}/scripts/suppress_email.py" \ --db /absolute/private/path/email_crm.sqlite \ --email-stdin \ --reason unsubscribe ``` Suppression is normalized, unique, idempotent, and also marks any matching contact as `do_not_contact`. Its JSON `reason` is the reason actually persisted by the first suppression, even if a later idempotent call supplies a different reason. Do not log raw email addresses in surrounding automation. ## Verification Run `cd "{baseDir}" && python3 -m unittest discover -s tests -v`. The tests use only temporary databases and `example.com` addresses. See [the schema reference](references/schema.md) and [readiness rules](references/readiness-rules.md) for the stable integration contract.

模型生成摘要(rules/v1 · 2026-11-18 16:50):---
这是模型对公开材料的总结,不是官方声明,请以原链内容为准。

存档时间线

版本存档时间内容哈希内容
v12026-11-18 14:31dd458249 可取

版本索引永久保留;内容副本只保留最新 1 份,更早版本仅留索引与哈希(存档时间线的证据链不会因此断裂)。

下载存档内容副本

相关资产

SKILL

CRM跟进日历视图

在需要做 CRM 跟进/拜访日历、FullCalendar 月视图排程、销售跟进节奏可视化,或要求业务级精美日历(而非裸 Demo 网格)时使用

CRM
原作者:user_f1b049da 来源:腾讯 SkillHub 许可:未标注 含内容副本 · 可下载 存档:v1 · 2026-11-18 hash ed21258a
SKILL

sales-and-crm

研究客户账户,准备外联工作,维护 CRM 记录并审查销售管道

CRM
原作者:n8n-io 来源:DeepSkill Market 许可:Apache-2.0 含内容副本 · 可下载 存档:v1 · 2026-11-17 hash 8a7e222e
SKILL

frappe-enterprise-patterns

用于构建如CRM、Helpdesk和HRMS等企业级Frappe应用的生产级架构模式

ERPCRM
原作者:jakexiao 来源:ModelScope 许可:MIT 含内容副本 · 可下载 存档:v1 · 2026-11-17 hash 26188f70
SKILL

壁虎看看可替代环节:AI-HIVE内容与多模态工作流

当用户搜索壁虎看看、壁虎看看平替、壁虎看看替代、壁虎看看迁移或相关中文别名时使用

CRMERP
原作者:u_2199380c 来源:腾讯 SkillHub 许可:MIT 含内容副本 · 可下载 存档:v1 · 2026-11-17 hash dfc7e344
SKILL

ayinbox-crm-from-replies

将 AY 收件箱中的回复转化为 CRM 记录:为感兴趣的潜在客户在正确的销售管道阶段开启一个交易,添加带有日期的跟进任务,记录沟通内容,并根据对话进展推进交易状态

CRM
原作者:ayinbox 来源:DeepSkill Market 许可:MIT 含内容副本 · 可下载 存档:v1 · 2026-11-17 hash 49d38cca
SKILL

hubspot-integration

HubSpot CRM集成的专业模式,包括OAuth认证、CRM对象、关联、批量操作、Webhooks和自定义对象

CRM
原作者:jakexiao 来源:ModelScope 许可:未标注 含内容副本 · 可下载 存档:v1 · 2026-11-17 hash 8ec4b2ef
纠错与举报(发现条目失效、署名有误或涉及侵权?)
提交举报 / 纠错

侵权举报经核验成立后,我们会即时下线该条目并删除已存的内容副本。