Fleet Compliance Board (Tamm)

Every week, checks every fleet vehicle in Tamm and emails the fleet manager an Excel board with inspection, insurance and registration status. Vehicles with no insurance, or an inspection or registration due within 14 days, also get their own alert.

Steps in this flow

  1. Every Sunday 6:30
  2. Google Sheets: read the fleet
  3. For each vehicle
  4. Tamm: latest inspection
  5. Tamm: insurance policies
  6. No insurance policy found?
  7. Inspection expires within 14 days?
  8. Registration expires within 14 days?
  9. Alert the fleet manager
  10. Collect the board rows
  11. Excel board
  12. Email the board

All templates