Generated banner for Recipe Create Expense Tracker
Generated logo for Recipe Create Expense Tracker

Recipe Create Expense Tracker

Google WorkspaceOfficialPublished by Google Workspace

  • Skill
  • Workflow
  • Business and productivity
  • Apache-2.0
  • No issues found

From the author

Set up a Google Sheets spreadsheet for tracking expenses with headers and initial entries.
— the description by Google Workspace

AutoGineer summary

Written by AutoGineer from the skill’s own files, not by the author

This skill provides a structured workflow to initialize a new Google Sheets document specifically for expense tracking. It handles the creation of the file, populates it with standard financial headers, adds an initial sample entry, and configures sharing permissions for a manager, streamlining the setup process for personal or team financial monitoring.

What it does

  • Creates a new Google Sheets file titled Expense Tracker 2025.
  • Automatically inserts standard expense headers: Date, Category, Description, and Amount.
  • Populates the spreadsheet with an initial sample expense entry.
  • Sets up file sharing permissions to grant read access to a specified manager email address.

When to use it

  • When you need to quickly set up a new expense tracking system for a project or department.
  • When you want to standardize expense reporting formats across a team.
  • When you need to automate the creation of financial logs within a Google Workspace environment.

Advantages

  • Reduces manual setup time for new tracking documents.
  • Ensures consistent data structure across expense reports.
  • Automates the integration of sharing permissions to maintain visibility.

Usage examples

“Create a new expense tracker for me.”
The agent will create a new Google Sheet, add the required headers, insert a sample row, and share the document with your manager.

Install

  1. Download the skill as a ZIP:

    https://autogineer.com/agent-skills/googleworkspace/recipe-create-expense-tracker/download
  2. Unzip it into the cross-client skills folder of your project:

    mkdir -p .agents/skills && unzip recipe-create-expense-tracker.zip -d .agents/skills

Documentation by Google Workspace

Create a Google Sheets Expense Tracker

PREREQUISITE: Load the following skills to execute this recipe: gws-sheets, gws-drive

Set up a Google Sheets spreadsheet for tracking expenses with headers and initial entries.

Steps

  1. Create spreadsheet: gws drive files create --json '{"name": "Expense Tracker 2025", "mimeType": "application/vnd.google-apps.spreadsheet"}'

  2. Add headers: gws sheets +append --spreadsheet SHEET_ID --range 'Sheet1' --values '["Date", "Category", "Description", "Amount"]'

  3. Add first entry: gws sheets +append --spreadsheet SHEET_ID --range 'Sheet1' --values '["2025-01-15", "Travel", "Flight to NYC", "450.00"]'

  4. Share with manager: gws drive permissions create --params '{"fileId": "SHEET_ID"}' --json '{"role": "reader", "type": "user", "emailAddress": "[email protected]"}'

Files

Requirements and compatibility

Works with: Claude Code, Claude apps, OpenAI Codex, GitHub Copilot, Cursor, Gemini CLI, Kiro, OpenCode, Goose, Amp, Roo Code, JetBrains Junie, Factory Droid, Devin (ex-Windsurf), Mistral Vibe, OpenHands, Letta

“Works with” means the tool reads the open Agent Skills format; a skill written for one tool may use features others lack.

Security

No issues found by our static scan· No issues found

A static scan is not a guarantee. Skills are third-party content: review a skill before you let an agent use it.

Attribution and licence

Published by
Google Workspace
Publisher
Google Workspace (Official)
Source
googleworkspace/cli · skills/recipe-create-expense-tracker · commit cd3697e
Licence
Apache License 2.0 (redistribution allowed)
  • LICENSE (added by AutoGineer from LICENSE)
  • ATTRIBUTION.md (written by AutoGineer)
Synced

AutoGineer is not affiliated with or endorsed by Google Workspace or Google Workspace.

Download ZIP

The ZIP holds the skill’s files, its licence files and an ATTRIBUTION.md. Download recipe-create-expense-tracker.zip