Mapping Data from Google Sheets to Hoopla (Hoopla)

Create custom metric values from Spreadsheet formulas and send them to Hoopla on an automated schedule.

To help automate Metric updates, you can map data from a Google Sheet into Metrics that are defined in Hoopla. As the data in Google Sheets changes, Hoopla will update Metric data accordingly.

How to Set Up Mappings from Google to Hoopla

  1. Go to the Configure tab in the main Hoopla Admin panel in the web app. 

  2. Click on the Integrations Tile or go to Integrations in the left hand menu and click on the Google Sheets tile.

  3. Under Google Sheets, click Add.

  4. Select the Google Sheet file from which you want to pull data. For player metrics, in each tab that you want to map, you must have a column called “Email” that contains your Hoopla users’ email addresses. Or, if you are bringing in Team data, you must have a column called "Team Name" which corresponds to your Team names in Hoopla.

  5. Start mapping your Columns to Hoopla Metrics. First, select a Column in Google. Then, select a Metric to map the Column to.

  6. Schedule how frequently Hoopla should sync with this Google Sheet.

  7. Click OK, then Save.

What are the Rules for Mappings?

For bringing in Player metrics, your Google Sheet must contain summarized information, grouped by user email addresses. There must be a column called “Email”, and the remaining columns should contain Metric values for each user. Example:

For bringing in Team metrics, your Google sheet must contain summarized information, grouped by the Team name in Hoopla. There must be a column called "Team Name" and the remaining columns should contain Metric values for each team.

Example:

Team Name

Revenue MTD

Revenue YTD

Team 1 - East

$120, 430

$355, 001

Team 2 - Central

$99,098

$256,198

Team 3 - West

$129,444

$388,030

  1. Hoopla will only update data for rows that contain a valid email address for users or team names who exist in Hoopla. In other words, if Hoopla doesn’t recognize the email or team, the row is ignored.

  2. Within a given Sheet Tab, you cannot map multiple Columns to one Metric.

  3. You can map multiple Columns to one Metric as long as those Columns come from different Sheet Tabs.

  4. You can map one Column to multiple Metrics.

  5. You cannot have columns with the same name on the same tab.

  6. You cannot create "loops" by mapping the same Metric and Column in both directions. In other words, you cannot map Metric 1 → Column A, then map Column A → Metric 1. 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request