skills.rest
oresttokovenko
oresttokovenkoCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

recipe-create-expense-tracker

Creates a Google Sheets expense tracker with headers, initial entries, and sharing permissions.

Updated Nov 9, 2023
Search Tags:#automation#finance#spreadsheet#google sheets#google drive#gws#expense tracker
One-click install
npx skills add https://github.com/oresttokovenko/dot-files --skill recipe-create-expense-tracker-oresttokovenko
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: recipe-create-expense-tracker
Source: https://github.com/oresttokovenko/dot-files/tree/main/chezmoi/dot_agents/skills/recipe-create-expense-tracker
Command: npx skills add https://github.com/oresttokovenko/dot-files --skill recipe-create-expense-tracker-oresttokovenko

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve? Setting up a structured expense tracking spreadsheet manually involves repetitive steps: creating the file, defining column headers, entering seed data, and configuring sharing. This Skill automates the entire setup through the Google Workspace CLI. ## Core Features & Use Cases - Spreadsheet Creation: Creates a new Google Sheets file named "Expense Tracker 2025" via the Google Drive API. - Structured Headers and Entries: Appends Date, Category, Description, and Amount columns plus an initial sample expense row. - Sharing Configuration: Grants reader access to a specified email address such as a manager. - Use Case: A team lead needs a shared expense log for Q1; run this recipe to produce a ready-to-use spreadsheet with headers, a sample entry, and manager access in one pass. ## Quick Start Create a Google Sheets expense tracker for 2025 with standard columns and share it with my manager.

Frequently Asked Questions about recipe-create-expense-tracker

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I create a Google Sheets expense tracker from the command line?▼

Use the gws CLI to create a spreadsheet with gws drive files create, then append header and data rows with gws sheets +append. This recipe chains those commands into a single guided workflow.

How do I share a Google Sheet with a specific user via API?▼

Use gws drive permissions create with the file ID and a JSON body specifying role, type, and emailAddress. This recipe grants reader access to a manager email address as the final step.

What tools are required to run this expense tracker recipe?▼

The gws command-line tool must be installed, and the gws-sheets and gws-drive skills must be loaded beforehand. These provide the Drive and Sheets API operations used in each step.

Can I customize the columns or sheet name in the expense tracker?▼

Yes, the values passed to gws sheets +append and the name in gws drive files create are plain parameters. Edit the JSON payloads to change headers, the spreadsheet title, or the sample entry.

Why does the spreadsheet creation step fail with gws?▼

Failures typically come from missing authentication or the gws-sheets and gws-drive skills not being loaded. Verify the gws CLI is authorized against your Google account and that prerequisite skills are active.

Related Skills

Explore More Finance & Accounting Skills→
lengoctuong2005lengoctuong2005
5

google-workspace

Access Google Workspace services via gws CLI or Python.

Community
Intermediate
hmzainjamilhmzainjamil
1

Expense Tracker

Extract receipt data, categorize expenses, and generate reimbursement reports.

Community
Advanced
zachyzachy

reconcile

Reconcile bank transactions against PDF statements and generate HTML reports.

Community
Advanced
m13vm13v
312

recipe-create-expense-tracker

Create and configure a Google Sheets expense tracker with headers and sample data.

Community
Basic