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
- In Configuration, click on the Google Sheets tile.
- Under Metric Sources, click Add.
- Select the Google Sheet file from which you want to pull data. In each tab that you want to map, you must have a Column called “Email” that contains your Hoopla users’ email addresses.
- Start mapping your Columns to Hoopla Metrics.
- Select the Column in Google
- Select the Metric to map the Column to
What are the Rules for Mappings?
- 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:
MTD Sales Calls Today email@example.com $56,790 23 firstname.lastname@example.org $66,720 34 email@example.com $62,113 21
- Hoopla will only update data for rows that contain a valid email address for users who exist in Hoopla. In other words, if Hoopla doesn’t recognize the email, the row is ignored.
- Within a given Sheet Tab, you cannot map multiple Columns to one Metric.
- You can map multiple Columns to one Metric as long as those Columns come from different Sheet Tabs.
- You can map one Column to multiple Metrics.
- 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.