recipe-log-deal-update

Append deal status updates to a Google Sheets sales tracking spreadsheet. Requires gws-sheets and gws-drive skills to locate and modify the Sales Pipeline sheet Workflow: find the tracking sheet by name, read existing pipeline data, then append new deal rows with date, company, status, amount, quarter, and owner fields Integrates with Google Drive and Sheets APIs to maintain a centralized sales pipeline log

INSTALLATION
npx skills add https://github.com/googleworkspace/cli --skill recipe-log-deal-update
Run in your project or agent environment. Adjust flags if your CLI version differs.

SKILL.md

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"]'
BrowserAct

Let your agent run on any real-world website

Bypass CAPTCHA & anti-bot for free. Start local, scale to cloud.

Explore BrowserAct Skills →

Stop writing automation&scrapers

Install the CLI. Run your first Skill in 30 seconds. Scale when you're ready.

Start free
free · no credit card