recipe-log-deal-update
Append deal status updates to a sales tracking sheet in Google Sheets, keeping records up-to-date.
npx skills add googleworkspace/cli --skill recipe-log-deal-updateBefore / After Comparison
1 组Whenever a sales transaction status changed, I had to manually open the sales tracking sheet in Google Sheets, find the corresponding transaction row, and then enter the updated information cell by cell. This process was cumbersome and prone to errors, especially easy to miss updates during busy periods.
Now, with just a simple command, the system automatically appends the latest transaction status updates accurately to the sales tracking sheet in Google Sheets, ensuring real-time data synchronization and greatly improving the sales team's data management efficiency and accuracy.
description SKILL.md
name: recipe-log-deal-update version: 1.0.0 description: "Append a deal status update to a Google Sheets sales tracking spreadsheet." metadata: 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
- 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"]'
forumUser Reviews (0)
Write a Review
No reviews yet
Statistics
User Rating
Rate this Skill