← 返回 Skills 市场
QuickBooks Mileage CSV
作者
Oasis Engineering
· GitHub ↗
· v1.0.0
· MIT-0
33
总下载
0
收藏
0
当前安装
1
版本数
在 OpenClaw 中安装
/install qbo-mileage
功能描述
Generate QuickBooks Online mileage CSV files from Airtable, Outlook, or Google Calendar records using the local qbo-mileage CLI and user-owned credentials.
使用说明 (SKILL.md)
QuickBooks Mileage CSV
Use this skill when the user wants to generate, review, or schedule a QuickBooks Online mileage CSV from calendar or inspection data.
Do not infer or hand-edit mileage rows in the prompt. Run the deterministic CLI from the plugin root so trip pairing, distance caching, CSV formatting, and run reports are produced by code.
Common commands
Dry run:
python -m qbo_mileage generate --config config.json --month YYYY-MM --dry-run
Generate files:
python -m qbo_mileage generate --config config.json --month YYYY-MM
Outputs are written under the configured output directory, normally
quickbooks_mileage/YYYY-MM/.
Review checklist
- Confirm the requested month is correct.
- Confirm the configured home base and vehicle.
- Read
run_report.mdbefore telling the user the CSV is ready. - Surface skipped events, missing addresses, and distance API failures.
- Remind the user that GitHub Actions or cloud/email output is not local-only.
Setup guidance
For first-time setup, point the user to:
config.example.jsondocs/setup-airtable.mddocs/setup-maps.mddocs/setup-scheduling.md
安全使用建议
Before installing, narrow the Outlook OAuth scope unless you explicitly need Microsoft Graph email sending, protect all config and token files, run a dry run first, and avoid enabling email, cloud storage, GitHub Actions, or recurring schedules until you are comfortable with those data flows.
功能分析
Type: OpenClaw Skill
Name: qbo-mileage
Version: 1.0.0
The qbo-mileage skill is a legitimate utility designed to generate QuickBooks Online mileage CSVs from various data sources including Airtable, Google Calendar, and Outlook. The Python implementation (qbo_mileage/) uses standard libraries to fetch event data via official APIs (Airtable, Microsoft Graph, Google Calendar), calculates distances using the Google Routes API with local caching (cache.py), and provides optional email delivery of reports. The SKILL.md instructions correctly guide the AI agent to use the deterministic CLI rather than hallucinating data. The code and documentation (README.md, docs/) emphasize local data handling and security best practices, such as using environment variables for secrets and advising against committing credentials. No evidence of malicious intent, data exfiltration to unauthorized endpoints, or prompt injection was found.
能力标签
能力评估
Purpose & Capability
Generating QuickBooks mileage CSVs from Airtable/calendar data is coherent with the code, but the Outlook calendar adapter defaults to a send-mail OAuth scope that is broader than needed for calendar reads.
Instruction Scope
The SKILL.md workflow is user-directed and asks the agent to run the CLI and review the report; generate mode can write files and use configured external/email providers.
Install Mechanism
There is no installer or remote download path in the artifacts, but the source/homepage provenance is limited and users should review the included Python code before running it.
Credentials
User-owned API keys, OAuth refresh tokens, and optional SMTP/email credentials are expected, but registry metadata under-declares them and the Outlook default scope is overbroad.
Persistence & Privilege
The skill uses a local distance cache and documents optional scheduling/GitHub Actions; these are disclosed and user-configured, not hidden automatic persistence.
如何使用
- 确保已安装 OpenClaw（本地或 Docker 部署）
- 在对话框中输入安装命令：
/install qbo-mileage - 安装完成后，直接呼叫该 Skill 的名称或使用
/qbo-mileage触发 - 根据 Skill 的参数说明提供必要输入，即可获得结构化输出
版本历史
v1.0.0
Initial release of qbo-mileage skill.
- Generate QuickBooks Online mileage CSV files from Airtable, Outlook, or Google Calendar data using the local CLI and user credentials.
- Provides commands for dry runs and file generation, with outputs organized by month.
- Includes a review checklist to ensure accuracy of data before confirming CSV readiness.
- Guides users through first-time setup with example config files and setup documentation.
元数据
常见问题
QuickBooks Mileage CSV 是什么？
Generate QuickBooks Online mileage CSV files from Airtable, Outlook, or Google Calendar records using the local qbo-mileage CLI and user-owned credentials. 它是一个面向 Claude Code / OpenClaw 的 AI Agent Skill 插件，目前累计下载 33 次。
如何安装 QuickBooks Mileage CSV？
在 OpenClaw 或 Claude Code 对话框中运行命令「/install qbo-mileage」即可一键安装，无需额外配置。
QuickBooks Mileage CSV 是免费的吗？
是的，QuickBooks Mileage CSV 完全免费，采用 MIT-0 许可证，可自由下载、安装和使用。
QuickBooks Mileage CSV 支持哪些平台？
QuickBooks Mileage CSV 跨平台运行，可在任意部署了 OpenClaw / Claude Code 的环境中使用（cross-platform）。
谁开发了 QuickBooks Mileage CSV？
由 Oasis Engineering（@oasiseng）开发并维护，当前版本 v1.0.0。
推荐 Skills