SkillsSKILLS
Productivity

recipe-create-expense-tracker▌

googleworkspace/cli · updated Apr 8, 2026

$npx skills add https://github.com/googleworkspace/cli --skill recipe-create-expense-tracker
summary

Google Sheets spreadsheet template for expense tracking with automated setup and sharing.

  • ›Creates a new spreadsheet with standard expense columns (Date, Category, Description, Amount) and sample entries
  • ›Includes built-in sharing capabilities to grant read or edit access to team members via email
  • ›Requires gws-sheets and gws-drive skills; uses Google Workspace APIs for spreadsheet and file management
skill.md

1d:["$","div",null,{"className":"prose prose-invert max-w-none prose-headings:font-semibold prose-headings:tracking-tight prose-h1:text-4xl prose-h1:mb-2 prose-h2:text-2xl prose-h2:mb-2 prose-h3:text-lg prose-h3:mb-2 prose-p:text-muted-foreground prose-li:text-muted-foreground prose-code:bg-muted prose-code:text-foreground prose-code:px-1 prose-code:py-0.5 prose-code:rounded-sm prose-code:text-sm prose-code:before:content-none prose-code:after:content-none prose-pre:bg-muted prose-pre:text-foreground prose-pre:border prose-pre:border-border prose-pre:rounded-md [&_table]:!border-[color:var(--border)] [&_th]:!border-[color:var(--border)] [&_td]:!border-[color:var(--border)]","dangerouslySetInnerHTML":{"__html":"<h1>Create a Google Sheets Expense Tracker</h1>\n<blockquote>\n<p><strong>PREREQUISITE:</strong> Load the following skills to execute this recipe: <code>gws-sheets</code>, <code>gws-drive</code></p>\n</blockquote>\n<p>Set up a Google Sheets spreadsheet for tracking expenses with headers and initial entries.</p>\n<h2>Steps</h2>\n<ol>\n<li>Create spreadsheet: <code>gws drive files create --json '{"name": "Expense Tracker 2025", "mimeType": "application/vnd.google-apps.spreadsheet"}'</code></li>\n<li>Add headers: <code>gws sheets +append --spreadsheet SHEET_ID --range 'Sheet1' --values '["Date", "Category", "Description", "Amount"]'</code></li>\n<li>Add first entry: <code>gws sheets +append --spreadsheet SHEET_ID --range 'Sheet1' --values '["2025-01-15", "Travel", "Flight to NYC", "450.00"]'</code></li>\n<li>Share with manager: <code>gws drive permissions create --params '{"fileId": "SHEET_ID"}' --json '{"role": "reader", "type": "user", "emailAddress": "manager@company.com"}'</code></li>\n</ol>"}}]