Sheet Set Up for Importing Lists into HubSpot

List Preparer Guide of What Data is Required vs Recommended:

Utilize this Document as a Template for preparing an Import Sheet (Make Copy)

🚩Important Note: If you wish to import Contacts we are required to check a box confirming:

All Contacts in this Import are expecting to hear from my Organization
I have a prior relationship with these contacts and have emailed them at least once in the past year
I can confirm this list wasn't purchased, rented, appended, or provided by a third party

⚠️ For Apollo List Imports we will ONLY be using Company Import ⚠️

Please Keep this in Mind when looking to request any Imports into HubSpot.

This may fluctuate based on current workload & priorities

Record Count	Est. Time for Import & Audit Completion
Under 500	Minimum : 1.5 Days
Between 500 - 1,000	Minimum: 2 Days
Over 1,000	Minimum: 3 Days

Record Count	Est. Time for Import & Audit Completion
Under 500	Minimum: 1.5 Days
Between 500 - 1,000	Minimum: 2 Days
Over 1,000	Minimum: 3 Days

1 Company and 1 Contact in one Row = 2 Records
- If you're Importing 500 Rows of Both Contacts & Companies = 1,000 Records
Recommended Flow:
- 100 - 200 Companies Per Import
  - 200 - 400 Records at a Time being audited and imported
- Quicker Audit & Import
- While being Reviewed/Imported
  - Prep Reach Out (Sequence? Email Content?)
  - Prep Next Lead List
    - Provide to Ops Team
- Initial Import should be Imported and Ready for Reach Out

Each Column Header is Mapped to a Property in HubSpot

Column:	Required	Notes
Company Name	✅
Company Owner	✅	Handled by Ops (Sales Rep)
Company/Contact Domain	✅
Lifecycle Stage	✅	Lead or Customer
Phone Number	✅	(See Formatting Above)
State	✅	(Abbreviation, e.g., FL)
Lead List Source: (E.g., Apollo Control4)	✅	Template Column = Campaign Event (add there)
Sales Development Representative		Handled by Ops
Regional Sales Executive		Handled by Ops
Buying Group		Handled by Ops
NetSuite Category		Handled by Ops
Partner		Handled by Ops
Automation Systems Used (More than one option can be added - separate via a comma)		Savant, Control4, Crestron, RTI, URC, Elan, Josh.ai, Paxton, OnSSI, Exacq, Milestone, Genetec, Qognify, Avigilon

Each Column Header is Mapped to a Property in HubSpot

Column:	Required	Notes:
Company Name	✅
Company Owner	✅	Handled by Ops (Sales Rep)
Company/Contact Domain/Web Address	✅
Lifecycle Stage	✅	Lead or Customer
Company Phone Number	✅	(See Formatting Above)
Contact First Name	✅	Separate Column than Last
Contact Last Name	✅	Separate Column than First
Contact Phone Number	✅
Contact Email Address	✅
Contact Job Title	✅
State	✅	Abbreviation, e.g., FL
Apollo List Date	✅	The Date the List was Provided (Ex; 7/25/2025)
Sales Development Representative		Handled by Ops
Regional Sales Executive		Handled by Ops
Buying Group		Handled by Ops
NetSuite Category		Handled by Ops
Partner		Handled by Ops
Automation Systems Used (More than one option can be added - separate via a comma)		Savant, Control4, Crestron, RTI, URC, Elan, Josh.ai, Paxton, OnSSI, Exacq, Milestone, Genetec, Qognify, Avigilon

Steps to Take Once List is Ready to be Audited and Imported to HubSpot

Verify as much information as possible prior to providing the sheet, ensuring viable data and leads
In a Professional Email to any Stakeholders, Sales Ops, Analyst, and CRM Specialist
- What is the Goal/Objective?
  - We will a "Tag" to track the specific initiative as listed above
    - Ex if from Show: Campaign Event = TOLA Event 2025
    - Ex if from Apollo: Apollo List Date = 7/25/2025 (This format)
- Explain how the list was built:
  - Ex; AV List? Control4 List? AZI Show List? Cedia List? etc. FL Lead List?
- Add the Google Sheet you have prepared for Sales Ops to Audit

Leadership should confirm it's been received and/or respond with any feedback prior to beginning the audit.

Sheet Set Up for Importing Lists into HubSpot - All Lists