cotera

Apollo to HubSpot Pipeline Builder

Find your ideal prospects in Apollo and push them straight into HubSpot as contacts and deals. No CSV exports, no manual entry.

Pipeline generationICP targetingCRM automationOutbound prospecting

The Challenge

You know your ICP. You know who you want to sell to. But the process of searching Apollo, copying data, switching to HubSpot, creating contacts, and setting up deals eats hours every week. Most of it is mechanical — the kind of work that should happen automatically.

What This Prompt Does

Find Target Companies

Search Apollo for orgs matching your ICP filters

Identify Decision Makers

Find the right people by title and seniority

Enrich & Verify

Get verified emails and full profile data from Apollo

Push to HubSpot

Create contacts and deals in your CRM automatically

The Prompt

The Prompt

Task

Use @Apollo/Search OrganizationsName it "Apollo/Search Organizations" and call it with @Apollo/Search Organizations to find companies matching a target profile, then @Apollo/Search PeopleName it "Apollo/Search People" and call it with @Apollo/Search People to find decision makers at those companies. Enrich each person with @Apollo/Enrich PersonName it "Apollo/Enrich Person" and call it with @Apollo/Enrich Person, then create contacts in HubSpot with @HubSpot/Create ContactName it "HubSpot/Create Contact" and call it with @HubSpot/Create Contact and deals with @HubSpot/Create DealName it "HubSpot/Create Deal" and call it with @HubSpot/Create Deal.

Example: Find VP-level marketing leaders at Series B SaaS companies with 50-200 employees, enrich them, and add them to HubSpot as new deals.

Input

The user will describe their ideal customer profile (ICP) including any combination of:

  • Industry or keywords
  • Company size (employee count)
  • Funding stage
  • Job titles or seniority levels
  • Location

Example: "Find CTOs at fintech startups in New York with 20-100 employees"

Context

Search Strategy

  1. Use Apollo Search Organizations to find companies matching size, industry, and funding filters
  2. For each matching company, use Apollo Search People to find contacts with the right titles and seniority
  3. Enrich each person to get verified emails and full profile data
  4. Create a HubSpot contact for each enriched lead with all available fields
  5. Create a HubSpot deal linked to the contact for pipeline tracking

What Fields to Map

Apollo to HubSpot contact:

  • First name, last name, email
  • Job title, company name
  • Phone number, LinkedIn URL
  • City, state, country

HubSpot deal fields:

  • Deal name: "[Contact Name] - [Company Name]"
  • Pipeline stage: Set to first stage (e.g., "Prospecting")
  • Deal amount: Leave blank unless user specifies
  • Source: "Apollo Prospecting"

Quality Checks

  • Only create contacts with verified or likely email status
  • Skip duplicates — note if a contact already exists in HubSpot
  • Flag any contacts missing critical fields (no email, no title)
  • Report how many leads were found vs. how many were added

Output

Search Summary:

  • Companies found matching ICP: [count]
  • Decision makers identified: [count]
  • Contacts with verified emails: [count]

Contacts Created in HubSpot: | Name | Title | Company | Email Status | Deal Created | |------|-------|---------|-------------|-------------| | [Name] | [Title] | [Company] | Verified/Likely | Yes/No |

Skipped Contacts: List any contacts skipped and why (no email, duplicate, etc.)

Next Steps: Suggestions for follow-up sequences or outreach.

Example Usage

Try asking:

  • →"Find VPs of Marketing at Series B SaaS companies and add them to HubSpot"
  • →"Build pipeline from fintech startups in NYC with 50-200 employees"
  • →"Search Apollo for engineering leaders at AI companies and create HubSpot deals"