Notes on Custom Pages

Google Sheets

Create a new Google Sheet.

1. Type a name for the document.

2. Add 4 columns: [PlayerID], [PlayerName], [TeamName], [Notes].

Share with TruMedia integrations email

1. Open the Share Google Sheets menu.

2. Copy and paste the email address below into the Add people and groups box:

3. Tap Send and select Share Anyway when prompted.

Copy SpreadsheetID

1. Copy the SpreadsheetID from the Google Sheets URL.

Custom Page Builder

Create Note component

1. Open the Custom Page Builder.

2. Add a Notes component where you want these notes.

Connect Google Sheets to the note component

1. Select Component Settings > Google Sheets.

2. Paste the SpreadsheetID in the Spreadsheet ID box.

3. Open PlayerID Col menu and choose [playerID].

4. Open Note Col menu and choose [Notes].

Add a title for the component

1. Hover over the component.

2. Select Component Settings.

3. Open the Title box and type a title for your graphic.

Export the team roster

1. Search a team.

2. Select the roster page.

3. Set the Filters and Qualifications to determine which players to include on the roster export.

4. Export the roster to a .csv file.

Add the roster to Google Sheets

1. Open the .csv file and copy the [playerID] and [playerFullName] columns in the exported .csv file.

2. Paste them in the Google Sheet.

3. Add a [TeamName] column in the Google Sheet to organize the players by team.

4. Write notes for each individual player in their row of the [Notes] column.

Confirm the notes added on a Custom Page

1. Search the team on TruMedia

2. Select the roster page.

3. Open the Custom Page you created.

4. Search a player you wrote notes for and confirm they are on the Custom Page.

Contact Us