Personal Expense Tracker: Webhook to Google Sheets

This n8n workflow automates personal expense tracking by listening for POST requests on a webhook endpoint. Incoming data—including date, category, description, amount, and payment method—is validated and formatted using a custom function node. Invalid amounts or categories trigger errors, ensuring data integrity. Valid expenses are then appended to a designated Google Sheet, providing a centralized, searchable log.

A scheduled trigger runs daily at 8 PM to aggregate the day's or week's expenses, calculate totals by category, and generate a concise financial summary. This report can be emailed or shared via integrations like Telegram or Slack. Automatic categorization from predefined options (Food, Transport, Shopping, etc.) simplifies organization without manual tagging.

Benefits include massive time savings on manual logging, real-time expense capture from mobile apps/scripts/forms, and insightful summaries for better budgeting. Setup takes 10-15 minutes: create a Google Sheet, configure credentials, set the webhook URL, and customize categories if needed.

Use cases span personal finance for households monitoring groceries and bills, freelancers logging client reimbursables, or travelers tracking trip costs—all without dedicated apps, leveraging n8n's power for seamless automation.