This n8n workflow automates the process of recording financial transactions received via Telegram messages into a Google Sheets spreadsheet, enabling an efficient expense tracking system. When a new message arrives in Telegram, the workflow evaluates the message content, extracts relevant transaction details using pattern matching, and appends the data to a Google Sheets document, creating an organized record of expenses.
The workflow comprises several key nodes:
1. **Telegram Trigger:** Listens for new messages in a Telegram chat, serving as the entry point for incoming transaction data.
2. **Code Node:** Parses the message text with JavaScript, identifying one of three known transaction formats using regex patterns. It extracts key information such as the amount, merchant, card ending, date, time, and available limit.
3. **Conditional Filter (If node):** Checks if a message contains specific text, controlling whether to proceed with recording or ignore the message.
4. **Google Sheets Node:** Append the extracted transaction details into a designated Google Sheets spreadsheet, ensuring data persistence and easy access.
This workflow is particularly useful for individuals or small businesses wanting an automated way to log transactions sent via Telegram, thus simplifying expense management and financial tracking without manual data entry.
Reviews
There are no reviews yet.