Push GHL meetings into HubSpot

[virtualinfosys]

Hello, I've created a webhook in GHL that posts the data from new contact appointments. I want to pass this on to HubSpot so we can replicate the meeting there. I'm using the Create Meeting Engagement action. Here are the steps I have:

Webhook
Search contact in HubSpot (the contact is created in HubSpot via another workflow when the contact is initially created in GHL)
Format start and end date and time
Create a meeting engagement

I originally had everything working except for the user assignment, but now, no matter what I do, I get this error, even after removing almost every field except those required:

"Invalid input JSON on line 1, column 4: Illegal unquoted character ((CTRL-CHAR, code 9)): has to be escaped using backslash to be included in string value"

Here's a link to the original workflow that was mostly working and then stopped working:

Pabbly - Online Marketing & Sales Software

Automate your sales and marketing with Pabbly. Unite email marketing, lead capture, WordPress themes, subscription all at one place.

connect.pabbly.com

Here's a link to a new test workflow with almost none of the fields populated but throwing the same error:

Pabbly - Online Marketing & Sales Software

Automate your sales and marketing with Pabbly. Unite email marketing, lead capture, WordPress themes, subscription all at one place.

connect.pabbly.com

 

[ArshilAhmad]

Hi @virtualinfosys,

Pabbly - Online Marketing & Sales Software

Automate your sales and marketing with Pabbly. Unite email marketing, lead capture, WordPress themes, subscription all at one place.

connect.pabbly.com

You are supposed to map the Associated Contact IDs within the square brackets.

n the Assigned To field, you need to map the owner ID instead of their email address.

I have made the necessary changes on your behalf, which seems to have fixed the issue.

 

[virtualinfosys]

Thanks @ArshilAhmad for the input. It still isn't working as it is now throwing the same error when I am checking it via the Workflow history as shown below:

Status	error
Message	Invalid input JSON on line 1, column 4: Illegal unquoted character ((CTRL-CHAR, code 9)): has to be escaped using backslash to be included in string value
CorrelationId	89ffec26-9792-407d-a241-1ea58c7de1d5

Could you please check back and resolve the issue please.

 

[Pabblymember11]

Please select either true or false in the Is Active field and then attempt again; the process should function as expected.

 

[virtualinfosys]

Hello, We have resolved the previous issue and now we are stuck with a new one:

We want this workflow to create a meeting in HubSpot no matter if the contact is already in HubSpot or not. In the Step
2. HubSpot CRM : Search a Contact:
We want to have an option where it allows to create a new contact in HubSpot if not found in the search. How can we do that?

Here is the workflow:

Pabbly - Online Marketing & Sales Software

Automate your sales and marketing with Pabbly. Unite email marketing, lead capture, WordPress themes, subscription all at one place.

connect.pabbly.com

I have tried using Route in another clone of this workflow here but stuck at filter to work properly:

Pabbly - Online Marketing & Sales Software

Automate your sales and marketing with Pabbly. Unite email marketing, lead capture, WordPress themes, subscription all at one place.

connect.pabbly.com

 

[Pabblymember11]

Hey @virtualinfosys

You can set up the Router action step to define the logic for when there is a contact present and when there isn't. This will control the workflow processing when the "Create a Meeting Engagement" action step is executed.

Please check the second part of the video to use the Router logic on your workflow.

 

[virtualinfosys]

Thanks, I am able to make it work using the Route but the problem now is that contact is being created in Hubspot but no meeting is created and also contact owner isn't being assigned. I've checked the workflow history and it shows no problem there.

Here is the link to workflow Histroy:

Pabbly - Online Marketing & Sales Software

Automate your sales and marketing with Pabbly. Unite email marketing, lead capture, WordPress themes, subscription all at one place.

connect.pabbly.com

I don't understand why meeting is not created be it existing contact route or new contact?

It did create a meeting only once when I re capture the triggering webhook.

 

[Pabblymember11]

Hey @virtualinfosys

Based on the initial task executions, it is evident that the meeting data has been successfully passed to HubSpot as expected.

 

[virtualinfosys]

So where do you think its breaking then? Meetings should be created in Hubspot if the data is passed correctly but it isn't.

 

[virtualinfosys]

Hello, Can I have an update on this?

 

[Pabblymember11]

Hey @virtualinfosys

We can inspect from your task history and the mapped values in the 'Create Meeting Engagement' that due to the missing Contact ID, the action step is unable to create the meeting in HubSpot.

Immediately after creating the contact in the 'Create Contact Router,' the search contact step is unable to find the contact.

Therefore, please map the Contact Id from the 'Create Contact' action step either by reconfiguring it or by passing a new contact to obtain the Contact ID from that action step.

 

[virtualinfosys]

OK, The problem of meeting not created is only New Contact Route 2. I tried mapping Contact ID from "Create Contact Step" but it is now allowing here is the screenshot:

It shows status as error but in the actual run it does return the contact ID as shown here:

How can I map that ID in the create meeting Engagement step?

 

[Pabblymember11]

I have added the Delay action step in between the create and search contact action steps. So it will get the Contact ID from the Search action step accordingly.

Please give it a try now.

 

[virtualinfosys]

I have added the Delay action step in between the create and search contact action steps. So it will get the Contact ID from the Search action step accordingly.

Please give it a try now.

I have tested and is is suspiciously adding "a" with every email address user inputs which is causing the step of "Create a contact to fail"
Here are the screenshots:

 

[Pabblymember11]

I have tested and is is suspiciously adding "a" with every email address user inputs which is causing the step of "Create a contact to fail"

I have removed the extra 'a' from your email address field which was filled, I hope the workflow should work.

Please give it a try and let us know.

 

[virtualinfosys]

I have removed the extra 'a' from your email address field which was filled, I hope the workflow should work.

Please give it a try and let us know.

View attachment 41229

Thank You, Now the meeting and contact are creating as desired, the only issue remain is the contact owner not being assigned in HubSpot. I tried adding 1 Minute wait before Create a Meeting action but it didn't work? Should I be doing it in the contact creation step for "New Contact Route"

 

[Pabblymember11]

As I can see from your latest task history logs the owner is getting assigned to the meeting accordingly.

 

[virtualinfosys]

As I can see from your latest task history logs the owner is getting assigned to the meeting accordingly.

View attachment 41306

Yes it is, but I am asking about the owner being assigned to Contact in addition to the engagement.

 

[Pabblymember11]

Yes it is, but I am asking about the owner being assigned to Contact in addition to the engagement.

Enter the owner ID for the Contact Owner field, which you can obtain using the Get all Owners and Search Owners by Email actions. While creating the Contact.