Skip to main content

​
Overview

The HubSpot integration provides bidirectional sync between your HubSpot CRM and Raycaster sheets. Pull contacts and companies into your workspace, enrich them with AI research, and push updates back to HubSpot.

​
Setting Up HubSpot

1

Open Integration Settings

Navigate to Settings → Integrations in the sidebar.
2

Add HubSpot

Find the HubSpot section and click “Add Integration”.
3

Authorize

Sign in to your HubSpot account and grant Raycaster access. You’ll be redirected to HubSpot’s OAuth page.
4

Confirmation

Once authorized, the integration becomes active and is available to all members of your organization.
HubSpot integrations are always organization-scoped. Each organization has a single HubSpot connection shared by all members.

​
Using CRM Templates

The fastest way to get started with HubSpot sync is to use a CRM template:
  1. Create a new sheet and select “From Template”
  2. Choose “Company/Accounts Template for CRMs” or “People Template for CRMs”
  3. The template includes columns pre-mapped to common CRM fields

​
Syncing Data

​
Configuring Sync

1

Open a Sheet

Open the sheet you want to sync with HubSpot. For best results, use a CRM template.
2

Open CRM Settings

Click the CRM button in the sheet toolbar to open the sync configuration.
3

Select Entity Type

Choose what you want to sync:
  • Contacts — Individual people in your HubSpot
  • Companies — Organizations in your HubSpot
4

Map Fields

Map your sheet columns to HubSpot fields. The field mapping interface shows:
  • Your sheet columns on the left
  • Available HubSpot fields on the right (both standard and custom)
  • Click to create a mapping between them
Example mappings:
Sheet ColumnHubSpot Field
First Namefirstname
Last Namelastname
Emailemail
Companycompany
Job Titlejobtitle
5

Choose Sync Direction

Select the sync direction for this operation:
  • Pull — Import data from HubSpot into your sheet
  • Push — Export data from your sheet to HubSpot
  • Bidirectional — Sync in both directions
6

Run Sync

Click Sync to execute. Progress is tracked in real-time.

​
Sync Directions

Import contacts or companies from HubSpot into your sheet:
  • All mapped fields are pulled from HubSpot
  • New rows are created in your sheet for each record
  • Both standard and custom HubSpot properties are supported

​
Custom Fields

HubSpot custom properties are fully supported:
  • Custom properties appear alongside standard fields in the field mapping interface
  • Map them to any sheet column just like standard fields
  • Custom field values are synced in both pull and push directions

​
Sync Tracking

Each sync operation is tracked with:
  • Event type — Pull, push, or bidirectional
  • Records processed — Number of contacts/companies synced
  • Errors — Any records that failed to sync, with error details
  • Timestamp — When the sync occurred
View sync history from the integrations settings page.

​
Troubleshooting

  • Verify the field exists in your HubSpot account
  • Check that your HubSpot user has access to the field
  • Custom properties may take a moment to load — refresh the mapping interface
  • Ensure your field mappings include a unique identifier (typically email for contacts)
  • Use the pull direction first to import existing records before pushing new data
  • Verify the HubSpot account used for authorization has sufficient permissions
  • CRM data access requires appropriate HubSpot subscription level
  • Try disconnecting and reconnecting the integration

​
Disconnecting

To remove the HubSpot integration:
  1. Go to Settings → Integrations
  2. Find the HubSpot integration
  3. Click Disconnect
  4. Confirm the removal
Disconnecting does not delete any data that was already synced to your sheets or pushed to HubSpot. It only prevents future sync operations.