Import recently funded companies from Crunchbase into HubSpot using Make

Prerequisites

Why Make?

Make is a visual, no-code automation platform where you build workflows by connecting modules on a canvas. For this recipe, the Iterator module handles looping through funding rounds, the Filter module applies ICP criteria, and the HubSpot module creates companies — all without writing code.

The key advantage is that the entire flow is visible at a glance: you can see each step, inspect intermediate data, and debug by clicking on any module to see its input and output. The trade-off is that Make charges by operations (each module execution = 1 op), so high-volume runs cost more than n8n self-hosted or a cron script. For weekly imports of 50-100 funded companies, the cost is manageable on the Core plan.

Step 1: Add a scheduler trigger

Create a new scenario and add a Scheduler module. Set it to run daily or weekly depending on how frequently you want new funded companies imported.

Step 2: Search Crunchbase for recent funding rounds

Add an HTTP → Make a request module:

• URL: https://api.crunchbase.com/api/v4/searches/funding_rounds
• Method: POST
• Headers: X-cb-user-key: YOUR_CRUNCHBASE_API_KEY, Content-Type: application/json
• Body:

{
  "field_ids": [
    "identifier",
    "announced_on",
    "money_raised",
    "funded_organization_identifier",
    "investment_type",
    "investor_identifiers"
  ],
  "query": [
    {
      "type": "predicate",
      "field_id": "announced_on",
      "operator_id": "gte",
      "values": ["{{formatDate(addDays(now; -30); "YYYY-MM-DD")}}"]
    },
    {
      "type": "predicate",
      "field_id": "investment_type",
      "operator_id": "includes",
      "values": ["series_a", "series_b", "series_c"]
    }
  ],
  "limit": 100
}

Step 3: Iterate through funding rounds

Add an Iterator module and set the array to the entities field from the Crunchbase response.

Step 4: Fetch organization details

Inside the iterator, add another HTTP module:

• URL: https://api.crunchbase.com/api/v4/entities/organizations/{{3.properties.funded_organization_identifier.uuid}}
• Method: GET
• Headers: X-cb-user-key: YOUR_CRUNCHBASE_API_KEY
• Query String: field_ids=short_description,categories,location_identifiers,num_employees_enum,website_url

Step 5: Filter for ICP matches

Add a Filter between the organization fetch and the next module:

• Condition 1: website_url → Text operators → Is not empty
• Condition 2: num_employees_enum → Text operators → Matches pattern → c_005|c_010|c_025 (adjust for your target company size)

Step 6: Check for existing companies in HubSpot

Add an HTTP module to search HubSpot by domain:

• URL: https://api.hubapi.com/crm/v3/objects/companies/search
• Method: POST
• Headers: Use HubSpot connection
• Body:

{
  "filterGroups": [{
    "filters": [{
      "propertyName": "domain",
      "operator": "EQ",
      "value": "{{replace(replace(replace(4.properties.website_url; "https://"; ""); "http://"; ""); "www."; "")}}"
    }]
  }]
}

Add a Filter: continue only if total equals 0.

Step 7: Create company in HubSpot

Add a HubSpot CRM → Create a Company module:

• Name: {{4.properties.identifier.value}}
• Domain: {{4.properties.website_url}}
• Industry: {{4.properties.categories[0].value}}
• Description: {{4.properties.short_description}}

For the custom funding properties, use the Additional Fields section:

• funding_stage: {{3.properties.investment_type}}
• funding_amount: {{3.properties.money_raised.value}}
• funding_date: {{3.properties.announced_on}}
• investors: {{join(map(3.properties.investor_identifiers; "value"); ", ")}}

Step 8: Activate

1. Run the scenario manually to verify results
2. Check that companies appear in HubSpot with funding data populated
3. Set the schedule and toggle to Active

Common questions

How many Make operations does each company use?

Each funding round that passes the ICP filter uses ~4 operations: iterate (1) + fetch organization details (1) + search HubSpot for duplicates (1) + create company (1). Rounds that fail the ICP filter use ~3 ops (no HubSpot create). Processing 50 funded companies that all pass ICP = ~200 ops.

Can Make handle Crunchbase pagination (100+ results)?

Not natively in a single HTTP module. If you expect more than 100 funding rounds per run, add a Repeater module that calls the Crunchbase search with incrementing after_id values until fewer than 100 results are returned. For most weekly runs, 100 is more than enough.

What happens if the scenario fails mid-run?

Make saves the state of each module execution. If a module fails (e.g., HubSpot rate limit), Make marks that execution as incomplete. You can retry failed executions from the scenario history. Companies already created before the failure won't be duplicated thanks to the domain dedup check.

Is the Free plan enough for this recipe?

For small volumes, yes. The Free plan includes 1,000 ops/month. If you run weekly and process ~30 funded companies per run, that's ~120 ops/week or ~480 ops/month. If you process more or run daily, you'll need the Core plan ($10.59/mo for 10,000 ops).

Cost

• Free plan: 1,000 ops/month. Each company = ~4 ops (iterate + org fetch + search HubSpot + create). Processing 50 funded companies = ~200 ops.
• Core plan: $10.59/mo for 10,000 ops. Handles ~2,500 companies/month.
• Crunchbase API: Enterprise plan required. Contact Crunchbase sales for pricing.