HubSpot Company to Sage Intacct Customer 


First published on: 08/10/2023/6:54 pm

 

 

 

  • The workflow will scan HubSpot at regular intervals and retrieve data about companies that have been newly created or updated. 

  • Customer records will be created or updated in Sage Intacct.  

  • Custom data mappings can be implemented. 

 

Workflow Description 

The workflow will call HubSpot at regular intervals (configurable) to retrieve new or updated companies since the last job run.

 

For each company found, the workflow will check if the company exists as a customer in Sage Intacct by comparing the HubSpot company ID to the Sage customer ID using the “Get Legacy Object by Name” in Sage Intacct.

 

If the customer exists, the workflow performs an update.

 

Otherwise, the workflow creates a new customer in Sage Intacct. 

 

Workflow Diagram

A diagram of workflow

Description automatically generated with medium confidence 

Mapping 

The following mapping will be applied: 

 

HubSpot Company  

Sage Intacct Customer

Comments / Hardcoded Values 

Id 

CUSTOMERID 

 

Name 

NAME 

 

 

TAXABLE 

Hardcoded True 

Name 

DISPLAYCONTACT 

 

Name 

PRINTAS 

 

Phone 

PHONE1 

(MAIL ADDRESS) 

Address 

ADDRESS1 

(MAIL ADDRESS) 

City 

CITY 

(MAIL ADDRESS) 

State 

STATE 

(MAIL ADDRESS) 

Zip 

ZIP 

(MAIL ADDRESS) 

Country 

COUNTRY 

(MAIL ADDRESS) 

 

STATUS 

Hardcoded active 

 

GLGROUP 

To be set during collaborative mapping 

 

TERMNAME 

To be set during collaborative mapping 

 

ONHOLD 

Hardcoded to false 

 

Assumptions

  • Integration is one way from HubSpot to Sage Intacct.

    • No updates made in Sage Intacct flow back to HubSpot.

 

 

 

 

 

 

Next


  

Last modified: 11/15/2023/8:21 pm

-