Hoopla’s Google Sheets integration enables you to export data from Hoopla to Google Sheets, and import data from Google Sheets to Hoopla. In a Google Sheet, you can perform calculations on your metric data, producing more complex metrics that can then be pushed back into Hoopla. You do not have to map data in both directions if you don't want to.
How to Set up Mappings from Hoopla to Google Sheets
Under Configure go to Integrations and click on Google Sheets Integration.
To connect new Metrics, click Add.
In the drop-down, select the Google Sheet to which you want to export Hoopla metric data. Note: If you do not see the Google Sheet you are looking for, you need to make sure you share your Google Sheet with the email address that was used to authenticate the integration (top of page under "Authentication").
Hoopla will only send metric data to a Sheet Tab named "Hoopla Mapped". If that Sheet Tab does not exist in your spreadsheet, click the button that says Create "Hoopla Mapped". If the tab exists, Hoopla will detect it, and you can start mapping!
From the Metric dropdown menu, select a metric that you wish to send to "Hoopla Mapped", then designate the column to which the Metric data will be exported.
Repeat for all the Metrics you want to send to this spreadsheet.
Using the dropdown menu at the bottom of the modal, schedule how often you want Hoopla to sync with this Google Sheet.
Click OK, then Save.
How does the "Hoopla Mapped" Sheet Tab work?
Within one Google Sheet file, Hoopla only sends metric data to one Sheet Tab, called "Hoopla Mapped".
When you set up a new Google Sheet mapping in Hoopla, you have the option of creating the "Hoopla Mapped" tab; no need to create it ahead of time.
"Hoopla Mapped" must contain either an "Email", "Team Name" or "Generic Identifier" column, depending upon which data is being mapped to the spreadsheet. This is how Hoopla identifies which data should be used.
The remaining columns may contain metric data, manually entered data, or formulas. It will depend on what you're trying to accomplish!
You can map manually entered data or formula results back to Hoopla if you wish.
Example of a "Hoopla Mapped" Sheet Tab:
You can absolutely have other Sheet Tabs in your spreadsheet. With those other Sheet Tabs, you can map from Google → Hoopla, but not from Hoopla → Google.
Remember: Only the “Hoopla Mapped” tab can receive data from Hoopla.
What are the Rules for Mappings?
Within a given Google Spreadsheet, you can only map Hoopla Metric data to the Sheet Tab called "Hoopla Mapped".
You must have a column called "Email" that contains Hoopla user email addresses, "Team Name" that matches your Hoopla team(s), OR "Generic Identifier" depending which data is being mapped.
You cannot map two or more Metrics to the same column.
You can map one Metric to two columns.
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.