Recipe Log Deal Update

by googleworkspacea3768d0e82adNo license31K starsListed Oct 8, 2026Updated Oct 8, 2026Repository updated yesterday

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

AI-generated overview

Appends a deal status update row to a Google Sheets sales tracking spreadsheet.

What it does: This recipe locates a Google Sheets spreadsheet named Sales Pipeline, reads the existing Pipeline range, and appends a new deal status row with fields such as date, company, stage, amount, quarter, and owner. It produces an updated tracking spreadsheet row rather than a separate file.
When to use it: Use it when a sales deal changes stage or status and the update needs to be recorded in the shared Google Sheets pipeline tracker. It suits teams that keep deal tracking in Google Sheets and want a repeatable append step.
Requirements: Requires the gws command-line tool plus the gws-sheets and gws-drive skills, and access to the target Google Sheets spreadsheet. It ships no scripts; it is instructions only.

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.

Find the tracking sheet: gws drive files list --params '{"q": "name = '\''Sales Pipeline'\'' and mimeType = '\''application/vnd.google-apps.spreadsheet'\''"}'
Read current data: gws sheets +read --spreadsheet SHEET_ID --range "Pipeline!A1:F"
Append new row: gws sheets +append --spreadsheet SHEET_ID --range 'Pipeline' --values '["2024-03-15", "Acme Corp", "Proposal Sent", "$50,000", "Q2", "jdoe"]'

License: No license

Content belongs to its original authors. SourceWeft indexes it from a public repository.