recipe-log-deal-update
Append deal status updates to a Google Sheets sales tracking spreadsheet
by googleworkspaceFree
Description
recipe-log-deal-update is a recipe skill from the Google Workspace CLI project, listed on skills.sh. It adds a deal status update to a sales tracking spreadsheet. It finds the sheet by name, reading a Google Sheets file called Sales Pipeline, then reads the existing pipeline data so the new row fits the layout, and finally appends a new row with the date, company, status, amount, quarter and owner. The example adds an Acme Corp deal at the proposal stage for $50,000 in Q2, owned by one person. The recipe needs gws-sheets and gws-drive. Appending a row changes the shared sales sheet, so the values should be checked before the append runs. It suits a sales team that keeps its pipeline in a Google Sheet and wants each update recorded in the same format, without anyone retyping the row layout.…
Highlights
- Finds the Sales Pipeline sheet by name
- Reads the existing pipeline first
- Appends a row with status, amount and owner
- Needs gws-sheets and gws-drive
Ratings & Reviews
No ratings yet
Be the first to rate recipe-log-deal-update.
People also visit
recipe-copy-sheet-for-new-month
Duplicate a Google Sheets template tab for a new month of tracking
recipe-create-expense-tracker
Google Sheets spreadsheet template for expense tracking
recipe-generate-report-from-sheet
Extract Google Sheet data and generate a formatted Google Docs report
recipe-log-deal-update FAQ
What does this recipe do?
It appends a deal status row to a Sales Pipeline spreadsheet in Google Sheets.
How do I install it?
Run: npx skills add https://github.com/googleworkspace/cli --skill recipe-log-deal-update
What columns does the row include?
The example row has date, company, status, amount, quarter and owner.
Does it read the sheet before writing?
Yes. The recipe reads the existing pipeline data before appending the new row.
Has it been checked for security?
skills.sh lists three audits: Gen Agent Trust Hub Pass, Socket Pass and Snyk Pass.
What are the best recipe-log-deal-update alternatives?
Popular alternatives to recipe-log-deal-update include recipe-copy-sheet-for-new-month, recipe-create-expense-tracker and recipe-generate-report-from-sheet. See all recipe-log-deal-update alternatives