MLB Help Center

Notas en páginas personalizadas

Google Sheets

Create a new Google Sheet

  1. Create a new Google Sheet.

  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:

  1. Tap Send and select Share Anyway when prompted.

Copy SpreadsheetID

  1. Copy the SpreadsheetID from the Google Sheets URL.

spreadsheetID.png
The spreadsheet idea is the characters after /d/ until the next back slash

Custom Page Builder

Create Notes component

  1. Open the Custom Page Builder.

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

Connect Google Sheets to the notes 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].

The Note Col menu tells the computer where to put the notes in this column on the Custom Page.

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.

Turn the Display Columns Only setting off.

If it is on, the playerID column will not download.

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.

Pro Tips

Adjust the alignment of the note

  1. Hover over the component

  2. Select Component Settings.

  3. Open the Vertical Alignment menu and choose an option.

  4. Open the Horizontal Alignment menu and choose an option.

Change font size of the note

  1. Hover over the component

  2. Select Component Settings > Google Sheets.

  3. Open the Note Font Size menu and choose an option.


Contact Us