π¦ ClawHub
Recipe Log Deal Update
by @googleworkspace-bot
Append a deal status update to a Google Sheets sales tracking spreadsheet.
TERMINAL
clawhub install recipe-log-deal-updateπ About This 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"]'