This n8n workflow automates the process of monitoring credit card transaction alerts sent via Gmail, extracting transaction details, and notifying users via Telegram. It also keeps a running log of transactions in a Google Sheet for tracking and analysis. The workflow is particularly useful for individuals or businesses who want real-time updates and organized transaction records without manual effort.

The process begins with a Gmail trigger that periodically polls for new emails from HDFC Bank InstaAlerts. When a relevant email is received, the workflow extracts the email snippet and processes it through custom code nodes to pull the transaction amount, recipient, date, and UPI reference number.

The extracted information is then used to notify designated Telegram channels or contacts with a formatted message containing transaction details, ensuring immediate awareness of each transaction. Simultaneously, the workflow checks whether the email has already been logged (using email IDs), filters out duplicate entries, and updates a Google Sheet to maintain a comprehensive log of all transactions.

This workflow can be invaluable for personal finance management, business expense tracking, or enhancing security by providing instant notifications of card activity. Its automation reduces manual effort and improves accuracy and timeliness of financial updates.