Use case: Reporting

How Järfälla Synced Trello with Google Sheets to Streamline Reporting

Järfälla Municipality

Industry

Public Services

Location

Stockholm, Sweden

Employees

2000

Use case

Reporting

Oskar Lindberg

Digital Transformation Manager at Järfälla Municipality

""I’m really happy we purchased Unito — it’s so easy. I had an idea in my mind and it only took an hour to build.""

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.

A snapshot of Jarfalla’s Trello board

“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.

Jarfalla’s Google Sheets dashboard synced with Trello data
  • 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.