🌀 Automating Discóbolo – Full Walkthrough
Automates downloading bank transactions, updating master Excel files, and loading them into a web system.
💻 Step 1: Downloading the Excel File from Banco Provincia
The script uses Selenium to log into the bank and download the latest Excel with all transactions.
📊 Step 2: Updating the Master Excel
It compares "N° Secuencia" values to avoid duplicates and inserts new rows with
formatting
preserved.
🌐 Step 3: Loading Payments into Sytech
The script searches for each client and automatically registers the payment with the right method.
📨 Step 4: Sending emails with receipt
It sends an email to all users with the payment's receipt attached to it