360 Secure SkillHub
360 安全技能中心

Recipe Log Deal Update

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

googleworkspace-bot
googleworkspace-bot
热度 73.07
最近更新 2026-05-11 17:31:42
分类:自动化依赖:代码执行 / 第三方 API应用场景:CRM / 工作流

安装技能

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

执行命令安装此 skill: npx secure-skills-cli add 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"]'