Recipe Log Deal Update
Append a dated pipeline row to a Google Sheets sales tracker after a deal moves stage—without hand-editing the spreadsheet.
Install
npx skills add https://github.com/googleworkspace/cli --skill recipe-log-deal-updateWhat is this skill?
- 3-step recipe: locate Sales Pipeline sheet via Drive query, read current range, append a new row
- Uses gws drive files list with MIME filter for Google Spreadsheets
- Sheets +read on Pipeline!A1:F before append to preserve column context
- gws sheets +append with structured values: date, account, stage, amount, quarter, owner
- Prerequisites: gws-sheets and gws-drive skills loaded before execution
Adoption & trust: 15k installs on skills.sh; 26.9k GitHub stars; 3/3 security scanners passed (skills.sh audits).
Recommended Skills
Cold Emailcoreyhaines31/marketingskills
Pricing Strategycoreyhaines31/marketingskills
Sales Enablementcoreyhaines31/marketingskills
Revopscoreyhaines31/marketingskills
Paid Adscoreyhaines31/marketingskills
Referral Programcoreyhaines31/marketingskills
Journey fit
Primary fit
Deal stage updates are Grow lifecycle maintenance that keeps revenue visibility current after customer conversations. Lifecycle is the right shelf for append-only pipeline logging that feeds weekly reviews and forecast habits.
Common Questions / FAQ
Is Recipe Log Deal Update safe to install?
skills.sh reports 3 of 3 security scanners passed. Review the Security Audits panel on this page before installing in production.
SKILL.md
READMESKILL.md - Recipe Log Deal Update
# 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"]'`