ServiceNow HubSpot Integration Guide

Architecture Overview

Implementation Steps

// Example data transformation script within Flow Designer
var contactData = fd_data.lookup('hubspot_contact');
var customerRecord = new GlideRecord('customer_account');
customerRecord.initialize();
customerRecord.name = contactData.properties.firstname + ' ' + contactData.properties.lastname;
customerRecord.email = contactData.properties.email;
customerRecord.phone = contactData.properties.phone;
customerRecord.u_hubspot_id = contactData.id;
customerRecord.insert();
fd_data.setValue('servicenow_customer_id', customerRecord.getUniqueValue());

// Script to create incident from HubSpot deal data
var dealData = fd_data.lookup('hubspot_deal');
var incident = new GlideRecord('incident');
incident.initialize();
incident.short_description = 'Service implementation for deal: ' + dealData.properties.dealname;
incident.description = 'Customer: ' + dealData.properties.hs_deal_associated_company + '\nDeal Value: $' + dealData.properties.amount + '\nClose Date: ' + dealData.properties.closedate;
incident.category = 'Service Request';
incident.subcategory = 'Implementation';
incident.priority = dealData.properties.amount > 50000 ? '2' : '3';
incident.assignment_group = 'Implementation Team';
incident.u_hubspot_deal_id = dealData.id;
var incidentSysId = incident.insert();
fd_data.setValue('incident_number', incident.getDisplayValue('number'));

// Scripted REST API webhook handler
(function process(request, response) {
    try {
        var requestBody = request.body.data;
        var objectType = requestBody.subscriptionType;
        
        if (objectType === 'contact.propertyChange') {
            var contactId = requestBody.objectId;
            var gr = new GlideRecord('customer_account');
            gr.addQuery('u_hubspot_id', contactId);
            gr.query();
            
            if (gr.next()) {
                // Update existing customer record
                gr.setValue('last_updated', new GlideDateTime());
                gr.update();
            }
        }
        
        response.setStatus(200);
        response.setBody({"status": "success"});
    } catch (e) {
        gs.error('HubSpot webhook processing error: ' + e.message);
        response.setStatus(500);
    }
})(request, response);

// Company synchronization logic
var companyData = fd_data.lookup('hubspot_company');
var companyRecord = new GlideRecord('core_company');
companyRecord.addQuery('u_hubspot_id', companyData.id);
companyRecord.query();

if (!companyRecord.next()) {
    companyRecord.initialize();
    companyRecord.u_hubspot_id = companyData.id;
}

companyRecord.name = companyData.properties.name || '';
companyRecord.u_domain = companyData.properties.domain || '';
companyRecord.u_industry = companyData.properties.industry || '';
companyRecord.u_employee_count = companyData.properties.numberofemployees || 0;
companyRecord.u_annual_revenue = companyData.properties.annualrevenue || 0;

if (companyRecord.isNewRecord()) {
    companyRecord.insert();
} else {
    companyRecord.update();
}

// Integration monitoring script
var integrationStatus = new GlideRecord('sys_flow_context');
integrationStatus.addQuery('flow.name', 'CONTAINS', 'HubSpot');
integrationStatus.addQuery('state', 'failed');
integrationStatus.addQuery('sys_created_on', '>=', gs.hoursAgoStart(24));
integrationStatus.query();

if (integrationStatus.getRowCount() > 5) {
    gs.eventQueue('hubspot.integration.failure_threshold_exceeded', null, 
        'Integration failure count: ' + integrationStatus.getRowCount(), 
        gs.getUserID());
}

// Log successful sync counts for reporting
gs.log('HubSpot Integration Daily Summary: ' + integrationStatus.getRowCount() + ' failures in last 24 hours', 'HubSpotIntegration');

Common Use Cases

Troubleshooting

Pro Tips

• →Implement field-level change tracking by storing HubSpot property modification timestamps in ServiceNow custom fields, enabling sophisticated conflict resolution when the same record is modified in both systems simultaneously. Use GlideRecord's setWorkflow(false) method during bulk synchronization operations to prevent unnecessary business rule execution and improve performance by up to 60% during large data imports.
• →Configure HubSpot webhook subscriptions at the property level rather than object level to reduce unnecessary API calls and processing overhead, focusing only on the specific fields that require real-time synchronization to ServiceNow. Create custom Application Properties to store integration configuration values like batch sizes and sync intervals, making the integration more maintainable and tunable without code changes.
• →Leverage ServiceNow's Transform Maps for complex HubSpot data imports, especially when dealing with multi-select properties or custom field mappings that require data transformation. Set up automated data quality monitoring using ServiceNow's Data Quality Management features to identify and alert on synchronization anomalies like missing required fields or data format inconsistencies between systems.
• →Use ServiceNow's Connection & Credential testing capabilities to implement automated health checks for your HubSpot integration, creating scheduled jobs that verify API connectivity and credential validity before critical synchronization windows. Implement custom metrics collection in your Flow Designer actions to track integration performance and create operational dashboards showing sync success rates, processing times, and error patterns.
• →Create dedicated ServiceNow users with restricted roles specifically for HubSpot integration operations, improving security audit trails and allowing fine-grained permission control over which ServiceNow tables and fields can be modified by the integration. Use ServiceNow's Data Export functionality to create regular backups of synchronized data before implementing major integration changes, enabling quick rollback if synchronization logic errors corrupt production data.
• →Implement intelligent retry mechanisms using exponential backoff algorithms in your Flow Designer error handling to optimize recovery from temporary HubSpot API failures without overwhelming the service. Configure Connection Aliases with multiple endpoint URLs and implement automatic failover logic to handle HubSpot API regional outages or maintenance windows that could disrupt critical business processes.

Known Limitations

• —HubSpot's REST API enforces rate limits of 100 requests per 10 seconds for Professional accounts and 150 for Enterprise accounts, requiring careful batch sizing and potentially limiting real-time synchronization capabilities for high-transaction environments. The API also has daily limits of 250,000 requests for Professional and 500,000 for Enterprise accounts, which may constrain large-scale data synchronization operations.
• —ServiceNow's IntegrationHub HubSpot spoke actions have built-in timeouts of 30 seconds per API call, which may cause issues when processing large datasets or during HubSpot API performance degradation. Complex data transformations within Flow Designer can consume significant instance resources and may require MID Server deployment for high-volume processing scenarios.
• —HubSpot webhook deliveries are not guaranteed and do not include built-in retry mechanisms beyond the initial delivery attempt plus two retries, potentially causing data synchronization gaps during ServiceNow maintenance windows or network connectivity issues. Webhook payloads also have a maximum size limit of 1MB, which may truncate large contact or deal records with extensive custom properties or long text fields.
• —The integration cannot synchronize HubSpot file attachments or documents stored in deal or contact records to ServiceNow attachment tables due to API limitations, requiring separate file transfer mechanisms for complete record synchronization. Custom HubSpot properties created after the integration setup may not automatically appear in ServiceNow synchronization jobs without manual Flow Designer updates.
• —ServiceNow's Flow Designer has execution time limits that may prevent processing of very large HubSpot datasets in a single run, requiring batch processing approaches and potentially causing delays in data synchronization for organizations with extensive CRM databases. The IntegrationHub Professional license is required for the HubSpot spoke, adding licensing costs that may not be justified for smaller ServiceNow implementations with limited integration requirements.

Frequently Asked Questions