# Recipe Log Deal Update

> Append a deal status update to a Google Sheets sales tracking spreadsheet.

Source: https://skillsagentes.com/skills/googleworkspace/cli/recipe-log-deal-update
Repository: https://github.com/googleworkspace/cli
Author: googleworkspace
License: Apache-2.0
Updated: hace 4 meses
Context cost: 19 tok installed, 233 tok once triggered, 233 tok with every bundled file
Bundle: 1 file, 933 B
Permissions requested: none declared

## Install

```bash
npx -y skills add googleworkspace/cli --skill recipe-log-deal-update --agent claude-code
```

## What it does

- Busca la hoja 'Sales Pipeline' en Google Drive con gws drive files list
- Lee el rango actual de datos con gws sheets +read
- Añade una nueva fila con la actualización del trato usando gws sheets +append

## Use it when

- Necesitas registrar una actualización de estado de un trato en una hoja de seguimiento de ventas en Google Sheets

## What triggers it

- "Registra que Acme Corp pasó a 'Proposal Sent' por $50,000 en la hoja de Sales Pipeline"
- "Añade una fila al Sales Pipeline con el estado actual del trato de jdoe"

## Before you install

- Requiere el binario gws y tener cargadas las skills gws-sheets y gws-drive.

## Files

- SKILL.md — 933 B

## SKILL.md

Reproduced verbatim from googleworkspace/cli under Apache-2.0. This section is the upstream document and is in English.

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

---

Skills Agentes — https://skillsagentes.com/skills/googleworkspace/cli/recipe-log-deal-update