Use case: Reporting

How Järfälla Synced Google Sheets Reports to Trello Boards

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 manage workloads and meet deadlines.

Oskar pursued a variety of integration solutions to optimize their system, but every option was either too complex or imprecise. That’s when he came across Unito and discovered how it could support his team’s needs with a comprehensive automated solution. 

“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

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

“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

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

About Järfälla

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.

“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

Transform your reporting workflows.

Try Unito for 14 days, absolutely free.

Try it free

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.