Using Google Workspaces to Bridge Gaps Between Meaningful COVID-19 Insights

How a web-based interface helped track COVID-19 cases, resource availability, status of testing and vaccination, and facility capacity in real-time.

Partnership with Northwest Arkansas Council

In the height of the global pandemic, Northwest Arkansas Council, a nonprofit organization established in 1990, was ready to create actionable data for local hospitals to manage the ever-changing conditions. The NWA Council is no stranger to serving its community. For over 30 years, the NWA Council has helped to shape the development of the region to advance job opportunities, infrastructure, health care, and quality of life. Most of the more than 100 members are companies, including Walmart, Tyson Foods, J.B. Hunt Transport Services, Simmons Foods, and George’s, Inc.‍

The Challenge 

To face the challenges of the pandemic, the NWA Council needed a way to consolidate statistics regarding COVID-19 from all of the regional medical institutions and healthcare groups. The current process was manual, with collaboration and communication facilitated through phone calls and handwritten notes. As more statistics were added, the process was becoming increasingly unwieldy, error-prone, and inefficient.

The Solution

RevUnit developed a more streamlined process for tracking critical information by leveraging Google Sheets as a collaboration tool for data capture, analysis, and reporting. Each healthcare organization designated authorized users to enter data including COVID-19 cases, PPE/resource consumption, and ventilator and bed capacity, providing a single source of truth and real-time access to data.

Solution Pillars

• Data management
• Productivity and collaboration
• Smart analytics

Solutions

Google Workspace:

• Google Sheets
• Google Docs
• Gmail

The Results

‍Bringing almost immediate relief, the Google Workspace collaboration tool was launched to all participating regional healthcare organizations in only 12 days from the initial discussion. The data entered into the tool was captured with logged changes, then shared for visibility, collaboration, resource and facility planning, and media reporting to the public across the region for the last two years.
‍

"This joint effort demonstrates how the Northwest Arkansas community is coming together in a powerful way to respond to an unexpected crisis. Support from these great partners will allow the region's health care providers to continue to protect staff, patients and keep our community safe."–

Nelson Peacock | President & CEO, Northwest Arkansas Council

‍