How-to · Hoopla
Connect Hoopla to Google Sheets
Connect Hoopla to your Google account so you can export metric data to Google Sheets and import calculated data back into Hoopla.
Set up the integration between Google Sheets and Hoopla
Section titled “Set up the integration between Google Sheets and Hoopla”Hoopla 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 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 Google Sheets
Section titled “Connecting to Google Sheets”-
Go to the Configure Tab on the main Hoopla Admin screen and click on the Integrations Tile or select Integrations on the lower left-hand menu sidebar.
-
In the upper right-hand corner go to Add Integrations and select Google Sheets.
-
Click on the Google Sheets tile that was just added to the Config home page.
-
Connect to your Google account by clicking the Authenticate with OAuth button.
-
You may need to log in to Google if you haven’t already.
-
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 Google account with Hoopla.
See these articles for instructions on mapping data:
Section titled “See these articles for instructions on mapping data:”Mapping Data from Hoopla to Google Sheets
Mapping Data from Google Sheets to Hoopla
Related articles
Section titled “Related articles”- Map data from Hoopla to Google Sheets Export Hoopla metric values to the Hoopla Mapped tab in Google Sheets so you can run calculations and build more complex metrics.
- Map data from Google Sheets to Hoopla metrics Automatically update Hoopla player or team metrics from Google Sheets by mapping sheet columns to metrics on a sync schedule.
- Display data tables from Google Sheets on your screens Show up to four columns from a Google Sheet as a data table in your channel lineup, with display settings and a sync schedule you control.
- Add generic metrics from Google Sheets Set up a Generic Identifier tab in Google Sheets and map it to Hoopla metrics that aren’t tied to users or teams, such as website traffic.
Still having trouble?
Email our support team.