Recipe Create Expense Tracker
googleworkspace/cliThis skill helps users quickly set up a Google Sheets expense tracker by creating a spreadsheet, adding headers and initial entries, and sharing access with others. It automates the process using CLI commands for creating files, appending data, and managing permissions. Ideal for users seeking an efficient way to manage and track expenses within Google Workspace, especially those comfortable with command-line interfaces.
Create a Google Sheets Expense Tracker
PREREQUISITE: Load the following skills to execute this recipe:
gws-sheets,gws-driveSet up a Google Sheets spreadsheet for tracking expenses with headers and initial entries.
Steps
- Create spreadsheet:
gws drive files create --json '{"name": "Expense Tracker 2025", "mimeType": "application/vnd.google-apps.spreadsheet"}' - Add headers:
gws sheets +append --spreadsheet SHEET_ID --range 'Sheet1' --values '["Date", "Category", "Description", "Amount"]' - Add first entry:
gws sheets +append --spreadsheet SHEET_ID --range 'Sheet1' --values '["2025-01-15", "Travel", "Flight to NYC", "450.00"]' - Share with manager:
gws drive permissions create --params '{"fileId": "SHEET_ID"}' --json '{"role": "reader", "type": "user", "emailAddress": "manager@company.com"}'
GitHub Owner
Owner: googleworkspace
GitHub Links
- Website: https://developers.google.com/workspace
- Twitter: https://twitter.com/workspacedevs
SKILL.md
name: recipe-create-expense-tracker version: 1.0.0 description: "Set up a Google Sheets spreadsheet for tracking expenses with headers and initial entries." metadata: openclaw: category: "recipe" domain: "productivity" requires: bins: ["gws"] skills: ["gws-sheets", "gws-drive"]
Create a Google Sheets Expense Tracker
PREREQUISITE: Load the following skills to execute this recipe:
gws-sheets,gws-driveSet up a Google Sheets spreadsheet for tracking expenses with headers and initial entries.
Steps
- Create spreadsheet:
gws drive files create --json '{"name": "Expense Tracker 2025", "mimeType": "application/vnd.google-apps.spreadsheet"}' - Add headers:
gws sheets +append --spreadsheet SHEET_ID --range 'Sheet1' --values '["Date", "Category", "Description", "Amount"]' - Add first entry:
gws sheets +append --spreadsheet SHEET_ID --range 'Sheet1' --values '["2025-01-15", "Travel", "Flight to NYC", "450.00"]' - Share with manager:
gws drive permissions create --params '{"fileId": "SHEET_ID"}' --json '{"role": "reader", "type": "user", "emailAddress": "manager@company.com"}'