Fluid Edge Themes

Blog

Google Sheets Integration brings a world of possibilities to Hoopla TV

We use Google Sheets internally here at Hoopla, so integrating it with our platform was an obvious next step in the evolution of our platform. For our customers, Google Sheets offers four key new advantages: 1. New sources of data 2. Custom Metrics 3. New ways to input data 4. Leveraging the power of the Google ecosystem Why is this important? Hoopla is opening up office communications, employee engagement, and team motivation to innovative companies that want to energize their company and bring out the best in their employees.

New sources of data

Any metric that can be loaded into a Google Sheet, either manually or automatically, can now be synched to Hoopla where it can trigger Newsflashes and be used as a metric on your Leaderboards. Here at Hoopla, we encourage our employees to be healthy, and as we rang in the new year we held a post-holiday weight loss challenge. We used Google Sheets to keep track of the daily weigh-ins, and performed some calculations on the data so we could broadcast “percent of weight lost”. The updates were seamlessly routed to our big screen TVs throughout the office adding motivation, recognition and incentive to all.

Custom Metrics

Data comes in many different formats, but too often is restricted by the limitations of the report or system it’s coming from. That shouldn’t mean you have to resign yourself to working with sub-par metrics. Google Sheets is bi-directionally synched with Hoopla, so as an example, you can push Salesforce data from Hoopla to Google Sheets, perform calculations (i.e. percent of quota attained as shown below), and then automatically have the new metrics synched back to Hoopla to trigger news flashes or be displayed on your leaderboards. Here are common examples of custom metrics sales managers might want to produce and broadcast, but can’t always easily create:
  • Quota Achievement %
  • Average deal size
  • Goal progress %
  • Conversion Rates
  • Win rates
  • Projected Revenue
  • Distance from leader
  • Revenue splits
  • Adding together multiple metrics
  • Sales Rep rating score
  • Contest points

New ways to input data

Google allows team members to manually update their metrics by editing a shared Google Sheet. Alternatively, a manager can send out a Google Form through email to which each recipient can respond. This autopopulates a Google Sheet which then auto-updates your metrics in Hoopla. This is a natural extension for Hoopla customers who thrive on making business data transparent by broadcasting key metrics on TVs throughout their offices. Now with Google Sheets, teams can collaborate on data in their spreadsheets that is seamlessly integrated with Hoopla. Rather than one admin or manager controlling the data, you can open it up to a team.

Leveraging the Google Ecosystem

There are already numerous templates, functions, and integrations with Google Sheets that you can easily use to your advantage. Google Sheets provides templates for tracking invoices, budgeting, balance sheets, and timesheets. And certainly non-business templates for building your team culture for activities like: health & exercise, weight loss, potluck sign-ups, or hours volunteered. Sheets allows you to import a variety of data from other Google services as well as from the web at large. Google has several partner applications already integrated with Google Sheets, including CRM and Project Management. And if you want to pull in FitBit data, that too works with Google Sheets.

What’s Next?

Hoopla is constantly innovating to bring you the best experience to drive your team’s performance and improve communications throughout your office. If you’d like to stay abreast of the latest updates and announcements, and have access to future Beta features, please subscribe to our blog.
Google Sheets integration with Hoopla