Hoopla's Excel Online integration enables you to export data from Hoopla to Excel Online, and import data from Excel Online to Hoopla. In an Excel spreadsheet, you can perform calculations on your Metric data, producing more sophisticated Metrics that can then be pushed back into Hoopla. You do not have to map data in both directions, but it certainly opens up some fun possibilities if you're also using the Salesforce integration!
Connecting to Excel Online
In Hoopla Configuration click on the Add Integration menu in the upper right corner, and select Excel Online.
Click on the Excel Online tile that was just added to the Config home page.
Connect to your Office365* account by clicking the Authenticate with OAuth button. You may need to log in to your Office365 account, if you haven't already. Note: If you're logged in to multiple accounts, select the account that contains the data you intend to connect with Hoopla.
Click Allow to connect your account with Hoopla.
*What type of Excel accounts are supported?
Excel Online can be found in a variety of Office365 accounts, but we only integrate with Business accounts with access to One Drive (and the One Drive API). If you have a personal Office365 account, unfortunately, you will not be able to use our Excel Online integration. Check out this chart to see the types of business accounts that are supported with this integration.
If you are unsure if you have the correct account type, don't fret! We will be able to detect your account type when you attempt to authorize the integration.