Skip to content
English
  • There are no suggestions because the search field is empty.

Import accounts and opportunities (CSV, Apollo, HubSpot, Lusha)

Besides contacts, you can import:

# Import accounts and opportunities (CSV, Apollo, HubSpot, Lusha)

📘 What it is

Besides contacts, you can import:

  • Accounts (companies): from CSV, Apollo, HubSpot, or Lusha. No contacts are created; they are added later.
  • Opportunities: from CSV, HubSpot, or Apollo (deals).

Both importers follow the same path: choose the source, map or configure, review what will happen, and confirm. Re-importing does not duplicate: what was already brought in is updated.

Opportunity import depends on your account's activation; if you don't see the Import: button in the Opportunities tab, check with your Account Admin or your Customer Success contact.

📍 Where to find it

  • Accounts: side menu → CRM → Accounts tab → next to Import:, the Apollo, HubSpot, Lusha, and CSV buttons.
  • Opportunities: CRM → Opportunities tab → Import: CSV, HubSpot, or Apollo.

Requires HubSpot, Apollo, or Lusha to be connected in Integrations, and write permissions depending on your role.

🛠️ How to do it

Import accounts from CSV

  1. Click CSV in Accounts. You can Download CSV template and View column guide. Only the company name is required; the rest (domain, website, industry, size, country, city, phone, LinkedIn, annual revenue in USD, founding year, context, and owner executive) is optional.
  2. Upload your file (CSV or TSV, up to 5 MB and 2,000 rows; the separator can be comma, semicolon, or tab; header in the first row).
  3. Map the columns (you must map Company name) and click Review N companies.
  4. In Review you will see Rows, New accounts, and Existing (matched by domain). Matches by name only are marked as Doubtful matches: you decide what to do with each one; those you don't decide on are left out. You can see Existing accounts: what changes and choose the Owner of the new accounts (no owner, the one from the "executive" column, or a team member).
  5. Optionally check Exclude accounts that already exist in Lymera so those already there are not updated (they are counted as Skipped because they exist).
  6. Click Import N accounts. When it finishes: Accounts created, Updated, Duplicates, and With errors, with the list of rejected rows and their reason, and View accounts.

How they are compared: by domain (or by name if there is no domain). What you edited by hand is not overwritten and each row's "context" text accumulates in the account's Import context.

Import accounts from Apollo, HubSpot, or Lusha

  • Apollo: configure the company ICP filters (you can pre-load them with a product and ICP level), click Search, review the sample, and Confirm and import up to N accounts. The search uses Apollo credits and Lymera shows the cost beforehand.
  • HubSpot: choose a list of companies (not contacts) and review. The product and ICP level are for reference only.
  • Lusha: search with filters, review the sample (up to 10), and confirm; Lusha charges credits for each company it returns and does not include contact data.

Import opportunities

  1. In Opportunities, choose CSV, HubSpot, or Apollo next to Import:.
  2. CSV: download the template, upload the file (CSV or TSV, up to 5 MB and 2,000 rows), and map columns. You must map the Opportunity name; you can also map amount, currency, close date, stage, owner, company, company domain, contact emails, external id, probability, next step, and more. With External id, re-importing the same file does not duplicate.
  3. HubSpot: choose the HubSpot pipeline and click Fetch deals (up to 2,000). Apollo: your account's deals are read (requires an Apollo master key); you can turn on Fetch the emails of each deal's contacts.
  4. In Configure import choose the Lymera pipeline, the Default stage, and a table that maps Source stages → Lymera stages. Define what to do If the company doesn't exist (import without a company, create it, or skip the row) and If the contact doesn't exist (import without it or create it; it does not charge credits or enroll it), the owner (AE), the SDR, the product, and the close reasons. Also choose which data wins on re-import: the source's or Lymera's, field by field.
  5. Click Review N opportunities: you will see New, Already imported, Doubtful (same name and company: you choose to update the existing one or create another), and Left out. Confirm with Import N opportunities.
  6. Result: Created, Updated, and Unchanged.

A closed opportunity is never reopened or moved to another stage by an import.

❓ Frequently asked questions

Does importing accounts create contacts? No. Contacts are added separately.

Are accounts duplicated if I re-import? No: they are updated by domain without overwriting what you edited by hand.

Can I import opportunities without a company? Yes, if you choose Import without a company.

What happens with a currency I haven't enabled? Enable it first in Settings → Currencies and exchange rates (see the currencies article).

If I connect HubSpot to sync, do I need to import? With HubSpot sync active, opportunities are read automatically; check with your Customer Success contact before combining both paths.

How many rows can I load? Up to 2,000 per file for accounts and opportunities.

🔧 If something doesn't work

  • "The file must be .csv or .tsv." or "The file must not exceed 5 MB.": adjust the file.
  • "You must map the column for the Name…": assign that column before continuing.
  • "We couldn't fetch the deals" or "X is not connected": check the connection in Integrations.
  • "The import was interrupted before finishing.": review what was imported and try again; what was already imported is not duplicated.
  • Escalate to a person with: company, user, source, time, expected and obtained number of rows, exact message, file (if applicable), and a screenshot.