Project Description

Integrate with Trello task board to store and summarize tasks in each project being implemented by the company to store project data for reporting purposes like delays

Client: Software Company, Hong Kong


  • Trello ( is a task management application. It gives visual representation of the task lists and who is working on them.
  • We used Google Apps Script to access Trello API from Google Spreadsheet and read task lists for each project
  • Added business logic to the tasks data in projects before storing them in the Spreadsheets – calculate number of story points associated with each task based on its complexity, delay in task from due date, group the tasks by project and user for easy reporting