recipe-log-deal-update
Append a deal status update to a Google Sheets sales tracking spreadsheet.
Only events from users who opted in to optional analytics are recorded. Views are deduplicated by account, Skill, and Shanghai calendar day. Downloads are deduplicated by account, Skill, version, and Shanghai calendar day; a count means the client successfully delivered the package, not that it was saved to disk. Installs are recorded only after the client successfully writes the Skill, and are deduplicated per account and Skill for 90 days. Withdrawing consent clears personal deduplication records, so an install after opting in again may count again. “This week” means the last 7 Shanghai calendar days. Favorites show the current total.
Skill steps
---
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"]'`
Version history
Published versions remain available for verification and restoration.
Imported from googleworkspace/cli@ZIP c7094cd9f725caab6c54b1c016f3f1737d82a26baf623ffdc00be833557a78a4