That Time I Ran My Business Using Nothing But Free Google Tools

I got my first freelance writing client in a pretty unconventional way. My parents used to bring me to work with them at a little print shop in Rhode Island. In a back office with wood-paneled walls, avocado-green shag carpet, and horrific fluorescent overhead lighting, I worked for the coolest lady in the whole world: the copywriter.

She made a very big impression on me, and she was amused that a 9-year-old was obsessed with writing. I was a lot like Harriet the Spy back then. I kept writing and showing up to “work” in the office with her for 10 years. In high school, when there was a lot to do, she’d casually loop me in. “You feel like writing this ad? I’ll give you $10.” It slowly turned into “I need you hourly, nights and weekends. You up to it?”

I was up to it.

When my dad’s friend told me he needed something written up, I had zero clue what to do. We made a verbal agreement; he paid me with a $50 bill, and that became my operational procedure for years. As I built up a portfolio of recurring clients, I realized I needed record-keeping, financial planning, and project management tools. It turns out keeping an entire business in your head gets a lot harder when you have more than one client and multiple assignments.

There wasn’t an all-in-one solution back then, and I wasn’t in a financial position to pay for a lot of software, so I did what I do best: I figured it out. If there isn’t a door, I find a window. If there ain’t one, then I make one.

So I started building my own business management tools using the free Google products I already used.

Over the years, as Google introduced new features, I kept improving them. What began as a few spreadsheets and reusable documents eventually became a surprisingly sophisticated little business operation.

And I still wasn't paying for anything.

Financial Tools: How Do You Manage Freelance Income and Taxes?

My original accounting system was pretty straightforward. Someone gave me money, and then I HAD money. That worked beautifully until there were several people who owed me money, invoices outstanding, and bills I needed to pay before any of them got around to paying me. I needed to know more than how much I was charging. I needed to know how much I'd actually collected, what I'd spent running the business, and how much of the money left over was really mine.

I did what most self-respecting nerds would do. I built a spreadsheet.

I built an invoice template so I could send clients something more professional than an email asking them to please give me money. Then I built trackers for invoices, payments, and expenses. I could look at my records and figure out how much I'd earned without digging through six months of emails and bank statements.

And then there were taxes.

Nobody was withholding income taxes from those client payments, which meant I needed to put money aside myself. A 30% reserve was a useful planning rule, though the actual amount depends on your income and tax situation. I also needed records of my earnings and deductible expenses to work out my estimated tax payments during the year.

The system grew into a way to manage the entire financial side of my business. The updated version even generates invoices, tracks receipts, and helps organize the information needed for quarterly tax planning.

A considerable improvement over a $50 bill in the pocket of my JNCOs.

Pipeline Tools: How Do You Find and Manage Freelance Clients?

I had another problem that wasn't immediately obvious when I started freelancing: doing the work and finding the work are two different jobs, and you have to control how much time each takes.

When you're busy with several clients, prospecting doesn't seem like a pressing issue. Until you finish everything on your plate and your stomach starts to growl. You always need work coming in, and you’re the one responsible for finding it.

I needed to keep track of people who might hire me, not just people who already had.

So I made a spreadsheet for prospective clients. I could record who I'd contacted, what we'd discussed, whether I'd sent a proposal, and when I needed to follow up. Nothing particularly revolutionary, but considerably more reliable than assuming I'd remember a conversation from three weeks earlier or rereading pages of handwritten notes looking for clues.

I didn't know it was called a CRM when I first needed one. I just knew I was tired of trying to remember who I was supposed to email.

The Paperwork: Work Agreement Templates, Proposal Templates, Client Onboarding, OH MY!

In a perfect world, people would always be direct and do what they say they will. In the real world, we sign contracts. I’m not a paralegal or an attorney, and I had no idea how to get my clients to sign anything. I researched what you need to include, what’s enforceable, and what you should keep a record of, and started writing my own templates.

I had to write great proposals to get clients. I had to establish the working terms. I needed a record of the client’s requirements and expectations as well as my boundaries.

Pricing needed its own system, too. There's a difference between charging what someone offers you and figuring out what your work is actually worth. Experience, research, time, expenses, client expectations, and the value of what you're producing all matter. You have to balance remaining competitive, staying within market standards, and charging what you’re actually worth.

Eventually, those tools gave me a way to manage the whole process, from finding a potential client to agreeing on the price and getting the work started.

Productivity Tools: How Do You Keep Everything Moving?

Once you get the client, it’s tempting to congratulate yourself on a job well done, but the job itself is only just beginning. It was too easy for work to disappear in my inbox if I wasn’t tracking it. Google Calendar became my scheduling system. Google Docs handled the actual writing and collaboration. Spreadsheets became editorial calendars, project trackers, and checklists.

I also started making templates for anything I found myself doing repeatedly. If every new client needed the same basic information, why was I asking the questions from scratch? If every article went through a similar production process, why was I relying on my memory to make sure I hadn't skipped something? I made SME interview templates, email templates, anything and everything I could standardize; I did.

The more I could organize ahead of time, the less I had to think about the administrative side of the business while I was actually working.

I Rebuilt the Whole Thing. You Can Have It.

In writing a piece about my earlier career, I referenced something in one of these old spreadsheets and nostalgia got me poking around. I got a little distracted and started “fixing” the spreadsheets themselves. I probably lost a good hour of my day updating a system I have largely replaced, and I realized…I kind of like my old system better. Just with a few updates.

I added things I wish I'd had when I started: better financial dashboards, invoice generation, a rate-setting calculator, project and retainer agreements, client management tools, editorial workflows, and tax-planning resources. I thought, “I wish it was this good when I first started out.”

And I decided to put it out there for people who ARE just starting out. Because you probably know how to make a spreadsheet, but do you really want to? Or do you want to make a copy of mine and spend more time finding clients and doing work?

In this Google Drive folder you’ll find:

  • A complete business dashboard: One master Google Sheet with a deadline calendar, client pipeline chart, monthly revenue versus expenses, unpaid invoices, tax-reserve planning, and a weekly workload summary.

  • Financial management tools: An invoice generator, payment and expense trackers, receipt records, time logs, and quarterly estimated-tax planning tools.

  • A client relationship management (CRM) system: Track prospective clients, proposals, conversations, follow-ups, and potential revenue without trying to remember who you emailed three Tuesdays ago.

  • Project management and editorial tools: Content calendars, assignment trackers, production schedules, quality-control checklists, SEO performance reports, and experiment tracking.

  • Pricing tools: A rate calculator, quote builder, market research tracker, and client-facing rate card to help you figure out what to charge without pulling a number out of thin air.

  • All the paperwork: Client questionnaires, proposals, work agreements, content briefs, outreach emails, invoice correspondence, and guides to help you put everything together.

You can run everything from the master dashboard or use the individual tools separately. Make yourself a copy, change whatever you want, and put them to work.

The whole thing is free. The only thing you have to bring is the business.

Next
Next

That Time I Got Scammed Into Giving Away a Full SEO Strategy for Free