The Google Sheet That Can Run a Small Startup for Six Months
- 4 days ago
- 3 min read
There is a version of the small startup that thinks it needs to buy a proper CRM, a proper project management tool, a proper customer support system, and a proper analytics platform in order to feel legitimate.
There is another version, which is often the more successful one at the early stage, that runs most of the business out of a single Google Sheet for the first six months.
The second version is not less serious than the first, it is just clearer about what actually matters at this stage, and it saves the founder from spending money and attention on tools that will not pay for themselves until much later.
The purpose of this piece is to describe how the second version actually works, so that you can decide whether it fits your situation, and if it does, you can copy the structure directly rather than reinventing it.
The tabs the sheet needs
The single sheet should have five tabs, no more, and each of them serves a specific operational purpose. The first tab is a customer list, with columns for name, contact method, date of first conversation, status of the relationship, and notes from the most recent interaction. This tab replaces a CRM at your current volume, and it lets you see the state of every customer relationship at a glance.
The second tab is a deals or leads pipeline, with columns for the name of the potential customer, the source of the lead, the current stage, the value of the deal if it closes, and the next action you need to take. This tab is what tells you where to spend your time in any given week, since it makes the state of your potential customers visible at a glance.
The third tab is a task and priority tab, structured as a simple list of the things you need to do this week, this month, and this quarter. This tab is what a project management tool would give you at larger scale, and at your current scale a simple list is more than enough, since the overhead of a proper tool would take more time than it would save.
The fourth tab is a customer support log, with columns for the date of the request, the customer name, the description of the issue, the current status, and the eventual resolution. This tab makes patterns in customer complaints visible over time, which is often the single most valuable thing an early product team can see.
The fifth tab is a monthly numbers tab, with rows for the key metrics you want to watch over time, including revenue, customer count, active users, and any other numbers specific to your business. This tab is your dashboard at your current scale, and it produces most of the visibility you would otherwise pay a proper analytics tool for.
Download template
How to use it
The daily rhythm is that you open the sheet first thing in the morning and update whatever changed the day before. New customers get added to the customer tab. New leads get added to the deals tab. Completed tasks get marked off in the tasks tab. New support requests get logged in the support tab. This takes about five minutes when done consistently, and it produces a picture of the business that is more accurate than any tool because you are looking at it every day.
The weekly rhythm is that you spend twenty minutes on Friday updating the monthly numbers tab, so that you have a running record of how the business is changing over time. This rhythm produces the trend data that would take you months to build if you started using a proper analytics tool later.
When to graduate
The sheet works well up to a certain scale, and the signal that you have outgrown it is usually when you find yourself doing more than twenty updates a day, or when more than one person on your team needs to edit it at the same time, or when you cannot find the specific customer you are looking for without scrolling. These are honest signals, and when they show up you can graduate to a proper tool with confidence that you are doing so because the business actually needs it, not because someone told you that real startups use proper tools.
Until then, the sheet is enough, and the money you would have spent on the proper tools can go into something that actually moves the business forward, which is usually customer conversations, cost of goods, or a modest amount of experimental marketing.
Comments