I keep turning my Google Sheets into phone-friendly webapps, and I can’t stop

It started, like so many overwrought home optimization projects, during the pandemic. My wife and I, like many people stuck inside, were ordering takeout more frequently. We wanted to support local restaurants, reduce the dish load, and live a little. It became clear early on that app-based delivery services like DoorDash and Uber Eats were not the best way to support local businesses. If a restaurant had its own ordering site or a preferred service, we wanted to use that—or even, heaven forfend, call the place. The secondary issue was that we kept ordering from the same places, and we wanted to mix it up. Sometimes we'd want to pick something up nearby. Sometimes we wanted to avoid an entire category ("Too many carbs this week, no pasta") or try the newest places we knew about, or maybe a forgotten classic. Or just give me three places randomly, creative constraints, please—it's Friday. At its core, this is a shared list, i.e. spreadsheet. But my spreadsheet maintenance enthusiasm greatly outweighs that of my spouse. More than that, have you ever pulled up a Google Sheet or online Excel file on your normal-sized phone to make changes? I do so only in moments of true desperation. For things that are bigger than a note or dry-erase board but smaller than paying for some single-use, subscription-based app, I build little private webapps with Glide. You might use something else, but Glide is a really nice entry into the spreadsheet-to-app milieu. The apps it creates are the kind that can easily be shared and installed (i.e., "Add to Home Screen") on phones, tablets, or desktops, from a browser. Here's how it worked for me.

Why you might want to make a little personal webapp

Glide is technically a no-code tool aimed at businesses, but you get one user-based published app for free, and you can have more "private" apps if you're truly keeping it to your household or friend group. Each full-fledged app can have 10 users and up to 25,000 rows, which should probably be enough for most uses. I do wish there was a "prosumer" kind of account that billed for less than $828 per year. If you want more than one (relatively) small-scale apps, there are alternatives, like Google's AppSheet (included in most paid Google Workspace accounts). But most are just as business-oriented, and none have struck me as elegant a tool as Glide. As mentioned, my primary use for a sheet-based app is to make searching, filtering, reading, and editing that sheet far easier. In the case of my takeout app, that meant being able to search anything—a specific restaurant, "tacos," a quadrant of the District of Columbia. And a sorting option for when I added a restaurant, so I can find the place I added while a friend was recommending it.

Let’s whip up a webapp

Throwing that sheet fresh into Glide, it's not off to a bad start. The main view of Glide is a usable version of your app, and I can see that I can already type whatever I want into the search bar, and it will search across fields.

I could honestly stop here if I wasn't picky about some of the quirks I'm seeing. The app is showing screens, "Public" and "Users," and I want to hide them. In the upper-left corner, in Navigation, I'll click an eye icon to hide the "Users" section. With "Public" selected, I'll change the Label in the upper-right to "DC Takeout," and, if I was going to have more than one screen, give it an icon. The app already provided a "+" button for adding restaurants, just a simple vertical stack of entry boxes, along with a date picker for Date Added. If you prefer something static, toggle off the options in the "Actions" field in the bottom-right. Searching is pretty robust, but what if you want to browse a broad category or just see stuff that's nearby? In the "Options" section to the right, you can add in In-App Filter, which creates a familiar arrow-shaped three-bar button to the right of the search bar. I've added Quadrant and Category filters. If I want to go further here, it's on me and my spreadsheet. Open on Mondays? Offers pick-up? Has a bar? The possibilities are endless, even if my weekend spreadsheet time is not.

What happens when you click on a restaurant? Right now, you see, essentially, a vertical readout of everything in that spreadsheet row. What could you see? Well, you've got an address there, so how about a map? Click on a restaurant in the fake phone, and on the left you can see "Components," one of which is our map. Set the address to equal the address column in your sheet, and, in "Options," set Visibility so that it only shows up when the address field is not empty. In "Actions," you can set it so that clicking the map opens the phone's default mapping app, set to the proper address. (If you're struggling to get the right place to show up, you might want to check out a sample address in Mapbox's API; it can be a little finicky about how it parses them.)

Glide offers dozens more ways to customize every little thing about your app. That's about all I need from a "mix up your takeout and use the right apps" app, one made mostly for me, my spouse, and nearby friends and visitors. Pretty much anything you'd find useful while sitting down at a spreadsheet, you can also make useful through a little phone webapp.

Joyful overkill

I went a good deal further with my "DIYRoot" app. After using a couple meal delivery services, I sussed out the kinds of recipe formulas they were mixing up each week, plus the items or equivalents I had found at nearby stores. Knowing that I could figure out the basic cooking, I made an app that listed as many recipes as I could find, broke them into components, let me add them to an erasable menu plan and shopping list, and even had some pictures.

I didn't quite master this app (the shopping list is plagued by blank items/rows), and it's now technically an outdated "Classic" Glide app; maybe I'll give it another shot. More successful is my most recent effort, "Pantry Items," which is just a searchable list of spices and sauces, a note about how much I have left of each, and, through a webhook, add anything I see missing to a shopping list on Bring. I can feel some people reading this article demanding that I just learn Swift or some mobile-friendly JavaScript package and make some real apps, but I steadfastly refuse. I enjoy the messy middle of programming, where I have just enough app, API, and logic knowledge to make something small for my friends and family that's always accessible on this little computer I carry everywhere, but I have no ambitions to make it "real." Anyone can add to it through the relatively simple spreadsheet. Heck, I'll even take feature requests if I'm feeling gracious. I use Glide, but you might have something else even simpler (and should recommend it as such in the comments). Just be warned that once you start thinking (or overthinking) along these lines, it can be hard to stop, even without the worldwide pandemic.