Experimental feature: HubSpot connector is currently in beta. We’re actively improving sync reliability and adding more features.
Prerequisites
- A HubSpot account with active CRM or marketing data
- Super Admin access to your HubSpot account (required to authorize the connection)
- HubSpot account must have data in contacts, companies, or deals
Connecting HubSpot
You can connect HubSpot in two ways: from the Sources page if you’re already using AstroBee, or during the onboarding process if you’re a new user.- During onboarding
- From Sources page
Start connection
A “Configure Connector” modal appears showing “HubSpot Not Connected”. Click the orange Connect button to begin setup.

Authorize with Fivetran
AstroBee uses Fivetran to securely connect to HubSpot. Review the security information and click Continue.
Fivetran ensures:

- Secure: Data transfer is encrypted end-to-end and your credentials are never exposed
- Private: Your data passes through without permanent storage
Authenticate with HubSpot
On the Fivetran setup page, click Authorize to log in through OAuth. You’ll be redirected to HubSpot to grant access.
You’ll need to:

- Log in with your Super Admin HubSpot account
- Review the permissions Fivetran is requesting
- Authorize access to your HubSpot data
Configure sync settings
After authentication, you’ll be prompted to connect the HubSpot certified app to Fivetran. Review the permissions being requested and click Connect app.
You’ll be taken back to the Fivetran page. Click Save & Test to verify the connection.

Select tables to sync
Back in AstroBee, the “Configure Connector” modal shows your sync progress. Expand Sync Settings to select which tables to include.
Tables marked “(always synced)” are required. Common tables include:

- contact: Contact records with properties and engagement data
- company: Company records and firmographic information
- deal: Deal pipeline and sales opportunity data
- email_event: Email marketing campaign interactions
- engagement: Calls, meetings, notes, and tasks
- owner: HubSpot users and team members
Data layer building
A modal appears showing “Your data layer is building”. AstroBee is unifying, deduplicating, and resolving entities across your data.
This may take 10 minutes to a couple of hours. Feel free to close this and come back later.

Data syncing
The Sources page shows your sync progress. Your data source is syncing and the data layer will be generated automatically once syncing completes.
It’s safe to close this window and continue working. You can connect other data sources while you wait.

What happens next
After connecting HubSpot, AstroBee automatically generates a data layer from your synced tables. Once complete, you can start querying your CRM and marketing data using natural language.Syncing data
HubSpot connections use manual sync - you control when data is refreshed. To sync your latest CRM and marketing data:- Navigate to the Sources page
- Find your HubSpot connection
- Click the sync button
Understanding HubSpot data
HubSpot syncs multiple related tables that work together:- CRM objects: Contacts, Companies, Deals, and custom objects
- Engagement data: Calls, meetings, emails, notes, and tasks
- Marketing data: Email campaigns, forms, and landing pages
- Pipeline data: Deal stages, sales activities, and revenue tracking
- Team data: Users, teams, and ownership assignments
Troubleshooting
For additional help, see Fivetran’s HubSpot troubleshooting guide.Authentication failed
Authentication failed
Issue: Unable to authorize access to HubSpot.Solution:
- Ensure you have Super Admin access to the HubSpot account
- Verify you’re signed in to the correct HubSpot account
- Check that your organization allows third-party access to HubSpot
- Try re-authorizing from the beginning
- Confirm your HubSpot account is active and not suspended
No data syncing
No data syncing
Issue: Connection succeeds but no data appears in tables.Solution:
- Verify your HubSpot account has contacts, companies, or deals
- Check that you selected the correct tables during setup
- Ensure your HubSpot data isn’t empty
- Wait for the initial sync to complete (can take 10+ minutes for large CRM databases)
- Trigger a manual sync to refresh data
Sync taking too long
Sync taking too long
Issue: Initial sync appears stuck or is taking longer than expected.Solution:
- Large CRM databases with thousands of records can take 30+ minutes to sync
- Check your internet connection
- Avoid making changes to the connection during sync
- HubSpot API rate limits may slow down large syncs
- If stuck for more than an hour, contact support at support@astrobee.ai
Missing contacts or companies
Missing contacts or companies
Issue: Some contacts or companies don’t appear in synced data.Solution:
- Verify the records exist in your HubSpot CRM
- Check that records aren’t filtered or archived in HubSpot
- Ensure you selected the relevant tables during setup
- Trigger a new sync to pull the latest data
- Review your HubSpot user permissions - Super Admin can see all data
Custom properties not syncing
Custom properties not syncing
Issue: Custom HubSpot properties don’t appear in synced tables.Solution:
- Verify custom properties exist in your HubSpot account
- Check that custom properties have data populated
- Custom properties sync automatically but may take an additional sync cycle
- Trigger a new sync after creating new custom properties
- Some custom property types may not be supported by the connector
Permission errors
Permission errors
Issue: Cannot access specific HubSpot data or objects.Solution:
- Confirm you have Super Admin role in HubSpot
- Check that your HubSpot subscription includes the features you’re trying to sync
- Some objects (like custom objects) require specific HubSpot tiers
- Re-authenticate to refresh your access permissions
- Contact your HubSpot account administrator if access issues persist
Historical backfill taking too long
Historical backfill taking too long
Issue: Status shows “Backfilling history” for many hours.Solution:
- Historical backfills for HubSpot can take 12+ hours for accounts with years of CRM data
- This is normal behavior, not a stuck sync
- You can safely close the browser and return later
- The sync continues in the background and your data layer will generate automatically when complete
- If backfill exceeds 72 hours with no progress, contact support at support@astrobee.ai
Data layer not generating
Data layer not generating
Issue: Sync completed but data layer shows an error or never finishes building.Solution:
- Check that at least one table was selected during setup
- Verify your synced tables contain actual data (not empty)
- Try refreshing the page to see updated status
- If the error persists, try disconnecting and reconnecting HubSpot
- Contact support at support@astrobee.ai with the error message if the issue continues
















