RSReandy Setiawan
← Back to Selected WorkNext Project

Case Study

BCA Transaction Tracking Automation

AI Workflow2025
BCA Transaction Tracking Automation case study thumbnail
BCA n8n workflow — Gmail trigger to Google Sheets and webhook API
BCA Finance Dashboard Insight — spending trends and category distribution

Project Overview

The assignment and delivery scope.

Designed an end-to-end BCA transaction tracking system: Gmail trigger detects new bank emails, data is parsed and cleaned, saved to Google Sheets, and pushed to Telegram. A webhook mini-API then serves filtered JSON to a finance dashboard for spending trends and category distribution.

Role: Automation Workflow Designer

Deliverables: Gmail → Sheets → Telegram workflow, Webhook API for dashboard data, Finance dashboard data pipeline

Tools: n8n, Gmail, Google Sheets, Telegram, JavaScript

External Proof:

LinkedIn — BCA automation proof

Overview

What this project had to achieve.

  • Automatic capture of BCA transaction emails
  • Instant Telegram notifications for new activity
  • Dashboard-ready JSON via webhook for spend tracking

Trigger

Gmail / BCA email

Storage

Google Sheets

Notify

Telegram + Dashboard