
Recipe Log Deal Update
A straightforward recipe for logging sales deal updates directly to Google Sheets without opening a browser. It searches for your "Sales Pipeline" spreadsheet by name, reads the current data to understand the structure, then appends a new row with deal details like date, company, status, value, and owner. Good for automating CRM updates from the command line or integrating deal tracking into existing workflows. The three-step approach is simple but assumes you follow a specific sheet naming convention and column layout, so you'll need consistent spreadsheet structure across your sales team.
- skills.sh installs
- 30.2K
- GitHub stars
- 32.2K
- last updated
- Aug 21, 2026
Install
$ npx -y skills add googleworkspace/cli --skill recipe-log-deal-update --agent claude-codeInstalls into .claude/skills of the current project.
Files
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
- Find the tracking sheet:
gws drive files list --params '{"q": "name = '\''Sales Pipeline'\'' and mimeType = '\''application/vnd.google-apps.spreadsheet'\''"}' - Read current data:
gws sheets +read --spreadsheet SHEET_ID --range "Pipeline!A1:F" - Append new row:
gws sheets +append --spreadsheet SHEET_ID --range 'Pipeline' --values '["2024-03-15", "Acme Corp", "Proposal Sent", "$50,000", "Q2", "jdoe"]'
Sponsors
Details
- Repository
- github.com/googleworkspace/cli
- Categories
- Sales & Marketing, CLI & Terminal, Office & Documents
More from googleworkspace/cli
All 113- Recipe Create Classroom Course30K
- Gws Script27.3K
- Gws Script Push26.7K
- Gws Admin670
- Recipe Batch Rename Files634
- Gws Apps Script629
- Recipe Cancel And Notify624
- Recipe Batch Reply To Emails621
- Gws Apps Script Push620
- Recipe Send Personalized Emails620
- Recipe Search And Export Emails619
- Recipe Audit External Sharing602
- Gws Groupssettings598
- Recipe Deploy Apps Script596
- Recipe Triage Security Alerts583
- Recipe Transfer File Ownership582
- Gws Alertcenter570
- Gws Cloudidentity568
- Gws Vault563
- Gws Licensing552
- Gws Reseller541
- Gws Gmail84.3K
- Gws Drive76.5K
- Gws Gmail Send76.1K