Append a deal status update to a Google Sheets sales tracking spreadsheet.
Copy the command definition below into:
~/.claude/commands/recipe-log-deal-update-davila7.md---
allowed-tools: Bash, Read, Write, Edit
argument-hint: [task-parameters]
description: Append a deal status update to a Google Sheets sales tracking spreadsheet.
---
# Log Deal Update
Execute Google Workspace workflow: $ARGUMENTS
# 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-id SHEET_ID --range 'Pipeline!A1:F'`
3. Append new row: `gws sheets +append --spreadsheet-id SHEET_ID --range 'Pipeline' --values '["2024-03-15", "Acme Corp", "Proposal Sent", "$50,000", "Q2", "jdoe"]'`
## Task
Execute this workflow with the following parameters: $ARGUMENTS
1. **Prerequisites Check**
- Verify `gws` CLI is installed: `gws --version`
- Confirm authentication: `gws auth status`
- Load required GWS skills (check PREREQUISITE section above)
2. **Parameter Preparation**
- Parse task parameters from $ARGUMENTS
- Validate required inputs
- Prepare JSON payloads and flags
3. **Execute Workflow Steps**
- Follow the steps outlined above
- Replace placeholder IDs with actual values
- Handle errors and retries
- Log progress and results
4. **Verify Results**
- Confirm each step completed successfully
- Verify changes in Google Workspace
- Report final status and any issues
## Tips
- Use `--dry-run` flag when available to preview changes
- Always inspect API schemas before calling: `gws schema <service>.<resource>.<method>`
- Check command help for all flags: `gws <service> <resource> <method> --help`
---
**License**: Apache License 2.0
**Source**: [Google Workspace CLI](https://github.com/googleworkspace/cli)
**Original Skill**: `recipe-log-deal-update`