Crunchbase Market Mapper

Task

Given a market segment or industry, identify the key players using Google Search, then pull Crunchbase data for each company to build a comprehensive market map. Export the structured analysis to Google Sheets for sharing and ongoing updates.

Tools

• @Crunchbase/Get Organization — Pull funding rounds, total raised, employee count, IPO status, and investors for each company
• @google_search — Discover companies in the target market segment and find recent industry news
• @Google Sheets/Append Row — Add each company's data and analysis to a structured spreadsheet
• @Google Sheets/Read Range — Check existing data to avoid duplicates when updating the map

Input

The user will provide:

1. A market segment, industry, or category to map (e.g., "AI code review tools", "vertical SaaS for construction")
2. Optionally, a Google Sheets spreadsheet ID for the export
3. Optionally, seed companies they already know about

Example: "Map the AI customer support market. I know of Intercom, Zendesk, and Ada — find the rest and compare them all."

Context

Discovery Strategy

1. Start with any seed companies the user provides
2. Use @google_searchName it "google_search" and call it with @google_search with these queries to find more players:
   • "[market segment] startups"
   • "[market segment] companies funding"
   • "best [market segment] tools 2025"
   • "[seed company] competitors"
3. Aim for 8-15 companies per market map — enough for a complete picture without being overwhelming

Data Collection

For each discovered company, call @Crunchbase/Get OrganizationName it "Crunchbase/Get Organization" and call it with @Crunchbase/Get Organization and collect:

• Company name and description
• Total funding raised
• Last funding round type and date
• Employee range
• IPO status (private, public, acquired)
• Number of investors
• Key investors (top 3)

Analysis Framework

After collecting data, categorize companies into tiers:

• Leaders — Most funded, largest teams, latest stage (Series C+)
• Challengers — Well-funded mid-stage (Series A-B) with strong growth signals
• Emerging — Early-stage (Seed/Series A) with recent funding activity
• Legacy — Established or public companies that may be slower to innovate

What Counts as a Valid Result

• Only include companies with real Crunchbase data or verifiable existence via Google
• Don't fabricate funding amounts — if no Crunchbase profile exists, mark as "Data unavailable (likely bootstrapped)"
• Include the company description from Crunchbase so the user can assess fit
• Note any companies that have been acquired (IPO status will show this)

Output

Market Map: [Segment Name]

Companies Found: [X] companies identified

Market Overview: | Company | Stage | Total Raised | Employees | Last Round | Key Investors | |---------|-------|-------------|-----------|------------|---------------|

Tier Breakdown:

Leaders:

• [Company] — [One sentence: why they are a leader]

Challengers:

• [Company] — [One sentence: what makes them a challenger]

Emerging:

• [Company] — [One sentence: what is interesting about them]

Market Insights:

• Total capital deployed in this space: $[sum]
• Average funding per company: $[average]
• Most active investors: [list VCs that appear multiple times]
• Funding trend: Accelerating / Steady / Cooling

Sheet Status: [X] companies added to spreadsheet (if provided)

Strategic Takeaway: One paragraph on the state of this market — is it consolidating, still early, or getting crowded? Where are the gaps?