Claude
Skills
Sign in
Back

recipe-log-deal-update

Included with Lifetime
$97 forever

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

Data & Analytics

What this skill does


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

Files: 1
Size: 0.9 KB
Complexity: 8/100
Category: Data & Analytics

Related in Data & Analytics