跳到主要内容
哒哒星球DADA PLANET

Skill · 已公开版本

recipe-log-deal-update · 销售管道表格追加成交进展

在 Google Sheets 销售跟踪表中查找管道表、读取现有数据,并追加一行成交状态更新记录。

先看看示例

作者提供的示例,实际效果取决于你的输入和使用工具。

输入

把今天 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"]'`