• Home

  • Productivity

  • App tips

App tips

5 min read

Why you should use Google Sheets as your browser homepage

How to create a custom browser homepage with Google Sheets

By Tyler Robertson · February 12, 2021
A hero image of Tyler's Google Sheets browser homepage

In the before-times, when I shared an office with other people, I used to be jealous of the "new tab" screens and plugins that my coworkers had. Every time they opened a new browser window, there'd be a big calendar, or a to-do list, or a motivational quote, or a picture of their cat/dog/turtle. But I couldn't bring myself to pick one for my own browser because there was always something missing or something annoying that I couldn't change. I wanted my homepage to be completely custom—and do all of those things. 

So I made my own with Google Sheets, and I think you should too. 

When you're ready to start using your spreadsheet on a daily basis, here's how to update your homepage in Google ChromeSafariFirefox, and Microsoft Edge.

Why Google Sheets?

I've said it before, and I'll say it again: spreadsheets are great. 

They're useful for storing and analyzing data, collecting form submissions, even playing games if you're feeling adventurous. They make it easy to collect, rearrange, and edit any content you want. And not enough people use them in their daily lives. 

If you don't believe me, here's a template homepage that I made just for you.

If you're looking for a new homepage or want to spice up spreadsheets that you're already looking at every day, here are a few things that every good homepage spreadsheet needs.

Distinct spaces

Something that I don't think enough people appreciate is that a spreadsheet doesn't have to be all one thing. Just because rows 1 through 5 are about your tax returns, there's no law saying the rest can't be links to Star Wars memorabilia that you're tracking on eBay (so long as you don't get the two mixed up). There are a few ways to do this in Google Sheets, but I recommend using either worksheets or merged cells.

Worksheets are entirely separate spreadsheets that you can access via the tabs at the bottom of the page. You can make new ones by duplicating an existing worksheet, or using the + button.

Arrows pointing to the worksheets tabs in Google Sheets

I like having one worksheet for all the stuff I want to look at, and another one for everything I want to hide or ignore for now.

The other method is merging cells. In the template I linked to above, you'll notice that I made the columns much thinner than usual, turning the cells into little squares (you can't see them because I set their border color to white). By selecting a group of them anywhere in the spreadsheet, I can click the Merge button to turn them into a larger rectangle, creating a distinct space for whatever I need.

An area of a spreadsheet selected with an arrow pointing to the merge cells shortcut

You can also click the dropdown menu next to the Merge button and merge cells vertically or horizontally to create rows or columns in the middle of the sheet. 

A to-do list

At Zapier, we've written a lot about the best way to keep a to-do list—it's something we're fervently passionate about. Personally, I always go back to Deb's guide on making a to-do list in Google Sheets. But for my own purposes, I find that having fewer tasks helped me focus and prioritize better (and I'm not alone). So while I've kept the conditional formatting and general concept of Deb's to-do list, I've narrowed it down to things I need to do Today, Tomorrow, and the nebulous "Eventually."

A to-do list with three sections in Google Sheets

The important thing about having a to-do list in a spreadsheet is to remember that it's yours: you can edit and rearrange it at any time to fit your needs. So long as you can write something down and check it off, you're golden.

A notepad

I like to have a spot for random, temporary notes, to keep track of things that aren't necessary to-do items. For mine, I selected a group of cells and used the Merge button to merge cells horizontally, creating a small notebook-looking section along the left-hand side of my spreadsheet.

A notepad section in Google Sheets

The current date/time

This may be my pandemic-brain kicking in, but it's increasingly hard to keep track of what day it is, so I try to display it everywhere I can. 

This can be done with something as simple as the NOW() formula. Inspired by work from Ben Collins and Robin Lord, I've added some conditional formatting to my spreadsheet, so certain cells turn blue depending on what day/time it is, creating a digital clock in the corner. 

The day and time appearing in Google Sheets

You can make sure the time stays current by going to File > Spreadsheet settings > Calculation, and setting Recalculation to On change and every minute. That way, each minute, the spreadsheet will refresh itself and change the clock accordingly.

The spreadsheet settings in Google Sheets

Useful information

It's always good to stay up to date on things like the news, weather, or useful productivity tips from your favorite automation platform. Google Sheets gives you a few tools to do that, such as the IMPORTFEED() and IMPORTXML() formulas, which help you import data from other sites and display it in the sheet.

For my spreadsheet, I import the latest post from the Zapier blog using the IMPORTFEED() formula. You can sub in any news or quote-of-the-day feed you prefer, but why would you?

A link to the latest blog article from Zapier in a spreadsheet

Something fun

There's a part of me that misses the days of procrastinating with games like Solitaire or SkiFree. To recreate that, I added a simple game of Minesweeper, to help pass the time when it's quiet.

Minesweeper in Google Sheets

Something nice to look at

You don't usually think of "spreadsheets" and "nice to look at" in the same sentence, and I'm on a personal quest to change that.

First, you can change your font and font size, which helps a lot. I do that by clicking the space in the top-left corner, which selects all cells, so that I can update their font all at once.

Changing the font in Google Sheets

I'm a big Open Sans fan myself, but who knows? You may want a Comic Sans homepage. There's no accounting for taste.

You can also select a cell and use the Insert menu to drop in images or drawings, to give the page some personalized flair. 

Inserting an image in Google Sheets
A picture of a dog in the spreadsheet

Make it work for you!

Whether you use a template or start from scratch, making a spreadsheet is all about making something that works for you, meaning you're free to change things up whenever and however you want. This is the one time that you get to make a spreadsheet that won't be shown to management, so go wild.

And when you're ready to take your Google Sheets skills to the next level, we have a lot more resources for you to check out. 

  • 6 ways to automate Google Sheets

  • How to send an email when updates are made to Google Sheets rows

  • How to create Google Calendar events from a Google Sheets spreadsheet

  • 6 Google Sheets functions that do more than math

Get productivity tips delivered straight to your inbox

We’ll email you 1-3 times per week—and never share your information.

tags
mentioned apps

Related articles

Improve your productivity automatically. Use Zapier to get your apps working together.

Sign up
See how Zapier works
A Zap with the trigger 'When I get a new lead from Facebook,' and the action 'Notify my team in Slack'