Business List from Location Search - Confirm & Copy Final Agent Code

Describe

Describe your task

Refine

Refine the plan

SubAgents

Review all agents

Deploy

Deploy your agent

Review Final Agent Copy

Expand

[
  {
    "taskID": 190,
    "semanticTitleOfTask": "Query String Construction - create a Google search query to find business listings",
    "taskDescription": "This skill constructs a specialized Google search query using the provided business type and location. The generated query is optimized to find relevant business listings and contact details such as company names, addresses, phone numbers, ZIP codes, and websites.",
    "inputDescription": "This requires two string inputs: VARIABLE1 (representing the business type, e.g. 'plumbers') and VARIABLE2 (representing the location, e.g. 'Dallas Texas'), used to construct a specialized search query.",
    "inputRequired": [
      "VARIABLE1",
      "VARIABLE2"
    ],
    "outputDescription": "A single string that represents a well-formed query to be passed to the web search skill, optimized to locate business listings from online directories and search engines.",
    "outputName": "formatted_query_string",
    "promptInstruction": "Create a Google search query to find business listings. Use VARIABLE1 (business type) and VARIABLE2 (location) to construct a search string that will return business details including company names, addresses, phone numbers, ZIP codes, and websites. The query should be optimized to find business directory listings and contact information. Format the query to maximize relevant results."
  },
  {
    "taskID": 224,
    "semanticTitleOfTask": "Oracle Web Search Execution - gather raw business data from the web",
    "taskDescription": "This skill performs a live web search using the previously constructed query string to find business listings in the specified location. It returns unstructured text containing relevant data such as addresses, phone numbers, ZIP codes, and websites for each listing.",
    "inputDescription": "This task requires a single string input, the 'formatted_query_string' produced by the Query String Construction skill, to search web sources and return unstructured business listings.",
    "inputRequired": [
      "formatted_query_string"
    ],
    "outputDescription": "Unstructured text containing raw business listings discovered during the web search, including any available contact information, addresses, ZIP codes, or websites.",
    "outputName": "raw_business_search_results",
    "promptInstruction": "Search for businesses matching formatted_query_string. For each business found, retrieve the following information if available: Business name, Street address, City, ZIP code, Phone number, Website URL. Return all findings as text, including as many relevant businesses as possible within the specified location. Focus on directory listings, business profile pages, and official business websites."
  },
  {
    "taskID": 190,
    "semanticTitleOfTask": "Clean and Segment Raw Business Data",
    "taskDescription": "This task takes raw business listing text as input and removes irrelevant, duplicated, or extraneous information while separating each business into its own distinct block for further processing.",
    "inputDescription": "This task requires the unstructured text of business search results and an instruction set to identify each unique business entry, removing advertising or extraneous info, ensuring each business is isolated in its own block, and filtering out duplicates.",
    "inputRequired": [
      "raw_business_search_results"
    ],
    "outputDescription": "A cleaned text output where each business listing is in a separate block or paragraph, stripped of any content not directly describing a business.",
    "outputName": "cleaned_block_based_text",
    "promptInstruction": "Remove any advertising, navigation elements, or irrelevant text not related to business listings. Identify each unique business listing, separate each into its own distinct block, remove duplicates, and ensure each block only contains relevant business info. Return only the cleaned, segmented text, with each business on a separate line."
  },
  {
    "taskID": 190,
    "semanticTitleOfTask": "Extract Structured Business Fields",
    "taskDescription": "This task parses each business block to extract and label core fields (Name, Address, City, ZIP, Phone, and Website), producing a consistently formatted list suitable for further transformation.",
    "inputDescription": "This task requires the cleaned, segmented text from the previous step. Each block represents a single business entry. The instructions guide extraction of Name, Street Address, City, ZIP, Phone, and Website (if available), with placeholders left blank if any field is missing.",
    "inputRequired": [
      "cleaned_block_based_text"
    ],
    "outputDescription": "A structured list of businesses where each entry contains the fields {Name, Address, City, ZIP, Phone, Website}, ready for conversion into CSV or other data formats.",
    "outputName": "extracted_business_details",
    "promptInstruction": "For each business block, parse out the fields (1) Business Name, (2) Street Address, (3) City, (4) ZIP, (5) Phone, and (6) Website URL if present. Return each business as {Name: X, Address: X, City: X, ZIP: X, Phone: X, Website: X} on a new line. If a field is not found, leave it blank but maintain the label."
  },
  {
    "taskID": 310,
    "semanticTitleOfTask": "Structured Data Formatter - Convert extracted business details into line-by-line CSV data",
    "taskDescription": "This task uses skill #190 to read the unstructured text from extracted_business_details, parse it, and produce line-by-line business records with fields in a consistent order, ready for CSV generation or further processing.",
    "inputDescription": "It takes the text from extracted_business_details, containing loosely structured data like business name, address, phone, and website, and aligns them in a standardized format.",
    "inputRequired": [
      "extracted_business_details"
    ],
    "outputDescription": "A single block of consistently formatted text, each line representing one business record with fields separated by commas in the order: City, Business Name, Phone Number, Street Address, ZIP Code, Website URL.",
    "outputName": "structured_business_data",
    "promptInstruction": "Please transform the input text so that each business is on a separate line, with fields in this order: City, Business Name, Phone Number, Street Address, ZIP Code, Website URL. Separate the fields with commas, standardize phone numbers as (XXX) XXX-XXXX, and ensure full website URLs. If a field is missing, leave it blank but keep the comma. Remove extraneous spaces."
  },
  {
    "taskID": 190,
    "semanticTitleOfTask": "Convert Structured Business Data to CSV Format",
    "taskDescription": "This task receives structured, line-by-line business data from the previous subagent and transforms it into a CSV file with the required header row, ensuring uniform field ordering and proper CSV formatting for each business entry.",
    "inputDescription": "This task requires the structured, line-by-line business data from the previous task. The data has fields in a consistent order. The header row must be City,Business Name,Phone Number,Street Address,ZIP Code,Website URL.",
    "inputRequired": [
      "structured_business_data"
    ],
    "outputDescription": "A single plain-text CSV string containing a header row and subsequent rows for each business entry, ready to be saved as .csv and opened in Excel.",
    "outputName": "csv_file_data",
    "promptInstruction": "You will receive structured business data in a line-by-line format. Convert this data into a CSV file using the header row City,Business Name,Phone Number,Street Address,ZIP Code,Website URL. Maintain correct field order, use commas as delimiters, properly escape fields containing commas with quotes, and ensure each business entry is on its own line. Output only the CSV content, suitable for saving directly as a .csv file."
  },
  {
    "taskID": 190,
    "semanticTitleOfTask": "Format CSV Data with Crescent Technical Branding and Instructions for Excel",
    "taskDescription": "This task uses skill #190 to combine CSV data with concise instructions referencing Crescent Technical, enabling the user to save the file as CSV and open it in Excel.",
    "inputDescription": "This task requires the plain-text CSV data from the previous step (csv_file_data) and VARIABLE3, which is the brand name (e.g., Crescent Technical). The CSV data is included verbatim, while the brand name is used for instructions and headers.",
    "inputRequired": [
      "csv_file_data",
      "VARIABLE3"
    ],
    "outputDescription": "A single text block with a short header referencing VARIABLE3, instructions for saving/opening the CSV, a separator line, and the CSV data itself unmodified.",
    "outputName": "final_csv_export",
    "promptInstruction": "Combine the provided CSV data with instructions in a text block. Start with a header referencing VARIABLE3, followed by numbered instructions for saving and opening the CSV. Then include a clear separator line, and finally the CSV data. Keep it straightforward and professional, ensuring the data remains unchanged."
  },
  {
    "taskID": 190,
    "semanticTitleOfTask": "Initial Data Validation and Deduplication",
    "taskDescription": "This step uses skill #190 to remove rows missing required fields (e.g., Business Name, Phone), eliminate duplicate entries, keep the column order, ensure each row has the same number of columns, and output the cleaned CSV data.",
    "inputDescription": "The CSV text that may include invalid or duplicated rows, plus specific validation rules and a list of required fields that must be present for each record.",
    "inputRequired": [
      "raw_csv_text",
      "validation_rules",
      "required_fields_list"
    ],
    "outputDescription": "Cleaned CSV text with incomplete or duplicate rows removed and columns kept consistent throughout.",
    "outputName": "validated_csv_data",
    "promptInstruction": "You are tasked with cleaning raw CSV business listing data. Process the input CSV text by: 1) Removing any rows where Business Name OR Phone Number is empty/missing. 2) Identifying and removing duplicate entries where Business Name, Phone, AND Address are exactly the same. 3) Keeping the column order intact. 4) Ensuring each row has the same number of columns. 5) If any row is missing optional fields (like a Website), leave them blank. Output the cleaned CSV text with invalid and duplicate entries removed."
  },
  {
    "taskID": 190,
    "semanticTitleOfTask": "Data Format Normalization",
    "taskDescription": "This step uses skill #190 to standardize CSV data formats, enforcing phone number patterns, city name capitalization, whitespace trimming, special character rules for business names, ZIP code consistency, and website URL prefixes.",
    "inputDescription": "The validated CSV text from the previous task, plus formatting rules or patterns (e.g., phone format, city casing).",
    "inputRequired": [
      "validated_csv_data",
      "formatting_rules",
      "standardization_patterns"
    ],
    "outputDescription": "The CSV text with uniformly formatted data across all fields, prepared for final verification and usage.",
    "outputName": "normalized_csv_data",
    "promptInstruction": "Standardize the formatting of the CSV data by: 1) Formatting phones to (XXX) XXX-XXXX. 2) Converting city names to Title Case. 3) Trimming leading/trailing whitespace. 4) Removing special characters from business names (except & and -). 5) Ensuring ZIP codes are 5 digits. 6) Formatting website URLs to start with http:// or https:// if not already. Your output should be the CSV text with properly standardized fields."
  },
  {
    "taskID": 190,
    "semanticTitleOfTask": "Final CSV Structure Validation",
    "taskDescription": "This step uses skill #190 to finalize the CSV structure by adding a header row, ensuring exactly six columns in the correct order, and properly escaping field values so the file can be opened in Excel.",
    "inputDescription": "The normalized CSV text from the previous task, plus the required column order and CSV format rules to produce a final Excel-compatible CSV file.",
    "inputRequired": [
      "normalized_csv_data",
      "column_order_template",
      "csv_format_rules"
    ],
    "outputDescription": "A final CSV text file with correct headers, column count, and formatting that can be opened in Excel without additional changes.",
    "outputName": "final_clean_csv",
    "promptInstruction": "Format the business listing data into its final CSV structure by: 1) Ensuring exactly 6 columns in the order: City, Business Name, Phone Number, Street Address, ZIP Code, Website URL. 2) Adding a header row with these names. 3) Verifying each row has exactly 6 comma-separated values. 4) Properly escaping any commas within field values using quotes. 5) Removing any line breaks within fields. Output the final CSV text ready for Excel."
  }
]

Happy? Now Copy-Paste To Proceed...

BACK TO SUBAGENTS

COPY TO CLIPBOARD