Daily Cash Position (Bank Statements in Google Drive)
Every workday morning, reads the bank statement files saved in a Google Drive folder and emails the closing balance of each bank account with the total. Works with CSV and Excel statements.
Steps in this flow
- Every workday 7:00
- Google Drive: list statement files
- For each statement file
- Google Drive: download the file
- Read the statement rows
- Find the closing balance
- List balances by account
- Total cash
- Email the cash position