recipe-log-deal-update

Vercel

All-time installs

26.8K

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

Install

Other options

Summary

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

Raw SKILL.md

933 bytes

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

Security audits

SnykPASS

SocketPASS

Gen Agent Trust HubPASS