The average small business uses between 40 and 70 SaaS applications. Each one has a copy of your data. Each one has different security policies, different breach histories, different data retention rules, and a different answer to the question "what happens to my data if you shut down?"
Most founders don't think about this until something goes wrong. A vendor gets breached. A tool sunsets with 30 days' notice. An acquisition changes the terms of service. Then suddenly the question isn't "how do I export my CRM data?" It's "where does all our data even live?"
The Real Cost of SaaS Sprawl
The subscription cost is the number everyone tracks. For a 10-person team, that's typically $10,000–30,000 per year across CRM, email marketing, project management, invoicing, analytics, support, and file storage.
The hidden costs are worse:
- Data fragmentation. Customer information lives in 7 different tools. No single source of truth. When marketing says you have 4,200 contacts and sales says 3,800, both are right in their respective silos.
- Duplicate data entry. A new lead comes in through your form. Someone enters it in the CRM. Someone else adds it to the email list. The project manager creates a card. That's 3 manual entries for one event.
- Inconsistent reporting. Revenue in Stripe doesn't match revenue in QuickBooks doesn't match revenue in your CRM. You spend Friday afternoons reconciling numbers instead of making decisions.
- Integration tax. Connecting tools requires Zapier ($20–200/month), Make, or custom APIs. Each integration is a potential failure point that breaks silently.
Where Your Data Actually Lives
Map your typical stack and count the companies with your customer data:
That's 7 companies with your customer data. Seven different security teams. Seven different privacy policies you agreed to without reading. Seven attack surfaces.
The Breach Math
Each SaaS tool in your stack is an attack surface. The probability that at least one of them gets breached in any given year is higher than you'd like to think.
If each tool has a 3% annual breach probability (conservative for SaaS), and you use 7 tools with customer data, the probability that at least one gets breached in a year is:
1 - (0.97)^7 = 19.3%
Nearly 1 in 5. Every year. And that's with generous assumptions. The real breach rate for SaaS companies is higher, especially for startups that move fast on features and slow on security.
Google Sheets as the Consolidation Layer
The argument isn't that Google Sheets is the most powerful database. It's that for businesses doing under $20M in revenue, the consolidation benefits outweigh the limitations.
Here's what consolidation looks like:
- ONE platform (Google Workspace) instead of 7 vendors
- ONE set of permissions managed through Google Admin
- ONE audit trail showing who accessed what, when
- ONE export if you ever need to move
You pull data from external APIs into Sheets via Apps Script. Shopify orders, Stripe payments, ad spend, all flowing into structured tabs on a schedule. Your dashboards, CRM views, and reports are formula-driven layers on top of that data.
function syncStripePayments() {
const key = PropertiesService.getScriptProperties()
.getProperty('STRIPE_KEY');
const res = UrlFetchApp.fetch(
'https://api.stripe.com/v1/charges?limit=100', {
headers: { 'Authorization': 'Bearer ' + key }
});
const charges = JSON.parse(res.getContentText()).data;
const sheet = SpreadsheetApp.getActive()
.getSheetByName('_stripe_raw');
charges.forEach(charge => {
sheet.appendRow([
new Date(charge.created * 1000),
charge.customer,
charge.amount / 100,
charge.currency,
charge.status,
charge.description || ''
]);
});
}
The Objections, Addressed
"Sheets can't handle big data"
Google Sheets supports up to 10 million cells per spreadsheet. For a business tracking 50,000 customers with 20 data points each, that's 1 million cells, just 10% of capacity. You can run a multi-million dollar business in Google Sheets without hitting limits. If you do outgrow it, BigQuery is the natural next step, and Sheets connects to it natively.
"It's not a real database"
Correct. It's not. For 90% of businesses under $20M, it doesn't need to be. You don't need ACID transactions, referential integrity constraints, or sub-millisecond query times to track 500 active deals and generate monthly reports. You need a tool your team will actually use, and everyone already knows how to use Sheets.
"What about backups?"
Google Sheets has built-in version history going back indefinitely for Workspace accounts. Every edit is tracked. You can restore any previous version. Additionally, Apps Script can automate weekly backups to Google Drive as Excel files.
"Isn't Google also a third party?"
Yes. But the difference between trusting Google's infrastructure (SOC 2, ISO 27001, $300B+ market cap, 15+ years of enterprise track record) versus trusting a Series A startup with 30 employees is significant. You're reducing from 7 trust relationships to 1, and that 1 is the most battle-tested infrastructure provider in the world.
What Consolidation Actually Saves
- Direct SaaS cost: $8,000–24,000/year in eliminated subscriptions
- Integration cost: $2,000–5,000/year in Zapier/Make fees and maintenance
- Time cost: 5–15 hours/week of manual data reconciliation eliminated
- Risk cost: 7 attack surfaces reduced to 1
The one-time cost to build consolidated systems in Google Sheets typically runs $5,000–15,000. Most businesses break even in 3–6 months and save $20,000+ per year after that.
The question isn't whether you can afford to consolidate. It's whether you can afford not to, when your data is scattered across 7 companies you don't control.