Insight
The municipality of Järfälla’s internal systems had been operating with a complex organizational structure and outdated software for years. Digital Transformation Manager Oskar Lindberg spent hours each week on time-consuming manual processes to help his team report on progress and meet deadlines. He pursued a variety of integration solutions to optimize their system, but every option was either too complex or imprecise. After discovering Trello and convincing his team to start using it to manage their workload, he needed a way to then simplify their reporting processes. That’s when he came across Unito and discovered how it could support his team’s needs with a comprehensive automated solution.
Our initial thought was to create a Trello to Trello sync. But after talking to someone at Unito, we realized how easy it would be to include Google Sheets. It’s great for measuring basic statistics and a lot of our processes don’t offer an easy way to visualize data.
Oskar Lindberg, Digital Transformation Manager
Solution
First, Oskar built a flow to connect multiple Trello boards together. Then, one of Unito’s customer success managers showed him how to integrate Trello with Google Sheets. His team quickly modified their workflow to begin streamline and scale casework, prioritize critical tasks, and expedite their processes.
“Time is the most relevant factor for us and Unito is saving us loads of it. I would guess it’s saving one team member from having to send at least 100 emails per month.”
Oskar Lindberg, Digital Transformation Manager
Results
By syncing Google Sheets with Trello, Oskar’s team now has a system in place to track deadlines, their weekly backlog, and clarify which departments are responsible for each task.
- Directors now have greater oversight across departments with simplified, automated reporting and dashboards.
- Departments can now communicate quickly and easily with data synced from Google Sheets in real-time to Trello cards and their Teams group.
- Teams are more productive and able to meet deadlines without having to search for documents or use outdated software. No one’s stuck waiting for emails or manual input from colleagues in other offices.
“This type of information and these statistics are so useful for our director because we’ve never had this kind of overview before and we absolutely need it.”
Oskar Lindberg, Digital Transformation Manager
“Combining Trello with Google Sheets makes for a much more powerful statistical tool than using Trello on its own. It should be of huge interest to a lot of Trello users and it’s easy to jump in with Unito’s templates.”
Oskar Lindberg, digital transformation manager
About Järfälla Municipality
Järfälla is a growing municipality outside Stockholm, Sweden. The region’s 4,300 municipal employees constantly strive to provide the best possible service to those who live and work in the area. Oskar Lindberg’s team works with local elected officials and citizens to advise on civic planning, construction, regulation and other needs.
