Project Management using Trello and Google App Scripts

Why use Trello?

Trello is an easy, free, flexible, and visual way to manage your projects and organize anything, trusted by millions of people from all over the world. It is a very visual platform, where projects and tasks are managed as cards visible on the home page. Team members can view the cards assigned to them, update their statuses and collaborate on tasks with other members of the team.

Why use Google Spreadsheets?

Google Spreadsheets help you manage your data anytime anywhere. They are a part of Google’s cloud platform (G Suite). Hence using those guarantees 24×7 location free access from anywhere. You do not even have to carry your own system everywhere. Moreover, Google Spreadsheets come with the ability of adding your own business logic on your data by using powerful Google Apps Script language (It is JavaScript on cloud).

Not only can you perform desired business operations on your data, you can also generate aggregation reports and visually appealing charts/ graphs using google data visualization tools (also part of G Suit).

So what happens when you combine the two?

All your data for projects stays in the Google spreadsheets. However once you have a new row / updated row in Google Spreadsheet, App Script code can connect to the Trello application and automatically generate a new project/task card in the Trello job board for the team members to view it. Members can then use Trello to perform the collaboration on these projects / tasks.

You can also sort and run reports such as delays from due date and add results to the Google Spreadsheets.

What do you gain by this integration?

• Combine two matured technologies that specialize in their respective fields. Google Spreadsheets for storing and manipulating raw data and Trello for its ease of operation in managing project tasks
• Save your time & money by not getting these functionalities developed from scratch and kind of reinvent the wheel.