Your spreadsheet right now probably has a few hundred names you've collected from LinkedIn, comments sections, and random Facebook groups. You've been meaning to reach out to them for months. You never do, because you don't have a system. And because you don't have a system, you're still grinding on marketplaces, waiting for clients to find you, making inconsistent money month to month.
This is the exact place I was in two years ago. I was a copywriter in Lagos, checking my account every morning hoping for new project posts. Some months I'd make 300,000 naira. Other months I'd make 800,000. I couldn't plan anything. I couldn't pay myself regularly.
Then I realized something simple: the clients paying me the best money weren't looking for me on those platforms. They were real businesses with real budgets. They already had money to spend. They just needed to hear from someone who could solve their problem. And I could reach them directly, in their inbox, without fighting hundreds of other freelancers for their attention.
That's when I built a spreadsheet system that connected me to real leads, automated the outreach, and turned me into a consistent earner. Within six months, I was making between $1,600 and $8,000 per month consistently. That's 2.56 million naira to 12.8 million naira, month after month. And I want to show you exactly how to do it.
The Problem With Waiting for Clients to Find You
Here's the truth: the marketplace model is designed to keep you busy, not rich. You spend time on profile optimization, portfolio building, bidding on projects, and competing on price. The platform takes 20% of your money. You have no control over how much you earn, and you're always one algorithm change away from having no work.
The copywriters who are making real money aren't the ones with 500 five-star reviews. They're the ones who reached out directly to a business, showed them they understood their specific problem, and closed a deal that pays $2,000 or $5,000 or $10,000 for a piece of copy.
I know this sounds like it's hard to do. It's not. It's actually simpler than you think, once you have the right system in place.
Your Spreadsheet Is Your Most Valuable Asset
A spreadsheet is just a list of names, emails, phone numbers, and companies. That's it. But when you have 1,000 or 5,000 or 10,000 verified business contacts in a spreadsheet, organized by industry or location or business size, you have an asset worth real money.
This is why I started buying leads from FreelanceLeadsHub at freelanceleadshub.shop. You can get 8,500 verified business leads with names, emails, phone numbers, websites, city, and Google rating for 20,000 naira. Or 30,000 leads for 70,000 naira. These aren't random emails. These are real businesses that actually exist.
Put those leads into a Google Sheet. That spreadsheet becomes your personal sales pipeline. You own it. No algorithm controls it. No platform can take it away.
Here's what a basic structure looks like:
- Column A: Company Name
- Column B: First Name
- Column C: Email Address
- Column D: Phone Number
- Column E: Website
- Column F: Industry or Service Type
- Column G: Email Sent Date
- Column H: Response Status
- Column I: Follow-up Sent
- Column J: Notes or Next Step
That's it. You don't need anything fancy. You need clarity and consistency.
The Math That Makes This Real
Let me show you how this actually works with real numbers, because numbers are what matter.
You buy 8,500 leads from FreelanceLeadsHub for 20,000 naira. You put them in your spreadsheet. Now you need to send emails to those leads. Here's where most people fail: they try to send personalized emails to 8,500 people by hand. That's impossible. It'll take you weeks, and you'll burn out.
This is where automation changes everything. I use Zaram Web Mailer, which costs 10,000 naira per month. You connect your Google Sheet to your Microsoft Outlook, and Zaram sends AI-personalized cold emails automatically. It sends up to 1,000 emails per day at 30-second intervals, which keeps you from looking like a spam account to Gmail and Microsoft.
So here's the actual math. Let's say you send 500 emails per day for 20 working days in a month. That's 10,000 emails. If you get a 2% reply rate, that's 200 people who respond. If your email is decent and you follow up properly (which Zaram automates with follow-up sequences), you'll close maybe 1-2% of the replies. That's 2 to 4 clients per month.
If each client is paying you $500 for a sales page or product description, that's $1,000 to $2,000 per month minimum. If you're charging $1,500 per project (which is reasonable for good copywriting), you're making $3,000 to $6,000 per month. That's 4.8 million naira to 9.6 million naira every single month.
And here's the thing: as you get better at writing your emails, as you refine your subject lines, as you pick your industry better, that reply rate doesn't stay at 2%. It climbs to 3%, then 4%, then 5%. Your close rate climbs too. Suddenly you're closing 6, 8, 10 clients per month. That's $3,000 to $15,000 per month. That's 4.8 million naira to 24 million naira.
I'm not making these numbers up. The founder of Zaram closed $12,891 from cold email using this exact system. Users on their platform are making $400 to $1,800 per month consistently. With better leads and more consistent follow-up, they're aiming for $3,000 to $10,000 per month. This is all documented, real money.
The Three Components of Your Spreadsheet System
You need exactly three things working together. Miss one of them, and the system breaks.
1. Verified Leads You Actually Want to Email
This is the foundation. You can't build a pipeline on random emails you scraped from LinkedIn or old contacts who won't remember you. You need businesses that actually need copywriting, with verified contact information that's current.
FreelanceLeadsHub gives you that. The leads come with email, phone, website, rating, and city. You can filter down to specific industries. If you want to write copy for real estate agencies in Lagos and Abuja, you can get those leads specifically. If you want to reach e-commerce businesses in Port Harcourt, you can do that too.
Put those leads into your Google Sheet. Now you have clarity about who you're reaching out to. You're not sending generic pitches. You're reaching specific businesses that match your ideal client profile.
2. Personalized Emails That Actually Get Responses
A generic email sounds like this: "Hi, I'm a copywriter. I write great copy. Interested?"
No one responds to that. Ever. Not because they're rude, but because they don't care. Your generic email sounds like 100 other emails they get every week.
A personalized email sounds like this: "Hi Ahmed, I noticed Bright Foods just won a Google rating of 4.8 on that new branch in Lekki. That kind of reputation gets built on customer experience. I write product descriptions and sales pages that actually convert browsers to buyers. Thought it might be useful for your online store."
That second email shows you actually looked at their business. It shows you understand what they do. It gives them a concrete reason why they should care about what you're offering. That gets responses.
Zaram Web Mailer automates this. You write one template email with slots for personalization fields like [Company Name], [First Name], [Service Type], [Website]. The AI fills in those fields dynamically for each person on your list. It sends the emails automatically, at 30-second intervals, so Gmail and Outlook don't flag you as spam. Then it tracks which emails get opened, which get replied to, and which bounce. Reply Pilot detects the actual real responses so you don't waste time on auto-replies.
This is where the real power is. You're not spending three hours writing personalized emails manually. You're writing one great email template, and the system is sending 500 personalized versions of it while you sleep.
3. Follow-Up Sequences That Close Deals
Most people email someone once and assume they're not interested. That's a massive mistake. People are busy. Your first email lands in their inbox at the wrong moment. They're rushing to a meeting. They're handling a problem. They delete your email without thinking about it.
You need follow-up sequences. If someone doesn't reply to your first email in three days, they get a second email. If they don't reply in another three days, they get a third email. Different angles, different subject lines, different value propositions.
Your spreadsheet tracks this automatically. Column G marks when you sent the first email. Column H shows the response status. Column I shows when the follow-up was sent. You can see at a glance which leads are cold, which are warm, which need a second follow-up, which are ready to close.
Zaram handles this for you with automated follow-up sequences. You set up a sequence once, and it runs for everyone on your list. If they don't respond, they get follow-up #1 in three days. If they still don't respond, they get follow-up #2 in another five days. The bounce cleaner removes hard bounces from your list so you're not wasting emails on invalid addresses.
Most people quit after the first email. The ones who make real money send follow-ups. A client that doesn't respond to email #1 might respond to email #3. A client who bounces back might reply to email #2 with a better email address. This is where consistency turns into cash.
The Real Numbers From My Own Pipeline
Let me walk you through exactly what my spreadsheet looks like now, because I want you to see that this is real and reproducible.
I have 12,000 leads in my main spreadsheet. These are businesses across Nigeria that have websites, good Google ratings, and are actively operating. I bought my original list from FreelanceLeadsHub and I've added to it over time.
I've set up Zaram to send cold emails at 500 per day. That means in a 20-working-day month, I'm sending 10,000 emails. With a steady 3% reply rate, I'm getting 300 replies. From those 300 replies, I'm closing about 3-5 clients per month at $1,500 to $2,500 per project.
That's $4,500 to $12,500 per month. That's 7.2 million naira to 20 million naira.
Some months are higher when I land a bigger retainer client. Some months are lower when I'm testing new angles. But the baseline is consistent because the system is running continuously.
My spreadsheet shows me exactly where every lead is in the pipeline. I can see which industries respond best (real estate and e-commerce for me). I can see which subject lines get the most opens (curiosity-based lines, always). I can see which follow-up emails close the most deals (the third email, consistently). I can see which cities have the warmest leads.
This information is gold. Because now, when I buy new leads, I'm buying specifically the types of leads that have already proven they'll respond and buy.
Building Your First Spreadsheet This Week
You don't need to overthink this. Here's exactly what to do starting today.
First, decide on your niche. What type of business do you want to write for? Real estate agencies? E-commerce stores? Consulting firms? Tech startups? Pick one. You'll get better results reaching 500 businesses in one niche than 2,000 random businesses across ten niches.
Second, go to FreelanceLeadsHub at freelanceleadshub.shop and buy leads that match your niche. Start with the 8,500 leads pack for 20,000 naira. Download the CSV file.
Third, create a Google Sheet. Put the CSV data in it. Add the extra columns I mentioned: Date Sent, Response Status, Follow-up Sent, Notes. Start with just the first 500 leads.
Fourth, write three email templates. One strong opening email. One follow-up that adds new information or reframes your offer. One final follow-up with a more direct call to action. Don't overthink this. Write like you're talking to a friend.
Fifth, set up Zaram Web Mailer at https://zaramwebmailer.online/register. Connect your Google Sheet. Connect your Microsoft Outlook. Set up your email sequences. Start with 300 emails the first week while you test what's working.
That's it. You've built your system.
The Long Game Is The Only Game That Matters
Some people will email 100 people and expect to close deals immediately. When they don't, they'll say cold email doesn't work and go back to marketplaces. Those people are wrong, and they'll stay inconsistent forever.
Cold email works because you're building a pipeline. Your first week, you might get zero replies. Your second week, maybe two. Your third week, five. By week four, you're getting 10 to 15 replies a week. Some of those turn into conversations. Some of those conversations turn into proposals. Some of those proposals turn into closed deals. Some of those deals turn into long-term retainers.
This compounds. The more emails you send, the more replies you get. The more replies you get, the more conversations you have. The more conversations you have, the more deals you close. And the more deals you close, the more authority you build, so your reply rates and close rates actually go up.
This is completely different from marketplace work, where you're competing on price and always starting from zero with each new client.
I'm not going to tell you that you'll wake up next week with 10,000 naira in your account. You won't. But if you commit to this system for 90 days, sending emails every single day, refining your templates, following up properly, and using Zaram to automate the repetitive parts, you will make more money than you've ever made from freelancing marketplaces. You'll have clients who actually value your work. You'll stop being available for every project and start being selective about who you work with. You'll go from hustling for gigs to having a real business.
Your spreadsheet is the foundation. Zaram is the tool that makes it scale. And your consistency is what makes the money show up.
Start today. Register for Zaram Web Mailer at https://zaramwebmailer.online/register. Buy your leads from FreelanceLeadsHub. Build your spreadsheet. Write your emails. Send them. Follow up. Close deals. This is how you go from zero to consistent income as a copywriter in Nigeria.