By Aaron LeBlanc, Founder & CEO, Hypelocal

➡️ https://zapier.com/experts/hypelocal

What is Unstructured Data?

• ChatGPT Prompt Template for Structuring Unstructured Email Content

  Review the raw content here:
  ----
  Subject: {{249105134__raw__Subject}}. # From Zapier Email Trigger Step
  Body plain: {{249105134__body_plain}}. # From Zapier Email Trigger Step
  ----
  
  Extract and structure the data based on the following schema:
  ---
  - 'businessName': Extracted from the business name.
  - 'businessStreet': Extracted from business address.
  - 'businessCity': Extracted from business address.
  - 'businessState': Extracted from business address (state or province).
  - 'businessCountry': Extracted from business address.
  - 'businessPostalCode': Extracted from business address.
  - 'businessPhone': Extracted from the business phone number.
  - 'businessEmail': Extracted from the business email address.
  - 'websiteUrl': Extracted from the URL in the prospects email.
  - 'businessDescription': A detailed and specific description of the business and what they do. Three sentences or less.
  - 'businessIndustryName': Infer the business industry using NAICS standards.
  - 'contactFirstName': Extracted from the contact's name.
  - 'contactLastName': Extracted from the contact's name.
  - 'contactCellPhone': Extracted from the contact's cell phone number.
  - 'contactEmail': Extracted from the contact's email address.
  - 'contactTitle': Extracted from the contact's title or position.
  - 'budget': Extracted budget information related to the business or project.
  - 'prospectInterest': Extracted interest level or area of interest of the prospect.
  - 'leadDescription': A brief description of the lead, summarizing the potential opportunity or interest.
  - 'whenToContact': Extracted preferred time or date to contact the lead.
  ---
  
  - Once the data is gathered, check your response for accuracy against the provided instructions.
  - Unless otherwise told in the schema, all fields are string fields.
  - This data will be used to go into a CRM via automation. The data needs to needs to be accurate, clean, and contextual.
  
  ++++
  Output response in JSON code format with no leading characters.  Your reply will be used as a JSON payload. Don't include (```json```).
  ++++
  

  • ChatGPT Settings:

    • Model = gpt-4

    • Memory Key = blank

    • Image = blank

    • User Name = Company Admin

    • Assistant Name = Company Admin Assistant and Email Parser

    • Assistant Instructions =

      You are a helpful Company assistant that specializes in parsing unstructured content into a structured format.
      

    • Max Tokens = 1024

    • Temperature = 0.5

    • Top P = 1

• Parse JSON Payload Code Step

  • Input Data - payLoad = ChatGPT Response

  var obj = JSON.parse(inputData.payLoad);
  return obj;
  

• Setup Action steps as needed from there.