Automate income and expense tracking in Google Sheets via Telegram

Who’s it for This template is perfect for freelancers, small business owners, or financial assistants who want to record and approve financial transactions like income and expenses directly from Telegram, without opening a spreadsheet manually.

It’s also useful for teams that require a supervisor to approve expenses before they’re finalized.

What it does This workflow allows users to:

- Start a conversation via Telegram using the /start command. - Choose to record an income or expense. - Submit transaction data using a structured format. - Store the data into Google Sheets in real time. - For expenses, automatically notify a supervisor for approval. - The supervisor can Approve ✅, Reject ❌, or View Details 👁. - Sends feedback to the user based on supervisor action.

🔧 How it works

1. Telegram Bot Trigger: Captures user input via message or inline button callback. 2. Message Detection Logic: Differentiates between text input and button interactions. 3. Switch Node: Routes the message type: - /start: Displays income/expense buttons. - Input text: Validates formatting and parses data. - Callback: Handles approval/rejection process.

4. Google Sheets Integration: Appends or updates entries in different sheets based on the data type.

5. Notifications: