Google Workspace Results
• Expedites a customer’s financial reports by 67%
• Improves data integrity and control
• Saves teams hours of effort each week and cuts risk
• Consolidates 1,700 sites down to 30
• Simplifies growth for SADA and its customers
In business, there is often a better way to get things done—and SADA helps companies find it. Years ago, SADA’s founders discovered that they could quickly solve organizations’ problems by taking full advantage of Google Cloud Platform including Google Workspace. To stoke rapid success for itself and all its customers, SADA’s vision quickly expanded from being a custom application developer to becoming a Google Cloud Managed Services Provider MSP” as well.
At its core, SADA provides straight-up Google Workspace hosting and its teams help companies migrate data from Microsoft Office applications to Google Gmail, Google Sheets, and Google Drive. However, SADA goes the extra mile. It helps customers tackle challenges such as improving collaboration and data security by creating applications and automating workflows with Google Apps Script, the Google Workspace Admin SDK, and other platform components that make it easy to integrate and extend Google Workspace.
By empowering its customers and employees with Google Workspace and the broader Google Cloud Platform, SADA has driven real business transformation for thousands of global organizations. Its customers’ measurable outcomes have helped SADA accelerate growth and earn numerous Google Cloud Partner of the Year awards. Kelly Wright, Director of Workspace at SADA, says, "SADA opens up new horizons of business opportunities for customers but also for our own teams by using Google Workspace to create people-centric processes that minimize repetitive, day-to-day tasks and improve agility."
With the built-in tools for integrating, automating, and extending Google
Workspace, SADA has helped individual organizations:
— Expedite quarterly and year-end reports by 67% across 50 offices
— Improve data control and the speed and accuracy of sales insights
— Accelerate timesheet and payroll processes while boosting security
— Increase efficiency and cost savings by consolidating 1,700 SharePoint sites to 30 Google Workspace Sites
— Save dozens of hours of effort each week and reduce risk
It’s not just about what you have. It’s what you do with it.
SADA’s secret sauce starts with helping organizations really dig into their workflows to understand how long they take, who’s involved, who’s affected, what data is shared, and whether information is effectively protected. “As customers migrate to Google Workspace, we partner with them in a Transformation Lab and help them step back, review their processes, and understand if they’re going about things in the best way," says Wright. "We then help them create actionable steps to solve their challenges using tools in Google Workspace. Even just storing files in Drive and setting permissions for downloading and sharing data are easy ways to improve security that people coming from the Microsoft Office world don’t always know about. We also show them how to save time by automating workflows.”
Accelerates quarterly and year-end reporting by 67 percent
“This organization now generates its quarterly and year-end P&L reports 67 percent faster. And when employees skip a field or add incorrect information, the app immediately triggers an alert." Kevin Tuuri, Solutions Architect, SADA
Recently, one of SADA’s enterprise customers sought to spend less time generating quarterly and annual profit-and-loss (P&L) statements. The company also wanted to prevent people from sharing reports with unauthorized viewers. Accountants at 50 different offices were manually tracking their site’s P&L data in their own siloed spreadsheets. At the end of each quarter, the accountants sent their spreadsheets to one person who then spent two to three weeks manually compiling, correcting, and verifying all the data.
To streamline this workflow and boost security, SADA engineers created a web app using Google Apps Script, Google Sheets, Google Data Studio, Google BigQuery, and an access control list. Today, all the company’s accountants use the web app to enter and manage their teams’ P&L data. Kevin Tuuri, Solutions Architect at SADA, says, “This organization now generates its quarterly and year-end P&L reports 67 percent faster. And when employees skip a field or add incorrect information, the app immediately triggers an alert asking them to fix and resubmit their information.”
The app's automated workflows also generate new types of reports that improve financial insight. And administrators can also control who can access, edit, and share specific types of data in every report. “This customer no longer worries about leaking spreadsheets because its data is covered by the Google security model, which is the best of the best,” Tuuri says.
Boosts the efficiency of sales staff and increases their data insight and control
“This customer no longer worries about leaking spreadsheets because its data is covered by the Google security model, which is the best of the best.” Kevin Tuuri, Solutions Architect, SADA
Another SADA customer had been consolidating sales data from numerous corporate teams into one spreadsheet that they all used to create their own reports. These customer teams also had no way to limit who saw what information and their unique reporting models created inconsistent business insights.
When the customer migrated its data from Microsoft Office to Google Workspace, SADA engineers showed the company’s IT staff how to streamline this workflow and improve control by creating a web app with Google Workspace REST APIs, Apps Script, Sheets, and Data Studio. Today, instead of entering sales data in a shared spreadsheet, employees enter it in the app. An automated workflow accurately compiles the data from all sales teams using standardized calculations, and it presents insights on a dashboard. And because each person only sees the data that they are authorized to view, the company has been able to increase stakeholder visibility into sales data. “Spreadsheets are often silos,” explains Wright. “With Google Workspace, we can help customers visualize their information in a way that’s more useful to more people, while giving them greater control.”
Improves security and delivers faster timesheet and payroll processes
As part of its standard services, SADA routinely sends customers surveys, asking about the business challenges they’re facing. One of SADA’s Google Cloud customers was struggling with its manual timesheet and payroll processes. “Employees recorded their numbers in individual spreadsheets and the accounting team then spent a lot of time compiling all that payroll data, verifying data accuracy, and resolving errors,” says Tuuri. “We said, ‘Hey, you’re already on Google. We can easily fix this for you.’ So we built an app using Apps Script, Sheets, the Drive API, and a little storage in BigQuery. We also used the Admin SDK to help secure user logins and protect all the data from unauthorized access.”
Today, employees submit their time using the web app. Automated workflows check that data entries are accurate, store the data in BigQuery, and compile and summarize the data using Sheets and Data Studio. ”This workflow is so much faster today for everyone and the solution is a huge win in terms of data integrity,” Tuuri says. “Now if someone makes a data entry error, they get an immediate alert in the app so that they can fix it right then and there.”
Protects office staff and saves administrators dozens of hours of effort each week
When the pandemic emerged, one of SADA’s customers was struggling to make sure that conference rooms were cleaned after every meeting. The administrator responsible for this task personally alerted the cleaning crew whenever a new meeting was scheduled. Managing this process required hours of manual effort each week, and rapid schedule changes meant that rooms weren’t always cleaned. “We built a tool with Apps Script and APIs that automatically adds an appointment for the cleaning crew 15 minutes before or after every scheduled meeting,” Tuuri says. “Not only does this process keep employees safe, but also the administrator no longer spends any time managing this task.”
Reduces storage costs by eliminating 1,670 file shares
One of SADA’s government customers wanted to migrate all its email, calendars, contacts, and files from Microsoft Office to Google Workspace. Instead of just lifting and shifting its existing environment to the cloud, the agency asked SADA to help simplify workflows wherever possible. “Before we migrated its environment, we helped this government entity identify unused files,” says Wright. “And by doing so, we helped the agency consolidate 1,700 SharePoint sites down to 30 Google Workspace Sites, which has dramatically reduced its storage costs."
Facilitates a sustainable transformation cycle
“All the streamlined processes we’ve put in place empower our teams so that we can now take on bigger projects and help more organizations drive real business transformation by solving their most complex problems with Google Workspace." Kelly Wright, Director of Workspace, SADA
SADA also uses Google Workspace tools to increase its own efficiency. Instead of spending hours reformatting bulk data imports for every new customer who’s migrating to Google Workspace, SADA engineers automated the workflow. Now they just click a button and the customer’s data is automatically imported and reformatted as needed. SADA engineers also created an app that automatically generates a migration report for customers each day, saving engineers five to eight hours of effort each week. Wright says, “All the streamlined processes we’ve put in place empower our teams so that we can now take on bigger projects and help more organizations drive real business transformation by solving their most complex problems with Google Workspace.”
*Google Workspace was formerly known as G Suite prior to Oct. 6, 2020.