Cold email asks for attention. The Trojan Spreadsheet earns it. Instead of approaching a prospect with a request, your time for my pitch, you approach them with a contribution: here’s something I built that’s relevant to your world, and I’d value your expertise on one element of it. The prospect opens the spreadsheet, finds it useful, and responds not to decline a sales pitch but to contribute to a collaboration. The conversation starts from a fundamentally different place.
The Psychology Behind the Approach
Reciprocity is one of the strongest psychological principles in sales. When you give someone something valuable before asking for anything, they experience a social obligation to engage, not out of manipulation, but because cooperative exchange is how trust-based professional relationships work.
The Trojan Spreadsheet operationalizes reciprocity at scale. The spreadsheet is a genuine piece of work, research, analysis, benchmarking, that the prospect would benefit from having. The comment access invitation turns a passive document into an active collaboration. The specific question (“I tagged you in column D because your recent announcement suggests your perspective here might differ from what the public data shows, am I reading that correctly?”) makes responding feel easy and intellectually engaging rather than transactional.
The result: reply rates in the 20–40% range compared to the 5–10% baseline for standard cold outreach. Not because the Trojan Spreadsheet is a trick, but because it leads with value rather than demand.
Building the Benchmark Spreadsheet: The Core Version
Step 1, Choose your 20 subjects. For most consultants, this means the prospect’s 20 closest competitors, peers, or industry comparables. Use LinkedIn, Crunchbase, G2, or industry directories to identify the right list. These should be companies the prospect is already aware of and cares about.
Step 2, Choose 4–5 evaluation dimensions. These should reflect your area of expertise. A marketing consultant might benchmark: website traffic, domain authority, social following, paid ad spend estimate, and content publishing frequency. A product strategist might benchmark: feature set depth, pricing tier structure, NPS scores from review sites, churn indicators, and customer segment focus.
Step 3, Populate with public data. Spend 60–90 minutes filling in the matrix with publicly available data. Leave a few cells intentionally incomplete or flagged with a question mark, these become your collaboration hooks.
Step 4, Add a “Your Company” row. Leave most cells blank or populated with publicly available data about the prospect. This is your most powerful hook, no executive can resist comparing themselves to their competitors.
The most effective Trojan Spreadsheets are incomplete by design. A fully populated, definitive research document invites passive reading. A 70%-complete document with flagged questions and a “Your Company” row with deliberate gaps invites active participation. The incompleteness makes the collaboration request feel natural rather than contrived, you genuinely need their input to finish what you started.
The Covering Email
The email sending the spreadsheet should be 80–100 words maximum:
“[Name], I’ve been building a benchmark of the top [industry] players on [4–5 dimensions], relevant to a project I’m working on. I included [prospect’s company] in the analysis and flagged a few places where I wasn’t sure if my interpretation of the public data was accurate.
[Link to Google Sheet, comment access enabled]
The ones I’ve tagged you on are in columns C and D. Would you add a comment if I’ve misread anything? Takes 5 minutes and I’ll share the full finished version when it’s done.”
Three Spreadsheet Variations
Variation 1, The Competitor Pricing Matrix: 20 competitors, columns for pricing tiers, contract length, key features included, and customer size targeting. Universally relevant for SaaS and professional services buyers.
Variation 2, The Hiring Signal Tracker: 20 companies in their space, columns for recent job postings in your relevant function, headcount growth over 90 days, and any announced expansion initiatives. Demonstrates market intelligence and signals that you track their competitive environment.
Variation 3, The Content Performance Benchmark: For marketing-focused prospects, 20 competitors with columns for monthly blog traffic (estimated via SimilarWeb), social engagement rate, email newsletter frequency, and topic coverage gaps. Immediately useful for any marketing leader evaluating their content strategy.
Managing Follow-Up Conversations
When a prospect comments on the spreadsheet, reply within 24 hours, in the document comments and by email. The combination reinforces the collaborative dynamic. Ask a follow-up question that deepens the conversation: “Thanks for that correction, does [company X] have a fundamentally different go-to-market approach that explains the pricing difference, or is this more about market positioning?”
After two to three comment exchanges, the transition to a call is natural: “This has been genuinely useful, I’m finishing up the analysis and would love to share the full findings with you. Any chance we could connect for 20 minutes? I think there are two areas where the data suggests an interesting opportunity for [prospect’s company] specifically.”
That’s not a cold call. It’s the next step in a collaboration you’ve both been contributing to. The selling, by the time you get there, is nearly finished.
