How it works…

Google provides a Sheets API which enables applications to access and manipulate Google Sheets. Given a valid URL (website link) and appropriate privileges, the CourtHive Cloud Server uses this API to pull data out of sheets and return data to TMX clients. Data being returned to TMX is organized by Column Names, which means that in order for data to be useable within TMX it must be recognized and mapped to appropriate attributes.

Enabling Access

By default Google Sheets may only be viewed and edited by their creator or owner. In order for the CourtHive Cloud Server to access the data in a Google Sheet, you must Share the sheet.

The first step to share a google sheet is to press the blue Share button in the upper right hand corner of a sheet:

Share
Share Button

The easiest way to share a google sheet is to click Generate Shareable Link in the dialogue that appears:

Generate Shareable Link
Anyone can view
Sheet Sharing
Edit Link
Edit Link

Accepted Column Names

Spreadsheet data can only be recognized by TMX if columns have appropriate headings. The table below outlines accepted column names which enable data to be appropriately mapped as player attributes.

Attribute Accepted Columns Description
ID ID, UUID, Unique ID, Unique Identifier Player Unique Identifier
Name Name Parsed into First/Last Names
Last Name Last, Last Name Player Last Name
First Name First, First Name Player First Name
Gender Gender, Sex Player Gender
Profile Profile, UTR Profile, UTR Player Profile Link Link to player on MyUTR.com
Email Email, E-Mail Player E-mail
Phone Phone, Phone Number Player Phone Number
Location Location City and State
Rank Rank, Ranking Player Ranking
Rating Rating Player Rating
Birthdate Birth, Birthdate, Birth Date, Date of Birth Player’s Birthdate
Country Country Full Country Name
School School Player School Name
School Abbreviation School Code, School Abbr, School Abbreviation Abbreviation for School

JotForm Example

JotForm is a great way to automate the creation of Google Sheets which can serve as data stores for tournament registrations.

See the JotForm Example for step-by-step instructions.