360 Secure SkillHub
360 安全技能中心

recipe-log-deal-update

该 Skill 通过 gws 命令搜索 Google Drive 中的 Sales Pipeline 表格,读取 Pipeline 工作表,并追加一条交易状态记录;依赖 gws CLI 以及 gws-sheets、gws-drive 技能。

googleworkspace
热度 72.97
最近更新 2026-10-18 17:15:33
分类:自动化依赖:代码执行 / 第三方 API应用场景:CRM / 工作流

安装技能

复制下面的话术发给你的 Agent,它会通过 secure-skills 检索并安装该技能。

执行命令安装此 skill: npx secure-skills-cli add googleworkspace/cli/recipe-log-deal-update
Metadata
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"]'