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

  1. Every workday 7:00
  2. Google Drive: list statement files
  3. For each statement file
  4. Google Drive: download the file
  5. Read the statement rows
  6. Find the closing balance
  7. List balances by account
  8. Total cash
  9. Email the cash position

All templates