openclaw-executive-assistant-workflows

Compare original and translation side by side

🇺🇸

Original

English
🇨🇳

Translation

Chinese

OpenClaw Executive Assistant Workflows

OpenClaw执行助理工作流

Skill by ara.so — Hermes Skills collection.
This skill covers building local-first executive assistant workflows using OpenClaw patterns. The project demonstrates three core workflows: data intake review, operational memory tracking, and offline communications triage. All operations use local files and produce reviewable markdown artifacts.
ara.so开发的Skill — Hermes Skills合集。
本Skill介绍如何使用OpenClaw模式构建本地优先的执行助理工作流。该项目展示了三个核心工作流:数据收集审核、操作记忆追踪和离线通信分类。所有操作均使用本地文件,并生成可审阅的markdown产物。

What This Project Does

项目功能

OpenClaw executive assistant workflows help you:
  • Data Intake Review: Transform unknown files into trustworthy intake reports
  • Operational Memory: Convert work residue into daily logs and weekly momentum documents
  • Offline Communications Triage: Turn exported emails into prioritized action lists
All workflows are local-only with no live integrations, using copy/paste prompts and markdown outputs.
OpenClaw执行助理工作流可帮助您:
  • 数据收集审核:将未知文件转换为可信的收集报告
  • 操作记忆:将工作残留内容转换为每日日志和每周进展文档
  • 离线通信分类:将导出的邮件转换为优先级行动列表
所有工作流均为纯本地操作,无实时集成,使用复制粘贴提示词和markdown输出。

Project Structure

项目结构

code-along/
├── INDEX.md
├── 01-data-intake-review/
│   ├── incoming/           # Files to inspect
│   ├── prompts/
│   │   └── intake-review.md
│   ├── outputs/
│   │   └── intake-review.md
│   └── expected/
│       └── report-outline.md
├── 02-operational-memory/
│   ├── inbox/              # Notes and work residue
│   ├── prompts/
│   │   ├── daily-log.md
│   │   └── weekly-hype.md
│   ├── outputs/
│   │   ├── daily-log.md
│   │   └── weekly-hype.md
│   └── schedule/
│       ├── cron-examples.md
│       └── heartbeat-note.md
├── 03-offline-communications-triage/
│   ├── eml/                # Exported email files
│   ├── prompts/
│   │   └── email-triage.md
│   ├── outputs/
│   │   └── email-triage.md
│   └── expected/
│       └── report-outline.md
└── mission-control/        # Optional dashboard
code-along/
├── INDEX.md
├── 01-data-intake-review/
│   ├── incoming/           # 待检查文件
│   ├── prompts/
│   │   └── intake-review.md
│   ├── outputs/
│   │   └── intake-review.md
│   └── expected/
│       └── report-outline.md
├── 02-operational-memory/
│   ├── inbox/              # 笔记和工作残留内容
│   ├── prompts/
│   │   ├── daily-log.md
│   │   └── weekly-hype.md
│   ├── outputs/
│   │   ├── daily-log.md
│   │   └── weekly-hype.md
│   └── schedule/
│       ├── cron-examples.md
│       └── heartbeat-note.md
├── 03-offline-communications-triage/
│   ├── eml/                # 导出的邮件文件
│   ├── prompts/
│   │   └── email-triage.md
│   ├── outputs/
│   │   └── email-triage.md
│   └── expected/
│       └── report-outline.md
└── mission-control/        # 可选控制面板

Workflow 1: Data Intake Review

工作流1:数据收集审核

Transform incoming files into structured reports.
将传入文件转换为结构化报告。

Setup

设置

bash
cd code-along/01-data-intake-review
bash
cd code-along/01-data-intake-review

Usage Pattern

使用模式

  1. Place unknown files in
    incoming/
  2. Read the prompt template in
    prompts/intake-review.md
  3. Run the prompt against the incoming files
  4. Generate
    outputs/intake-review.md
  1. 将未知文件放入
    incoming/
    目录
  2. 阅读
    prompts/intake-review.md
    中的提示词模板
  3. 针对传入文件运行提示词
  4. 生成
    outputs/intake-review.md

Example Prompt Structure

示例提示词结构

markdown
undefined
markdown
undefined

Data Intake Review Prompt

数据收集审核提示词

Review all files in the incoming/ directory and create a structured report:
审核incoming/目录中的所有文件并创建结构化报告:

Summary

摘要

  • Total files reviewed
  • File types present
  • Overall assessment
  • 已审核文件总数
  • 存在的文件类型
  • 整体评估

File-by-File Analysis

逐文件分析

For each file:
  • Filename
  • Type
  • Size
  • Key contents
  • Recommendation (keep/archive/delete/action)
针对每个文件:
  • 文件名
  • 类型
  • 大小
  • 核心内容
  • 建议(保留/归档/删除/处理)

Action Items

行动项

List any files requiring immediate attention
列出需要立即关注的文件

Archive Candidates

归档候选

List files safe to archive
undefined
列出可安全归档的文件
undefined

Expected Output Format

预期输出格式

markdown
undefined
markdown
undefined

Intake Review - [DATE]

收集审核 - [日期]

Summary

摘要

3 files reviewed
  • 1 PDF document
  • 1 CSV dataset
  • 1 text note
已审核3个文件
  • 1份PDF文档
  • 1个CSV数据集
  • 1份文本笔记

File Analysis

文件分析

document.pdf

document.pdf

  • Type: PDF proposal
  • Size: 2.4 MB
  • Contents: Q2 budget proposal draft
  • Recommendation: ACTION - Review by EOD Friday
  • 类型:PDF提案
  • 大小:2.4 MB
  • 内容:Q2预算提案草稿
  • 建议:处理 - 周五下班前完成审核

data.csv

data.csv

  • Type: CSV dataset
  • Size: 145 KB
  • Contents: Customer feedback responses
  • Recommendation: KEEP - Reference for analysis
  • 类型:CSV数据集
  • 大小:145 KB
  • 内容:客户反馈回复
  • 建议:保留 - 供分析参考

Action Items

行动项

  1. Review document.pdf budget proposal
  2. Schedule feedback analysis meeting
undefined
  1. 审核document.pdf预算提案
  2. 安排反馈分析会议
undefined

Workflow 2: Operational Memory

工作流2:操作记忆

Convert daily work residue into structured logs and weekly summaries.
将日常工作残留内容转换为结构化日志和每周总结。

Setup

设置

bash
cd code-along/02-operational-memory
bash
cd code-along/02-operational-memory

Daily Log Generation

每日日志生成

markdown
undefined
markdown
undefined

Daily Log Prompt

每日日志提示词

Review all notes and work artifacts in inbox/ from today.
Generate a daily log with:
审核inbox/目录中今日的所有笔记和工作产物。
生成包含以下内容的每日日志:

Work Completed

已完成工作

  • Tasks finished
  • Decisions made
  • Problems solved
  • 已完成任务
  • 已做出的决策
  • 已解决的问题

In Progress

进行中

  • Ongoing work
  • Blockers encountered
  • 正在进行的工作
  • 遇到的障碍

Notes for Tomorrow

明日事项

  • Priorities
  • Follow-ups needed
  • 优先级
  • 需要跟进的内容

Quick Wins

小成就

  • Small achievements worth noting
undefined
  • 值得记录的小成果
undefined

Weekly Summary Generation

每周总结生成

markdown
undefined
markdown
undefined

Weekly Hype Prompt

每周进展提示词

Review the past week's daily logs.
Create a weekly summary:
审核过去一周的每日日志。
创建包含以下内容的每周总结:

🎯 Goals Achieved

🎯 已完成目标

What got done this week
本周完成的工作

📈 Progress Made

📈 进展情况

Movement on larger initiatives
大型项目的推进

🔥 Highlights

🔥 亮点

Wins worth celebrating
值得庆祝的成果

🚀 Next Week Focus

🚀 下周重点

Top 3 priorities
Top 3优先级事项

💡 Lessons Learned

💡 经验总结

Key insights from the week
undefined
本周获得的关键见解
undefined

Automation with Cron

使用Cron实现自动化

Example cron configuration for daily logs:
bash
undefined
每日日志的示例cron配置:
bash
undefined

Daily log at 5 PM

每日下午5点生成日志

0 17 * * * cd ~/code-along/02-operational-memory && ./generate-daily-log.sh
0 17 * * * cd ~/code-along/02-operational-memory && ./generate-daily-log.sh

Weekly summary on Friday at 4 PM

每周五下午4点生成每周总结

0 16 * * 5 cd ~/code-along/02-operational-memory && ./generate-weekly-hype.sh
undefined
0 16 * * 5 cd ~/code-along/02-operational-memory && ./generate-weekly-hype.sh
undefined

Example Script

示例脚本

bash
#!/bin/bash
bash
#!/bin/bash

generate-daily-log.sh

generate-daily-log.sh

DATE=$(date +%Y-%m-%d) PROMPT_FILE="prompts/daily-log.md" OUTPUT_FILE="outputs/daily-log-${DATE}.md"
DATE=$(date +%Y-%m-%d) PROMPT_FILE="prompts/daily-log.md" OUTPUT_FILE="outputs/daily-log-${DATE}.md"

Read prompt and process inbox

读取提示词并处理inbox目录

echo "Generating daily log for ${DATE}..."
echo "正在生成${DATE}的每日日志..."

Copy prompt template

复制提示词模板

cp "$PROMPT_FILE" "$OUTPUT_FILE"
cp "$PROMPT_FILE" "$OUTPUT_FILE"

Add date header

添加日期标题

echo "# Daily Log - ${DATE}" >> "$OUTPUT_FILE"
echo "# Daily Log - ${DATE}" >> "$OUTPUT_FILE"

Process would happen here via AI agent

此处将通过AI Agent处理

This is a manual copy/paste workflow in the workshop

这是工作坊中的手动复制粘贴工作流

undefined
undefined

Workflow 3: Offline Communications Triage

工作流3:离线通信分类

Transform exported emails into actionable reports.
将导出的邮件转换为可执行报告。

Setup

设置

bash
cd code-along/03-offline-communications-triage
bash
cd code-along/03-offline-communications-triage

Email Export Process

邮件导出流程

Export emails to
.eml
format and place in the
eml/
directory.
将邮件导出为
.eml
格式并放入
eml/
目录。

Triage Prompt Structure

分类提示词结构

markdown
undefined
markdown
undefined

Email Triage Prompt

邮件分类提示词

Review all .eml files in the eml/ directory.
Create a triage report:
审核eml/目录中的所有.eml文件。
创建包含以下内容的分类报告:

🚨 Urgent - Respond Today

🚨 紧急 - 今日回复

Emails requiring immediate attention
需要立即关注的邮件

📋 Action Required - This Week

📋 需要处理 - 本周内

Emails needing response within 3-5 days
需在3-5天内回复的邮件

📖 For Review

📖 待审阅

Informational emails worth reading
值得阅读的信息类邮件

🗑️ Low Priority

🗑️ 低优先级

Can be archived or handled later
For each email include:
  • From
  • Subject
  • Date
  • Brief summary
  • Recommended action
  • Estimated time required
undefined
可归档或稍后处理
针对每封邮件包含:
  • 发件人
  • 主题
  • 日期
  • 简要摘要
  • 建议操作
  • 预计所需时间
undefined

Expected Output

预期输出

markdown
undefined
markdown
undefined

Email Triage Report - 2026-04-25

邮件分类报告 - 2026-04-25

🚨 Urgent - Respond Today

🚨 紧急 - 今日回复

Email 1

邮件1

  • From: sarah@company.com
  • Subject: Q2 Budget Approval Needed
  • Date: 2026-04-25 09:15 AM
  • Summary: Budget requires sign-off before Monday meeting
  • Action: Review and approve budget spreadsheet
  • Time: 30 minutes
  • 发件人sarah@company.com
  • 主题:Q2预算审批需求
  • 日期:2026-04-25 09:15 AM
  • 摘要:预算需在周一会议前完成签署
  • 操作:审核并批准预算表格
  • 时间:30分钟

📋 Action Required - This Week

📋 需要处理 - 本周内

Email 2

邮件2

  • From: team@project.com
  • Subject: Design Review Feedback
  • Date: 2026-04-24 02:30 PM
  • Summary: Design mockups ready for review
  • Action: Provide feedback on 3 design options
  • Time: 45 minutes
  • 发件人team@project.com
  • 主题:设计审核反馈
  • 日期:2026-04-24 02:30 PM
  • 摘要:设计原型已准备好审核
  • 操作:针对3个设计方案提供反馈
  • 时间:45分钟

📖 For Review

📖 待审阅

Email 3

邮件3

  • From: newsletter@industry.com
  • Subject: Weekly Industry Update
  • Date: 2026-04-24 08:00 AM
  • Summary: Market trends and competitor news
  • Action: Read when available
  • Time: 15 minutes
undefined
  • 发件人newsletter@industry.com
  • 主题:每周行业更新
  • 日期:2026-04-24 08:00 AM
  • 摘要:市场趋势和竞品动态
  • 操作:有空时阅读
  • 时间:15分钟
undefined

Mission Control Dashboard

任务控制仪表盘

Optional central hub for linking all artifacts.
markdown
undefined
可选的中心枢纽,用于链接所有产物。
markdown
undefined

Mission Control

任务控制

Last updated: 2026-04-25 17:00
最后更新时间:2026-04-25 17:00

📥 Latest Intake Review

📥 最新收集审核

View Report
  • 3 files processed
  • 1 action item pending
查看报告
  • 已处理3个文件
  • 1项待完成行动项

📝 Today's Log

📝 今日日志

View Log
  • 5 tasks completed
  • 2 in progress
查看日志
  • 已完成5项任务
  • 2项进行中

📧 Email Triage

📧 邮件分类

View Report
  • 1 urgent response needed
  • 3 actions this week
undefined
查看报告
  • 1项紧急回复需求
  • 3项本周待处理任务
undefined

Best Practices

最佳实践

Prompt Design

提示词设计

  • Keep prompts clear and structured
  • Define expected output format explicitly
  • Include examples in prompt templates
  • Use consistent markdown formatting
  • 保持提示词清晰且结构化
  • 明确定义预期输出格式
  • 在提示词模板中包含示例
  • 使用一致的markdown格式

File Organization

文件组织

workflow-name/
├── incoming/     # Raw inputs
├── prompts/      # Reusable prompt templates
├── outputs/      # Generated artifacts
└── expected/     # Reference outputs
workflow-name/
├── incoming/     # 原始输入
├── prompts/      # 可复用提示词模板
├── outputs/      # 生成的产物
└── expected/     # 参考输出

Artifact Naming

产物命名

Use consistent naming conventions:
daily-log-YYYY-MM-DD.md
weekly-hype-YYYY-WW.md
intake-review-YYYY-MM-DD.md
email-triage-YYYY-MM-DD.md
使用一致的命名规范:
daily-log-YYYY-MM-DD.md
weekly-hype-YYYY-WW.md
intake-review-YYYY-MM-DD.md
email-triage-YYYY-MM-DD.md

Workflow Execution

工作流执行

  1. Read the prompt template
  2. Customize for current context
  3. Process input files
  4. Generate markdown artifact
  5. Review and refine output
  6. Archive or act on results
  1. 阅读提示词模板
  2. 根据当前上下文自定义
  3. 处理输入文件
  4. 生成markdown产物
  5. 审阅并优化输出
  6. 归档或执行结果

Troubleshooting

故障排除

Prompt Not Producing Expected Output

提示词未生成预期输出

  • Check that input files are in correct location
  • Verify prompt includes output format specification
  • Add explicit examples to prompt
  • Break complex prompts into smaller steps
  • 检查输入文件是否在正确位置
  • 验证提示词是否包含输出格式说明
  • 在提示词中添加明确示例
  • 将复杂提示词拆分为更小的步骤

Missing Context in Reports

报告中缺少上下文

  • Include date/time stamps in prompts
  • Reference previous artifacts when needed
  • Add context sections to prompt templates
  • 在提示词中包含日期/时间戳
  • 必要时参考之前的产物
  • 在提示词模板中添加上下文部分

Automation Issues

自动化问题

  • Verify file paths in cron scripts
  • Check script permissions:
    chmod +x script.sh
  • Test scripts manually before scheduling
  • Log script output for debugging
  • 验证cron脚本中的文件路径
  • 检查脚本权限:
    chmod +x script.sh
  • 调度前手动测试脚本
  • 记录脚本输出以便调试

File Format Problems

文件格式问题

  • Ensure
    .eml
    files are properly exported
  • Check markdown syntax in outputs
  • Validate file encoding (UTF-8)
  • 确保.eml文件已正确导出
  • 检查输出中的markdown语法
  • 验证文件编码(UTF-8)

Integration with AI Coding Agents

与AI编码Agent集成

This workflow integrates with AI agents by:
  1. Structured Prompts: Templates that agents can execute
  2. File-Based I/O: Clear input/output locations
  3. Markdown Artifacts: Reviewable, versionable outputs
  4. Local-First: No API dependencies
Agents can automate:
  • Reading prompt templates
  • Processing input directories
  • Generating formatted outputs
  • Updating mission control dashboard
本工作流通过以下方式与AI Agent集成:
  1. 结构化提示词:Agent可执行的模板
  2. 基于文件的I/O:明确的输入/输出位置
  3. Markdown产物:可审阅、可版本控制的输出
  4. 本地优先:无API依赖
Agent可自动化以下操作:
  • 读取提示词模板
  • 处理输入目录
  • 生成格式化输出
  • 更新任务控制仪表盘