先看看示例
作者提供的示例,实际效果取决于你的输入和使用工具。
输入
把今天 Acme Corp 进入报价阶段、金额 5 万美元、Q2、负责人 jdoe 的记录追加到销售管道表。
输出
预期交付:在 Pipeline 工作表中新增的一行成交状态记录。(编辑说明,非实际运行结果)
方法说明
---
name: recipe-log-deal-update
description: "Append a deal status update to a Google Sheets sales tracking spreadsheet."
metadata:
version: 0.22.5
openclaw:
category: "recipe"
domain: "sales"
requires:
bins:
- gws
skills:
- gws-sheets
- gws-drive
---
# Log Deal Update to Sheet
> **PREREQUISITE:** Load the following skills to execute this recipe: `gws-sheets`, `gws-drive`
Append a deal status update to a Google Sheets sales tracking spreadsheet.
## Steps
1. Find the tracking sheet: `gws drive files list --params '{"q": "name = '\''Sales Pipeline'\'' and mimeType = '\''application/vnd.google-apps.spreadsheet'\''"}'`
2. Read current data: `gws sheets +read --spreadsheet SHEET_ID --range "Pipeline!A1:F"`
3. Append new row: `gws sheets +append --spreadsheet SHEET_ID --range 'Pipeline' --values '["2024-03-15", "Acme Corp", "Proposal Sent", "$50,000", "Q2", "jdoe"]'`