Skill

SkillsBusiness & Commerce › Sales & CRM

recipe-log-deal-update

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

Freerisk: low
recipelogdeal

The full skill

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