recipe-log-deal-update▌
googleworkspace/cli · updated Apr 8, 2026
Append deal status updates to a Google Sheets sales tracking spreadsheet.
- ›Requires gws-sheets and gws-drive skills to locate and modify the Sales Pipeline sheet
- ›Workflow: find the tracking sheet by name, read existing pipeline data, then append new deal rows with date, company, status, amount, quarter, and owner fields
- ›Integrates with Google Drive and Sheets APIs to maintain a centralized sales pipeline log
1d:["$","div",null,{"className":"prose prose-invert max-w-none prose-headings:font-semibold prose-headings:tracking-tight prose-h1:text-4xl prose-h1:mb-2 prose-h2:text-2xl prose-h2:mb-2 prose-h3:text-lg prose-h3:mb-2 prose-p:text-muted-foreground prose-li:text-muted-foreground prose-code:bg-muted prose-code:text-foreground prose-code:px-1 prose-code:py-0.5 prose-code:rounded-sm prose-code:text-sm prose-code:before:content-none prose-code:after:content-none prose-pre:bg-muted prose-pre:text-foreground prose-pre:border prose-pre:border-border prose-pre:rounded-md [&_table]:!border-[color:var(--border)] [&_th]:!border-[color:var(--border)] [&_td]:!border-[color:var(--border)]","dangerouslySetInnerHTML":{"__html":"<h1>Log Deal Update to Sheet</h1>\n<blockquote>\n<p><strong>PREREQUISITE:</strong> Load the following skills to execute this recipe: <code>gws-sheets</code>, <code>gws-drive</code></p>\n</blockquote>\n<p>Append a deal status update to a Google Sheets sales tracking spreadsheet.</p>\n<h2>Steps</h2>\n<ol>\n<li>Find the tracking sheet: <code>gws drive files list --params '{"q": "name = '\''Sales Pipeline'\'' and mimeType = '\''application/vnd.google-apps.spreadsheet'\''"}'</code></li>\n<li>Read current data: <code>gws sheets +read --spreadsheet SHEET_ID --range "Pipeline!A1:F"</code></li>\n<li>Append new row: <code>gws sheets +append --spreadsheet SHEET_ID --range 'Pipeline' --values '["2024-03-15", "Acme Corp", "Proposal Sent", "$50,000", "Q2", "jdoe"]'</code></li>\n</ol>"}}]