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
- In Configuration, click on the Google Sheets tile.
- Under Google Sheets, click Add.
- Select the Google Sheet to which you want to export Hoopla Metric data.
- 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!
- Repeat for all the Metrics you want to send to this spreadsheet.
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 always contain an "Email" column. This is how Hoopla identifies users.
- 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.
|Revenue MTD||Monthly Quota||Quota Attainment|
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.
- 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.