---
id: ssh2-recipe-log-deal-update
name: "recipe-log-deal-update"
url: https://skills.yangsir.net/skill/ssh2-recipe-log-deal-update
author: googleworkspace
domain: sales
tags: ["crm-integration", "sales-tracking", "deal-management", "google-sheets", "sales-automation"]
install_count: 14200
rating: 4.50 (140 reviews)
github: https://github.com/googleworkspace/cli
---

# recipe-log-deal-update

> 将交易状态更新信息追加到Google表格中的销售跟踪表，保持记录最新。

**Stats**: 14,200 installs · 4.5/5 (140 reviews)

## Before / After 对比

### 销售交易状态更新自动化记录，确保数据实时同步，大幅提升销售管理效率。

## Readme

# 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"]'`



---
*Source: https://skills.yangsir.net/skill/ssh2-recipe-log-deal-update*
*Markdown mirror: https://skills.yangsir.net/api/skill/ssh2-recipe-log-deal-update/markdown*