Google Sheets Integration

Google Sheets is a free online spreadsheet application that lets you create and format spreadsheets and work with other people. You can access, create, edit, and collaborate with others on your spreadsheets from your phone, tablet or computer. This integration is intended to make it much easier for you to get your data out of LeagueApps and distribute throughout your business.

• Never do a CSV download again; keep track of all of your data exports in one easy-to-use Google Sheets environment

• Your Google Sheet will update every 30 minutes or can be triggered to refresh easily

• Instantly share with specific stakeholders

How does the integration work?

Once the integration has been set up, your organization will follow this process:

1. Create a new Google Sheet which will contain your data from LeagueApps
2. See the data that you've selected in the sheet within your Google Drive
3. Data will regularly update based on your settings
4. Delete and create more tabs in your spreadsheet based on your needs

Setting up the integration

You can set up the integration by following the tutorial videos or how-to guide below.

Step 1: Adjust your program settings within LeagueApps

In order for your LeagueApps program data to sync over to Google Sheets, you'll need to select Google Sheets from the Integration Code field for each program.

1. Within your LeagueApps dashboard, go to your program then under Settings click Edit Details.
2. From the Integration Code drop down, select Google Sheets. This is a required step in order for the integration to work.
3. Set the program visibility to Public.
   

Step 2: Authenticate your LeagueApps site ID

1. From your LeagueApps Member Console, navigate to Integrations then click API settings.
   
   
2. Enter a name for your credentials, such as “Google Sheets,” then select the Generate Private API Key button. If you don't enter a name, the integration will not work.
   
3. Once a private API key is generated, a file will be downloaded to your computer and a new record will appear in the API KEYS list on the page. The name of this file is also known as the client ID. You will need both this file and the client ID in a later step.
   
4. In a separate browser tab, reopen LeagueApps and navigate to Integrations then click Integration Center.
   
   
5. Click on the Google Sheets icon and then select Connect App.
   
6. Next to the LeagueApps icon, select the Connect button. Supply your LeagueApps API credentials and select Save.
   • P12 file: Upload the private API key that you downloaded from the API Settings page. It is the form of a p12 file. For example, 60febf874c68s0wekbo203.p12.
   • Client ID: Paste the name of the private API key (p12 file) that you downloaded from the API Settings page. The client ID can also be found in the table on the API Settings page under Key Name. For example, 60febf874c68s0wekbo203.
   • Site ID: Type in your Site ID. This is the string of 4 to 5 numbers found in your browser’s URL bar. For example, 43590.
     

Step 3: Authenticate your Google account

1. In the Google Sheets tile within the Integration Center, next to the Google icon select Connect.
2. You will be taken to a separate tab where you can log into the Google account that you want the spreadsheets to be sent to. Click on the Google account you want to use. 
   
3. Click Allow to accept the privacy policy for the authentication to work.
   
4. Select Next.

Step 4: Create a Google Sheet

You'll be taken to a configuration page which will load after a minute or two. This is the page where you'll be able to create a spreadsheet and tabs using the data from connected programs in your site. Currently, you can create one spreadsheet with multiple tabs.

1. First, you’ll name your spreadsheet and select the time zone.
   
2. To create the first tab in the sheet, select the plus sign and then open the tab drop down.
   
3. Name the tab and select the data that you want information about. The data sets available are:
   • Registration data (basic)
   • Registration data (advanced)
   • Transaction data
   • Member data
   • Program data
   • Teams data
   • Schedule games data
   • Schedule events data
   • Product order data - Standalone (includes all product orders made outside of registration flow)
   • Product order data - All (includes all product orders made inside and outside of registration flow)
     To see an example of what fields are available on each of these data sets, see this example spreadsheet.
4. Depending on your data set selection, you may see a dropdown which shows what programs in your site you can get data from. The programs you’ll see in this list are those that have selected Google Sheets in the Integration Code. You can multi-select by clicking on different programs, or you can select all. If you don’t select any options in this dropdown, the integration will default to all programs.
   
5. Depending on your data set selection, you may see options for start and end dates for your data. Use the calendar selector to pick these dates. If the start date is left blank, the earliest data you have will sync over. If the end date is left blank, the most recent data you have will sync over. You are allowed to leave both start and end dates blank.
   
6. To create a second tab on the same spreadsheet, select the plus sign next to Tabs. Repeat this to create as many different tabs as you need (up to 200).
   
7. Once you’ve created all of the tabs you need, select Next. You will be able to create new tabs in the future by returning to the Integration Center tile and repeating these steps.

Step 5: Set the schedule and sync

On the next page, you'll be asked to set the sync schedule. The sync schedule is how frequently you want data to sync over from your LeagueApps programs to Google Sheets.

1. Be sure that the sync is unpaused (the toggle is to the left).
   
2. Select Save + Sync Now. After a few minutes, the integration will automatically create your first spreadsheet in your connected Google Drive account. Do not change the data in the master tab(s) (other than hiding columns as necessary). In other words, do not change the spreadsheet name or any information on the tabs that are created by the integration. You can, however, create new tabs within the same spreadsheet.
   

Using the integration

Depending on the settings you selected, you will see new and updated data in your spreadsheet after every sync cycle up until the end date you selected.

1. To delete or create a new tab or change the name of your spreadsheet, return to the Integration Center then click My Apps. On the Google Sheets tile, select the three vertical dots and then Connection Settings.
   
2. To delete a tab, select the trash can icon next to the tab you want to delete. Deleting a tab here means the data will no longer continue to sync to the connected Google Sheet. Then select Save.
   
3. To create a new tab, follow the same steps you did when initially creating the tab.
4. Changing the name of the spreadsheet in the connection settings will create a new spreadsheet in your Google Drive. You can also create and delete tabs as desired. You can currently only create one spreadsheet at a time.
5. If your integration is not paused, then it will sync data on a regular cycle, depending on your sync settings. If you’d like to trigger a sync immediately, you can select Sync Now on the Google Sheets tile.
   
6. If you would like to connect new programs to the integration, follow Step 1: Adjust your program settings within LeagueApps. Then, return to the Connection Settings page for the Google Sheets tile. At the top of the page is a circular arrow. Select that arrow to run an initial sync. After a few moments, this page will refresh, and the newly-set up programs will appear as options in the program drop down.