googleworkspace avatar

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-code

Installs 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

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

Sponsors

Details

Repository
github.com/googleworkspace/cli
Categories
Sales & Marketing, CLI & Terminal, Office & Documents

More from googleworkspace/cli

All 113
1getcargohq avatarcargo-gtmgetcargohq/cargo-skillsFront door for any GTM task on Cargo — sourcing, waterfall enrichment, email/phone/LinkedIn lookup, email verification, scoring, qualification, sequencing, CRM 11.2Kskills.sh installs
2paramchoudhary avatarcold-email-writerparamchoudhary/resumeskillsWrite personalized cold outreach emails to hiring managers and founders — specific, human, not a pitch deck7.5Kskills.sh installs
3composiohq avatarlead-research-assistantcomposiohq/awesome-claude-skillsIdentifies high-quality leads for your product or service by analyzing your business, searching for target companies, and providing actionable contact strategie5.7Kskills.sh installs
4anthropics avatardraft-outreachanthropics/knowledge-work-pluginsResearch a prospect then draft personalized outreach. Uses web research by default, supercharged with enrichment and CRM. Trigger with "draft outreach to [perso3.4Kskills.sh installs
5phuryn avatargtm-strategyphuryn/pm-skillsCreate a go-to-market strategy covering marketing channels, messaging, success metrics, and launch timeline. Use when planning a product launch, creating a GTM 3.3Kskills.sh installs
6anthropics avatarpipeline-reviewanthropics/knowledge-work-pluginsAnalyze pipeline health — prioritize deals, flag risks, get a weekly action plan. Use when running a weekly pipeline review, deciding which deals to focus on th2.9Kskills.sh installs