Apollo
A
Apollo

tap-apollo (meltanolabs variant)

Apollo.io is a sales intelligence and engagement platform. Teams use it to find and manage contacts and accounts, track deals, and run outreach sequences of emails, calls and tasks.

This tap extracts the records your team manages in Apollo, plus workspace reference data such as users, stages, lists and custom fields, through the Apollo REST API. It does not search or enrich Apollo's people and company database, so it uses no Apollo credits.

Prerequisites

API Key: In Apollo, go to Settings → Integrations → API and create an API key. Apollo API keys are scoped to the endpoints you choose when you create them, and a stream fails with a 403 error if the key can't call its endpoint. The simplest option is a master API key, which can call every endpoint. phone_calls always requires a master key. Otherwise, give the key access to the endpoint of each stream you select:

StreamEndpoint
contactsapi/v1/contacts/search
accountsapi/v1/accounts/search
opportunitiesdeals/api/v1/opportunities/search
tasksapi/v1/tasks/search
phone_callsMaster API key only
sequencesapi/v1/emailer_campaigns/search
emailer_messagesapi/v1/emailer_messages/search
usersapi/v1/users/search
email_accountsapi/v1/email_accounts/index
listsapi/v1/labels/index
custom_fieldsapi/v1/typed_custom_fields/index
contact_stagesapi/v1/contact_stages/index
account_stagesapi/v1/account_stages/index
opportunity_stagesdeals/api/v1/opportunity_stages/index

Available Streams

StreamDescriptionReplicationReplication KeyPrimary Key
contactsPeople your team has saved to ApolloIncrementalupdated_atid
accountsCompanies your team has saved to ApolloFull Table—id
opportunitiesDeals and their amounts, stages and outcomesFull Table—id
tasksTasks assigned to users, such as calls, emails and LinkedIn stepsFull Table—id
phone_callsCalls made or received through ApolloFull Table—id
sequencesOutreach sequences, with their engagement statisticsFull Table—id
emailer_messagesEmails created and sent by sequencesFull Table—id
usersUsers on your Apollo teamFull Table—id
email_accountsEmail inboxes linked to Apollo for sendingFull Table—id
listsLists of contacts, accounts or sequencesFull Table—id
custom_fieldsCustom field definitionsFull Table—id
contact_stagesStages a contact can be inFull Table—id
account_stagesStages an account can be inFull Table—id
opportunity_stagesStages of each deal pipelineFull Table—id

Limitations

  • 50,000 records per search. Apollo's search endpoints return at most 500 pages of 100 records. When a stream reaches that limit, the tap logs a warning and stops, so larger collections are not fully extracted.
  • Contacts are synced newest first. Apollo has no filter for records updated since a time, so the tap sorts contacts by updated_at, newest first, and stops at the bookmark. After the first sync, a run only reads the contacts that changed since the last one.
  • Rate limits. Apollo limits API calls per minute, hour and day, depending on your plan. The tap waits and retries when it is rate limited.
  • Fields with varying types are text. Some Apollo fields come back as different types from record to record, or are rarely set. These are loaded as text, with objects, lists, numbers and booleans stored as JSON (for example true or {"title": "CTO"}).
  • Statistics Apollo is still calculating are empty. A sequence's rates, such as its click rate, are empty until Apollo has calculated them, and are filled in on a later sync.

Data recovery / backfill

Only contacts keeps a bookmark between syncs: the latest updated_at it has loaded. Every other stream is full table and re-syncs completely on each run, so it needs no backfill.

To backfill or re-sync contacts, reset the pipeline state so the next sync starts again from Start Date, and clear or lower Start Date first if you need older contacts. Lowering Start Date alone has no effect once a bookmark exists. A full re-sync is still limited to the 50,000 most recently updated contacts.

The tables below list the main fields of each stream. Every stream has more fields; the full schemas are in the tap's catalog.

contacts

Supports incremental replication using updated_at.

FieldTypeDescription
idstringUnique contact identifier
first_namestringFirst name
last_namestringLast name
namestringFull name
titlestringJob title
emailstringEmail address
email_statusstringEmail verification status
linkedin_urlstringLinkedIn profile URL
account_idstringID of the contact's account
organization_idstringID of the contact's company in Apollo's database
organization_namestringCompany name
contact_stage_idstringID of the contact's stage
owner_idstringID of the user who owns the contact
label_idsarray[string]IDs of the lists the contact is on
sourcestringHow the contact was added
last_activity_datestringDate of the last activity with the contact
typed_custom_fieldsobjectCustom field values, keyed by custom field ID
accountobjectThe contact's account
created_atdatetimeCreation timestamp
updated_atdatetimeLast modification timestamp — replication key

accounts

FieldTypeDescription
idstringUnique account identifier
namestringCompany name
domainstringCompany website domain
phonestringCompany phone number
linkedin_urlstringLinkedIn company page URL
account_stage_idstringID of the account's stage
owner_idstringID of the user who owns the account
organization_idstringID of the company in Apollo's database
parent_account_idstringID of the parent account
num_contactsintegerNumber of contacts at the account
label_idsarray[string]IDs of the lists the account is on
sourcestringHow the account was added
last_activity_datestringDate of the last activity with the account
typed_custom_fieldsobjectCustom field values, keyed by custom field ID
created_atdatetimeCreation timestamp

opportunities

Deals.

FieldTypeDescription
idstringUnique deal identifier
namestringDeal name
account_idstringID of the deal's account
owner_idstringID of the user who owns the deal
amountnumberDeal amount, in the deal's currency
amount_in_team_currencynumberDeal amount, in your team's currency
currencyobjectDeal currency
opportunity_stage_idstringID of the deal's stage
stage_namestringName of the deal's stage
opportunity_pipeline_idstringID of the deal's pipeline
is_closedbooleanWhether the deal is closed
is_wonbooleanWhether the deal is won
closed_datestringExpected or actual close date
forecast_categorystringForecast category
sourcestringHow the deal was added
typed_custom_fieldsobjectCustom field values, keyed by custom field ID
created_atdatetimeCreation timestamp
stage_updated_atdatetimeWhen the deal last changed stage

tasks

FieldTypeDescription
idstringUnique task identifier
typestringTask type, e.g. action_item or linkedin_step_connect
statusstringTask status
prioritystringTask priority
titlestringTask title
notestringTask note
contact_idstringID of the related contact
account_idstringID of the related account
opportunity_idstringID of the related deal
user_idstringID of the user the task is assigned to
emailer_campaign_idstringID of the sequence that created the task
due_atdatetimeDue timestamp
completed_atdatetimeCompletion timestamp
skipped_atdatetimeWhen the task was skipped
created_atdatetimeCreation timestamp

phone_calls

FieldTypeDescription
idstringUnique call identifier
start_timedatetimeCall start time
end_timedatetimeCall end time
durationintegerCall duration in seconds
inboundbooleanWhether the call was inbound
statusstringCall status
from_numberstringCalling phone number
to_numberstringCalled phone number
contact_idstringID of the related contact
account_idstringID of the related account
opportunity_idstringID of the related deal
user_idstringID of the user who made or took the call
phone_call_outcome_idstringID of the call outcome
phone_call_purpose_idstringID of the call purpose
note_textstringCall notes
recording_urlstringURL of the call recording

sequences

Sequences (Apollo's API calls them emailer campaigns), with their engagement statistics.

FieldTypeDescription
idstringUnique sequence identifier
namestringSequence name
activebooleanWhether the sequence is active
archivedbooleanWhether the sequence is archived
num_stepsintegerNumber of steps
user_idstringID of the user who owns the sequence
label_idsarray[string]IDs of the lists the sequence is on
unique_scheduledintegerNumber of contacts with a scheduled email
unique_deliveredintegerNumber of contacts with a delivered email
unique_openedintegerNumber of contacts who opened an email
unique_repliedintegerNumber of contacts who replied
unique_bouncedintegerNumber of contacts whose email bounced
open_ratenumberOpen rate
reply_ratenumberReply rate
bounce_ratenumberBounce rate
created_atdatetimeCreation timestamp
last_used_atdatetimeWhen the sequence was last used

emailer_messages

Outreach emails created and sent by sequences.

FieldTypeDescription
idstringUnique email identifier
emailer_campaign_idstringID of the sequence
campaign_namestringName of the sequence
emailer_step_idstringID of the sequence step
contact_idstringID of the recipient contact
account_idstringID of the recipient's account
user_idstringID of the sending user
email_account_idstringID of the sending email account
statusstringSending status, e.g. failed
subjectstringEmail subject
from_emailstringSender email address
to_emailstringRecipient email address
to_namestringRecipient name
body_textstringPlain-text email body
due_atdatetimeWhen the email is or was scheduled to send
completed_atdatetimeWhen the email was sent
failed_atdatetimeWhen sending failed
failure_reasonstringWhy sending failed
not_sent_reasonstringWhy the email was not sent
created_atdatetimeCreation timestamp

users

Users on your Apollo team.

FieldTypeDescription
idstringUnique user identifier
namestringFull name
first_namestringFirst name
last_namestringLast name
emailstringEmail address
titlestringJob title
team_idstringID of the user's team
permission_set_idstringID of the user's permission set
deletedbooleanWhether the user is deleted
created_atdatetimeCreation timestamp

email_accounts

Email inboxes linked to Apollo for sending.

FieldTypeDescription
idstringUnique email account identifier
emailstringEmail address
user_idstringID of the user who owns the inbox
typestringAccount type, e.g. gmail
provider_display_namestringEmail provider name
activebooleanWhether the inbox is active
defaultbooleanWhether this is the user's default inbox
email_daily_thresholdintegerDaily sending limit
last_synced_atdatetimeWhen the inbox last synced
revoked_atdatetimeWhen access to the inbox was revoked
created_atdatetimeCreation timestamp

lists

Lists of contacts, accounts or sequences (Apollo's API calls them labels).

FieldTypeDescription
idstringUnique list identifier
namestringList name
modalitystringWhat the list holds: contacts, accounts or emailer_campaigns
cached_countintegerNumber of records on the list
user_idstringID of the user who created the list
team_idstringID of the team
created_atdatetimeCreation timestamp
updated_atdatetimeLast modification timestamp

custom_fields

FieldTypeDescription
idstringUnique custom field identifier, used as the key in typed_custom_fields
namestringField name
typestringField type, e.g. picklist or datetime
modalitystringRecord type the field belongs to, e.g. contact
picklist_valuesarray[object]Allowed values of a picklist field
is_localbooleanWhether the field exists only in Apollo, not in a linked CRM
mirroredbooleanWhether the field is mirrored from a linked CRM

contact_stages and account_stages

FieldTypeDescription
idstringUnique stage identifier
namestringStage name
display_namestringStage name as shown in Apollo
display_ordernumberPosition of the stage
categorystringStage category, e.g. in_progress, succeeded or failed
team_idstringID of the team

opportunity_stages

Deal stages.

FieldTypeDescription
idstringUnique stage identifier
namestringStage name
opportunity_pipeline_idstringID of the pipeline the stage belongs to
display_ordernumberPosition of the stage in the pipeline
probabilitynumberWin probability of deals in this stage
is_closedbooleanWhether deals in this stage are closed
is_wonbooleanWhether deals in this stage are won
forecast_category_cdstringForecast category
typestringStage type

Settings

API Key

Apollo API key, from Settings → Integrations → API in Apollo. Use a master API key, or a key with access to the endpoint of each selected stream. phone_calls requires a master key.

Start Date

Earliest update time to extract for the contacts stream, e.g. 2024-01-01T00:00:00Z. Leave empty to extract all contacts. The other streams are always fully replicated.

Meltano Cloud Connector

Apollo connector is available on Meltano. It is built, maintained, supported, and tested by Meltano.

Why Meltano Cloud?
Expert supportDirect access to the team that built and maintains Meltano Cloud. Same-day responses during UK business hours. When something breaks, we fix it fast because we know exactly how it works.
Rigorously testedEvery connector goes through comprehensive testing and quality checks before production. Daily monitoring catches issues before they hit your pipelines. We don't just wrap open-source taps and hope for the best. We validate, we test, we maintain.
No maintenance overheadAPI changes. Connector updates. Schema drift. Breaking changes from upstream sources. We handle it all. Your team focuses on using data. Our team focuses on making sure it's there when you need it.
Ingest & transform data with AIConnect Claude or any MCP-compatible assistant to Meltano Cloud. Add connectors, run pipelines, build dbt models and diagnose failed runs in plain English, against the same Git-backed project your team works in.
Access to Meltano Slack communityJoin 5,500+ data engineers and analytics practitioners. The community is active, helpful, and always on. Good for quick questions, sharing patterns, and learning what others are building.