Simple Dialogue Systems in Google Sheets
Google sheets (and docs and slides) can be useful tools when doing virtual roleplaying sessions. The sheets can be shared with players, who have to use their technical chops to interact with them and tease out clues. Players can follow links to new sheets, or gain information that can be useful elsewhere in the campaign.
This post focuses on WiFi Connect, a Google sheet I put together for a larger online activity. You can copy the Google sheet here.

The sheet presents itself as a page with a happy little paperclip that is willing to help you connect to WiFi. There is a box into which the user can type. A cell gets updated below Clippy based on what is entered in the box.
In this example, the players need to connect to WiFi in order to proceed. The dialogue system takes what you pass in and performs a lookup to produce output. Players discover new possible inputs by interacting with the sheet.
The solution in this case is to connect to an unlisted network, "The promised LAN", which they discovered elsewhere in the gaming session. The password for that network is "DROP IT LIKE ITS HOTSPOT". If that is entered, the cell is updated with a hyperlink to the next thing.
Having a simple dialogue system is surprisingly entertaining. The players certainly appreciated it!
Under the Hood
The dialogue system has a hidden sheet in which the lookup happens. This is not a dialogue tree, which can store hidden state. Instead, it is a very simple dialogue lookup. The user's input is changed to upper case and then compared to a table of possible keys. If a key matches, then the corresponding output cell is presented to the player. As such, players can always jump straight to the end, if they happen to know what to type in.
The output achieves this with: `=VLOOKUP(TRUE, E1:F100, 2, FALSE)`. This means we are looking for a cell that is TRUE among those in column E, we return the value in the next column over, and we do not want an approximate match.

It is really easy to edit. You can easily change the look / feel of the first page to get an entirely different vibe. For example, you could be interacting with a demon, a shopkeeper, a logical guard, a sphinx, etc.
Hope this is useful!
Discussion
Discussion
No comments yet — be the first voice in the hall.
Observatory
Where Else It Leads
Observatory
Where Else It Leads
- Continue · Same shelf A Gasp of Glass Same shelf
- By Mageek Datagrams - A Multipart Google Suite Puzzle based on Set Some of my previous posts show how one can use Google sheets as standalone puzzles for role-playing games. This article takes things a step further by involving…
- By Mageek Magick Firewall - A Simple Google Sheet Puzzle This simple self-contained puzzle is a lock/gate built into a Google sheet. This "firewall" requires that the players input a magic square.
- By Mageek Norton Mini - A Simple Google Sheet Puzzle This simple self-contained puzzle is a nice entertaining roadblock on your player's digital path to success. An anti-virus inspired 5x5 crossword puzzle lock/ga…
- By Mageek Enigma Ciphers The Enigma - the 'unbreakable' German WWII cipher that has become an icon of cryptography and mystery. Learn how it works and why it is a great cipher for role-…
- By Mageek Terminal GAMEOS 2.7.11+ (DEFAULT, APR 17 2016, 14:00:29)[GCC 5.3.1 20160413]TYPE 'HELP' FOR MOREWHAT IS YOUR NAME?>>> MageekWELCOME, MAGEEK>>> LISTLIST WHAT?>>> LIST FIL…
- By Mageek Secret Wizard Bases with Your Peace of Mind in Mind You, a wizard, have a secret wizard base. Pesky adventurers and who knows what else would simply love to find it and loot all of your precious stuff. Here are s…
- By Mageek Sanctum of Water An underwater dungeon whose lore is heavily inspired by Lovecraft's The Temple, and whose design is inspired by Ocarina of Time's water temple. Contains interco…
- By Mageek Halving Yin-Yang A geometric cut puzzle that can be inserted into any dungeon/door/treasure chest.
- By Mageek The Beaches of Snæfellsjökull A real-world location fit for filling out your adventure; where norse icelandic fishermen suffered unthinkable conditions throughout frigid winters to harvest t…
- By Mageek The Guest Star Portends A desert-themed astrological puzzle inspired by a 2000 year-old analog computer, an ancient supernova, and the Ziggurat of Ur.
- By Mageek Cryptic Language - Tolkien Hobbit Runes Dwarven runes are (mostly) an alphabetic substitution cipher on the Futhark runes. An oldie but goodie from Tolkien!
Crossroads
Follow Another Path
Halls, shelves, and roads that leave this reading.
- Browse Dungeons This shelf
- Any in Dungeons
- Puzzles in Dungeons
- More by Mageek Author tower
- Locations Category hall
- Lifeforms Category hall
- Items Category hall
- Organizations Category hall
- Dungeons Category hall
- NPCs Category hall
- Plots Category hall
- Systems Category hall
- Articles Category hall
- Crossroads Recent traffic
- Guildhall Guilds & Quests
- Seek the Citadel Find a piece
Oh, this is an awesome idea. Strolen - we may have a new submission type here! :P
A sweet play on the Riddle of the Sphinx. And anybody can appreciate the puns!!! Fun idea to put some interactivity into it. And as you shown, the hard part is coming up with your text adventure style series of Q&A. Really a brilliant idea to bring into the game!!!