Monitor Bank Transactions with Multi-Channel Alerts for Accounting Teams

This n8n workflow automates the process of monitoring bank transactions and sending multi-channel alerts to accounting teams based on predefined conditions. It simplifies the process of staying informed about critical financial activities, ensuring timely responses and improved financial oversight.

What it does

This workflow performs the following key steps:

1. Triggers on a Schedule: The workflow starts at scheduled intervals, allowing for regular checks of bank transactions.
2. Fetches Bank Transactions: It makes an HTTP request to an external API (presumably a bank's API or a financial data provider) to retrieve the latest transaction data.
3. Processes Transaction Data: A Code node is used to process and potentially transform the raw transaction data, preparing it for analysis.
4. Filters Transactions: An If node evaluates each transaction based on a defined condition (e.g., transaction amount, type, or recipient).
5. Sends Conditional Alerts:
   • If a transaction meets the specified condition (e.g., a high-value transaction or a suspicious activity), it sends an alert via Slack to the accounting team.
   • It also sends an Email notification for these specific transactions.
6. Logs All Transactions: Regardless of whether a transaction triggers an alert, all processed transactions are logged into a Google Sheet for auditing and record-keeping purposes.
7. Merges Paths: The workflow merges the different alert paths back together before the final logging step.

Prerequisites/Requirements

To use this workflow, you will need:

• Bank API Access: An API endpoint and credentials to fetch bank transaction data.
• Slack Account: A Slack workspace and a channel where alerts should be posted.
• SMTP Server/Email Service: Configuration for sending emails (e.g., an SMTP server or a transactional email service).
• Google Account: Access to Google Sheets to log transaction data.
• n8n Instance: A running instance of n8n.

Setup/Usage

1. Import the Workflow:
   • Copy the provided JSON code.
   • In your n8n instance, click "New" to create a new workflow.
   • Go to the "Workflows" menu, click "Import from JSON", and paste the copied JSON.
2. Configure Credentials:
   • HTTP Request (Node 19): Configure the HTTP Request node with the URL and authentication details for your bank's API or financial data source.
   • Slack (Node 40): Set up your Slack credential to allow n8n to post messages to your desired channel.
   • Send Email (Node 11): Configure your email credential (SMTP server details, username, password, etc.) to send email alerts.
   • Google Sheets (Node 18): Set up your Google Sheets credential, ensuring it has access to the target spreadsheet.
3. Customize Nodes:
   • Schedule Trigger (Node 839): Adjust the schedule to your desired frequency for checking transactions.
   • Code (Node 834): Modify the JavaScript code to parse and transform your specific bank transaction data structure.
   • If (Node 20): Define the conditions for filtering transactions that should trigger alerts. For example, {{ $json.amount > 1000 }} for transactions over $1000.
   • Slack (Node 40): Customize the message content and target channel for Slack alerts.
   • Send Email (Node 11): Customize the subject, body, and recipient email addresses for email alerts.
   • Google Sheets (Node 18): Specify the Spreadsheet ID, Sheet Name, and the data to be written for logging all transactions.
4. Activate the Workflow: Once all configurations are complete, activate the workflow to start monitoring your bank transactions.