Placeholder email extraction errors

[DMacauely]

Your Workflow URL

https://connect.pabbly.com/workflow/mapping/IjU3NjUwNTZiMDYzMzA0MzU1MjZjNTUzMDUxMzUi_pc

Your Task History ID

IjU3NjUwNTZhMDYzNzA0MzI1MjY0NTUzMDUxMzc1MTYxNTQzOTBmMzEi_pc

Consent to Access & Modify

I authorize Pabbly Support to log in to my account and make changes to the specified workflow for troubleshooting.

Hello,
I have a workflow set up to bring data from our LinkedIn out reach campaign software into our HubSpot CRM so that our team can follow up with people that respond to our LinkedIn outreach.

Here are the steps in the workflow that we've set up:
1. Webhook by Pabbly

• catches the data sent by our campaign manager when prospect replies to our outreach campaign

2. Text Formatter

• Checks to see whether webhook data contained an email address
  • if blank, it inserts [email protected] as a default email address

3. Text Formatter

• Checks email value to remove any white space that may have been inserted at step 2

4. Hubspot CRM Contact Search

• Uses email value to verify whether the responding person is already in our contact database

5. Router (Pabbly)

• If contact exists in CRM
  • Update contact record with campaign identification info
    • Check for an open deal associated with the campaign that triggered the Webhook
      • If Deal exists
        • add contact to deal
      • If no deal,
        • create a deal.
          • add contact to deal
• If contact does not exist
  • Create a deal
    • add contact to deal

The majority of the time, this flow works great! However, every so often it will fail when people add things to their last name on their LinkedIn profile. The work flow has problems deal with situations such as when users put an emoji or a designation that includes trademark symbol because text formatter in step 3 is not able to remove the special characters and sometimes a blank space will persist despite goign through that step of the workflow.

How can we fixt this step in the workflow to deal with these situations?

Thanks!

 

[ArshilAhmad]

Hi @DMacauely,

There is no internal tool that can reliably remove the random characters from the last name. You can ask ChatGPT to write a code that returns only text when provided with a string, then execute this code using the Code (Pabbly) step, and pass the cleaned last name from this step to wherever you are encountering the issue.