Start.gg Seeding Uploader

Go Script for Seeding Phases to start.gg API

This script imports seed mappings from a Google Sheets CSV into a specific phase using start.gg's GraphQL API. Below is an overview of how it works and instructions on setting it up.

Table of Contents

1. Overview
2. Requirements
3. How to Get Required IDs and Tokens
4. Setup and Usage
5. Google Sheet Example
6. Error Handling
7. Troubleshooting
8. Success Response

Overview

This Go script reads seed mappings from a Google Sheets CSV and updates them in a tournament phase on start.gg via their GraphQL API.

• The script pulls data from a Google Sheet (in CSV format).
• It uses start.gg's API to update phase seeding.

Requirements

• Go installed on your system
• A Google Sheets file containing the seed mappings
• start.gg API authentication token
• Phase ID (from start.gg)

How to Get Required IDs and Tokens

Phase ID

1. Go to the start.gg website and navigate to the tournament page.
2. Look for the phase of the tournament you want to update.
3. The Phase ID is visible in the URL as a part of the path, e.g., https://start.gg/tournament/{tournament-name}/event/{event-name}/bracket/{phaseId}.

Google Sheets Key

1. Open the Google Sheets file with the seed data.
2. Copy the key from the URL, which is between /d/ and /edit in the link:
   Example:
   https://docs.google.com/spreadsheets/d/{sheetsKey}/edit

Auth Token

1. Navigate to start.gg API.
2. Create or log in to your start.gg developer account.
3. Generate a new API token.

Note: You must be an admin of the tournament to generate and use an API token for seeding updates.

Setup and Usage

1. Clone the repository, or directly download the main.go file.

2. Set up the environment variables:

   • phaseId (replace with the actual Phase ID)
   • sheetsKey (replace with your Google Sheets key)
   • authToken (replace with your start.gg API token)

3. Run the script:

go run main.go

Google Sheet Example

The provided Google Sheet consists of two sheets. You can view the example sheet here.

1. Seed Upload (Sheet 1): This sheet contains the seed data to upload to start.gg.
2. Phase Export (Sheet 2): This sheet contains an export from start.gg's bracket phase.

Important: The first sheet (Seed Upload) should always contain the seeding data to be uploaded.

Note: The Google Sheet should remain public during the upload process. If needed, the sheet can be set to private after the seeding has been successfully uploaded.

Seed Upload (Sheet 1)

This sheet contains the following columns:

• SeedNum: The seed number in the tournament.
• SeedId: The unique seed identifier from start.gg.

Phase Export (Sheet 2)

This sheet is an export from start.gg and contains:

• Phase Wave Pool: The phase and pool information.
• Pool Seed: The player's seed within their pool.
• Phase Seed: The player's seed within the phase.
• Entrant: The name of the player/team.
• GamerTag: The player's gamer tag.
• Seed ID: The unique seed identifier from start.gg, used for mapping in uploads.

Instructions for Exporting Data from start.gg

1. Go to the tournament page on start.gg.
2. Select the phase you want to export.
3. Follow the steps in the start.gg export guide to export the phase seeding as a CSV file.
4. Use this export to cross-check or prepare the data for uploading.

Error Handling

If there are errors, the script will print the error messages returned by the API. Make sure:

• The Phase ID is valid.
• The Google Sheets CSV is properly formatted.
• You have admin rights for the tournament.
• The auth token has the correct permissions.

Example output for an error:

{
  "errors": [
    {
      "message": "Invalid Phase ID",
      "locations": [{ "line": 2, "column": 3 }],
      "path": ["updatePhaseSeeding"],
      "extensions": {
        "code": "BAD_USER_INPUT"
      }
    }
  ]
}

If you see an error similar to the above, verify that the Phase ID and the input data are correct.

Troubleshooting

• Invalid Auth Token: Check that your token is up-to-date and has the necessary permissions. You can regenerate the token via the start.gg API developer portal if needed.

• Invalid Phase ID: Ensure the Phase ID is correctly copied from the URL of the tournament's phase you want to update. If the Phase ID is incorrect, the API will return an error.

• Incorrect CSV Format: Ensure the CSV from Google Sheets has the expected structure. The script expects the third column to contain SeedId and the first column to contain SeedNum. Any mismatch in the columns could lead to errors.

• Network Issues: If the API or Google Sheets CSV cannot be accessed, check your internet connection or whether there is an issue with the respective services.

Success Response

On success, the script will print:

{
  "data": {
    "updatePhaseSeeding": {
      "id": "1696690"
    }
  }
}

This confirms that the seeds have been successfully imported to the phase.