Zum Inhalt springen
NEUMarktplatz und trig8n Agent: Verkaufen Sie, was Sie bauen, und erhalten Sie Pläne und Änderungen, die getestet sind, bevor Sie sie sehen. Neuigkeiten ansehen

Bibliothek / Finanzen, Rechnungen & Buchhaltung

Finanzen, Rechnungen & Buchhaltung

Persönliche Ausgaben-Tracker-API mit Google Sheets

Geht per Webhook eine Ausgabe ein, validiert und formatiert der Workflow sie, speichert sie in Google Sheets, berechnet die Monatszusammenfassung und antwortet.

Was sie bewirkt

# 💰 Personal Expense Tracker API ## What This Workflow Does Provides a complete expense tracking system with webhook API for adding expenses and automatic Google Sheets storage with daily summaries. ## How It Works 1. API Endpoint: Receives expenses via POST webhook 2. Data Validation: Ensures proper format and categories 3. Google Sheets Storage: Automatically saves to spreadsheet 4. Daily Reports: Sends summary at 8 PM daily 5. Real-time Responses: Returns success/error immediately ## API Usage Send POST to: /webhook/add-expense json { "amount": 25.50, "category": "Food", "description": "Lunch at cafe", "payment_method": "Credit Card" } ## Categories • Food • Transport • Shopping • Bills • Entertainment • Health • Other ## Setup Required 1. Create Google Sheets with 'Expenses' sheet 2. Headers: Date | Category | Description | Amount | Payment Method 3. Replace SPREADSHEET_ID in nodes 4. Connect Google Sheets OAuth2 5. Activate workflow ## Perfect For ✅ Personal finance tracking ✅ Mobile app integration ✅ Family expense sharing ✅ Small business expense logging Includes automatic validation, error handling, and daily summaries.

Die Schritte

  1. Expense Input Webhook
  2. Validate and Format Expense Data
  3. Save Expense to Google Sheets
  4. Calculate Monthly Summary
  5. Send Success Response
  6. Send Error Response
  7. Daily Summary Schedule
  8. Read Today's Expenses from Sheet
  9. Calculate Daily Total

Ähnliche Automatisierungen