SheetsIO demonstration example template

As part of a demonstration on BroadcastGG's stream, an example spreadsheet of how a combination of lookups, data validation and macros was made.

Here is a link to that sheet.

Feel free to 'File' -> 'Make a copy' and use it as a basis for your streams!

Information on some of the formula and macros used in the sheet can be found in our tips article.

If you make something cool using SheetsIO, please do let us know - the Discussions tab is open for submissions.

Config

Remember to change "spreadsheetId" with the ID of your copy, and ensure your copy's sharing options is set to 'anyone with the link can view'.

{
	"projectName": "SheetsIO-Example",
	"worksheetName": "Main",
	"spreadsheetId": "1IVQ10DuIQ2qYtHB67frHIRslAUn3uJbofr-nKBs6hZg",
	"cells": [
		{ "cell": "L3", "name": "caster1Name" },
		{ "cell": "M3", "name": "caster1Link" },
		{ "cell": "N3", "name": "caster1URL", "fileExtension": "html" },
		{ "cell": "O3", "name": "caster1Image", "fileExtension": "png" },

		{ "cell": "L4", "name": "caster2Name" },
		{ "cell": "M4", "name": "caster2Link" },
		{ "cell": "N4", "name": "caster2URL", "fileExtension": "html" },
		{ "cell": "O4", "name": "caster2Image", "fileExtension": "png" },

		{ "cell": "L6", "name": "bestOf" },
		{ "cell": "L7", "name": "custom" },
		{ "cell": "L9", "name": "marquee", "fileExtension": "txt", "pad": "95" },

		{ "cell": "L11", "name": "comingMatchup" },
		{ "cell": "L12", "name": "currentMatchup" },

		{ "cell": "L14", "name": "team1Name" },
		{ "cell": "L15", "name": "team1Logo", "fileExtension": "png" },
		{ "cell": "O14", "name": "team1Score" },

		{ "cell": "L18", "name": "team1CoachNick" },
		{ "cell": "M18", "name": "team1CoachName" },
		{ "cell": "L19", "name": "team1Player1Nick" },
		{ "cell": "M19", "name": "team1Player1Name" },
		{ "cell": "L20", "name": "team1Player2Nick" },
		{ "cell": "M20", "name": "team1Player2Name" },
		{ "cell": "L21", "name": "team1Player3Nick" },
		{ "cell": "M21", "name": "team1Player3Name" },
		{ "cell": "L22", "name": "team1Player4Nick" },
		{ "cell": "M22", "name": "team1Player4Name" },
		{ "cell": "L23", "name": "team1Player5Nick" },
		{ "cell": "M23", "name": "team1Player5Name" },

		{ "cell": "L25", "name": "team2Name" },
		{ "cell": "L26", "name": "team2Logo", "fileExtension": "png" },
		{ "cell": "O14", "name": "team2Score" },

		{ "cell": "L29", "name": "team2CoachNick" },
		{ "cell": "M29", "name": "team2CoachName" },
		{ "cell": "L30", "name": "team2Player1Nick" },
		{ "cell": "M30", "name": "team2Player1Name" },
		{ "cell": "L31", "name": "team2Player2Nick" },
		{ "cell": "M31", "name": "team2Player2Name" },
		{ "cell": "L32", "name": "team2Player3Nick" },
		{ "cell": "M32", "name": "team2Player3Name" },
		{ "cell": "L33", "name": "team2Player4Nick" },
		{ "cell": "M33", "name": "team2Player4Name" },
		{ "cell": "L34", "name": "team2Player5Nick" },
		{ "cell": "M34", "name": "team2Player5Name" },

		{ "cell": "L37", "name": "pickBan1Name" },
		{ "cell": "M37", "name": "pickBan1Image", "fileExtension": "png" },
		{ "cell": "O37", "name": "pickBan1TeamLogo", "fileExtension": "png" },
		{ "cell": "Q37", "name": "pickBan1Type", "fileExtension": "png" },

		{ "cell": "L38", "name": "pickBan2Name" },
		{ "cell": "M38", "name": "pickBan2Image", "fileExtension": "png" },
		{ "cell": "O38", "name": "pickBan2TeamLogo", "fileExtension": "png" },
		{ "cell": "Q38", "name": "pickBan2Type", "fileExtension": "png" },

		{ "cell": "L39", "name": "pickBan3Name" },
		{ "cell": "M39", "name": "pickBan3Image", "fileExtension": "png" },
		{ "cell": "O39", "name": "pickBan3TeamLogo", "fileExtension": "png" },
		{ "cell": "Q39", "name": "pickBan3Type", "fileExtension": "png" },

		{ "cell": "L40", "name": "pickBan4Name" },
		{ "cell": "M40", "name": "pickBan4Image", "fileExtension": "png" },
		{ "cell": "O40", "name": "pickBan4TeamLogo", "fileExtension": "png" },
		{ "cell": "Q40", "name": "pickBan4Type", "fileExtension": "png" },

		{ "cell": "L41", "name": "pickBan5Name" },
		{ "cell": "M41", "name": "pickBan5Image", "fileExtension": "png" },
		{ "cell": "O41", "name": "pickBan5TeamLogo", "fileExtension": "png" },
		{ "cell": "Q41", "name": "pickBan5Type", "fileExtension": "png" }
	]
}

Output

Here's an example of how you might arrange the above... Casters scene:

Pick and ban scene:

Team composition screen: