recipe-log-deal-update

$npx mdskill add googleworkspace/cli/recipe-log-deal-update

Append a deal status update to a Google Sheets sales tracking spreadsheet.

  • Logs a new deal update row to a sales pipeline sheet.
  • Depends on Google Workspace Sheets and Drive APIs.
  • Finds the sheet by name and reads current data to determine append location.
  • Appends a new row with date, company, stage, value, quarter, and owner.

SKILL.md

.github/skills/recipe-log-deal-updateView on GitHub ↗
---
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"]'`

More from googleworkspace/cli

SkillDescription
gws-admin-reportsGoogle Workspace Admin SDK: Audit logs and usage reports.
gws-calendarGoogle Calendar: Manage calendars and events.
gws-calendar-agendaGoogle Calendar: Show upcoming events across all calendars.
gws-calendar-insertGoogle Calendar: Create a new event.
gws-chatGoogle Chat: Manage Chat spaces and messages.
gws-chat-sendGoogle Chat: Send a message to a space.
gws-classroomGoogle Classroom: Manage classes, rosters, and coursework.
gws-docsRead and write Google Docs.
gws-docs-writeGoogle Docs: Append text to a document.
gws-driveGoogle Drive: Manage files, folders, and shared drives.