Business List from Location Search

Create me an app that can run from any browser. The app will search the internet using google. Here is an example: Find businesses of any kind using Google followed by location. Example city or zip cod. once, the app wil create an excel spreatsheet, that lists the city, business name, phone number, street address and zip. Also website URL. The app would work like this. Create me a spreadsheet for plumbers in Dallas Texas. The App would then create and exportan excell spreadsheet containing what I have just listed. The App would have my company name which is Crescent Technical. Make it easy to use.

First, pre-entered info...

final-output2

The final output would be a single Excel file (.xlsx) that lists businesses matching the user's requested type and location. Each row would contain columns for City, Business Name, Phone Number, Street Address, ZIP Code, and Website URL, along with the Crescent Technical branding.

subagents-extracted2

OVERVIEW OF SUBAGENTS Subagent #1 (BusinessSearch) will query the web to obtain current business listings. Subagent #2 (DataFormatter) will structure this raw data into JSON format. Subagent #3 (SpreadsheetGenerator) will create the final CSV output with proper formatting and branding. SUBAGENT #1: BusinessSearch • Purpose: Obtain up-to-date business information (e.g., name, address, phone, website) by querying the web as if performing a Google search. • Skill Used: #224 - Oracle Ask A Question DESCRIPTION: Asks an AI Oracle (with live web/search access) any question and returns an up-to-date detailed response. INPUT NEEDED: A prompt such as "List businesses for [businessType] in [location], including name, phone, street, city, ZIP, website." OUTPUT: Text-based answer with multiple business listings. SUBAGENT FINAL OUTPUT: [business-listings-text] SUBAGENT #2: DataFormatter • Purpose: Parse the unstructured text from Subagent #1 into a standardized JSON-like array of business objects with fields: city, businessName, phoneNumber, streetAddress, zipCode, websiteUrl. • Skill Used: #223 - Powerful LLM Prompt-to-Text Response DESCRIPTION: A powerful LLM to transform text according to instructions. INPUT NEEDED: (1) The text from Subagent #1. (2) Instructions to parse that text into a JSON array, each object containing { city, businessName, phoneNumber, streetAddress, zipCode, websiteUrl }. OUTPUT: JSON-formatted text with an array of objects. SUBAGENT FINAL OUTPUT: [structured-business-data] SUBAGENT #3: SpreadsheetGenerator • Purpose: Convert the structured JSON data into a CSV-like text that users can open in Excel, containing columns for City, Business Name, Phone Number, Street Address, ZIP Code, and Website URL, plus the Crescent Technical branding. • Skill Used: #190 - Write or rewrite text based on instructions DESCRIPTION: An LLM-based text rewriting skill that can generate CSV lines and insert branding as requested. INPUT NEEDED: 1) The JSON data from Subagent #2. 2) Instructions to produce comma-separated rows (headers + data) plus a textual mention of "Crescent Technical." OUTPUT: A multiline CSV text string (e.g., "City,Business Name,Phone Number,Street Address,ZIP Code,Website URL\n...") that serves as the final Excel-ready output. SUBAGENT FINAL OUTPUT: [csv-spreadsheet-output]

subagentnumber

[subagentnumber]

Then, agent response...

subagent1refined-new-json-core

G) TASKFLOW SUMMARY For SILO 1 (Prompt Preparation): ID: #190 Title task: Generate Oracle Search Query Description: Takes user business type and location parameters and reformats them into a standardized search query suitable for the Oracle's input requirements. Ensures consistent query formatting for reliable results. Input(s) involved: - [businessType] - [location] - [instruction-template] ("List {businessType} in {location}, including name, phone, street, city, ZIP, and website.") Output token name: [oracle-query-text] For SILO 2 (Oracle Live Search): ID: #224 Title task: Execute Live Web Search for Business Listings Description: Performs a real-time web search using the formatted query to retrieve current business information. Accesses live data sources to collect business details including contact information and addresses. Input(s) involved: - [oracle-query-text] (from SILO 1) Output token name: [business-listings-text] This represents the complete taskflow for the BusinessSearch subagent, which consists of two main tasks: query preparation (#190) and live web search execution (#224). The final output [business-listings-text] contains the raw business listing data that will be passed to subsequent subagents for formatting and spreadsheet generation.

subagent1mermaid

<!DOCTYPE html> <html> <head> <title>Mermaid Diagram Example</title> <script src="https://cdnjs.cloudflare.com/ajax/libs/mermaid/9.4.3/mermaid.min.js"></script> </head> <body> <div class="mermaid"> graph TD A[Start: BusinessSearch Subagent] --> B[Input Parameters] B --> C[businessType] B --> D[location] C --> E[SILO 1: Prompt Preparation] D --> E E --> |Skill #190| F[Generate Oracle Query] F --> |oracle-query-text| G[SILO 2: Oracle Live Search] G --> |Skill #224| H[Execute Web Search] H --> I[Raw Business Listings] I --> J[business-listings-text] J --> K[End: Output to Next Subagent] style A fill:#f9f,stroke:#333 style K fill:#f9f,stroke:#333 style E fill:#ccf,stroke:#333 style G fill:#ccf,stroke:#333 </div> <script> mermaid.initialize({ startOnLoad: true }); </script> </body> </html>

Mermaid Image - https://static.aiz.ac/1736097439-mermaid/mermaid1.png

prompts-required

[prompts-required]

subagent1-json-array

[ { "taskID": 190, "semanticTitleOfTask": "Generate a standardized Oracle search query from user input.", "taskDescription": "This task receives a business type and location, then creates a succinct search query for the AI Oracle. The query requests name, phone, address, city, ZIP, and website for businesses of that type in the given location.", "inputDescription": "Requires the businessType, location, and an instruction-template. The businessType is the category of business to search for, location indicates the geographic area, and the instruction-template ensures consistent query formatting.", "inputRequired": ["businessType", "location", "instruction-template"], "outputDescription": "Provides a single text string containing a formatted query that requests name, phone, street address, city, ZIP code, and website for businesses.", "outputName": "oracle-query-text", "promptInstruction": "You are a query formatter. I will provide a business type and location. Format them into a standardized search query requesting name, phone, street, city, ZIP, and website for businesses in the given location. Return only a single, clear search request with no commentary." }, { "taskID": 224, "semanticTitleOfTask": "Perform a live web search for business listings using the Oracle.", "taskDescription": "This task uses skill #224 to query an AI Oracle with live web access. Given the standardized query from the prior task, it retrieves real-time business listings including name, phone, address, city, ZIP, and website for each relevant business.", "inputDescription": "Requires the 'oracle-query-text' output from the preceding task (#190) to instruct the Oracle on which businesses to retrieve and the details needed.", "inputRequired": ["oracle-query-text"], "outputDescription": "Produces a raw, multiline text with multiple business listings. Each listing includes name, phone, address, city, ZIP, and website, presented in a simple, line-by-line format without additional commentary.", "outputName": "business-listings-text", "promptInstruction": "You are a business information gatherer with real-time web access. Search and compile a list of businesses matching the provided query. Include name, phone, address, city, ZIP, and website for each. Present the info clearly with one business per line. No additional commentary, just raw data." } ]

subagent1-json-array-mermaid

<!DOCTYPE html> <html> <head> <title>Mermaid Diagram Example</title> <script src="https://cdnjs.cloudflare.com/ajax/libs/mermaid/9.4.3/mermaid.min.js"></script> </head> <body> <div class="mermaid"> flowchart TB start([Start: BusinessSearch SubAgent]) input[User Input:<br>businessType + location] task190[Task #190:<br>Generate Oracle Query] task224[Task #224:<br>Execute Live Web Search] output([Output:<br>business-listings-text]) template[instruction-template] start --> input input --> task190 template --> task190 task190 -->|oracle-query-text| task224 task224 --> output style start fill:#e6f3ff,stroke:#4a90e2 style output fill:#e6f3ff,stroke:#4a90e2 style task190 fill:#f0f0f0,stroke:#333 style task224 fill:#f0f0f0,stroke:#333 style input fill:#f9f9f9,stroke:#666 style template fill:#f9f9f9,stroke:#666 </div> <script> mermaid.initialize({ startOnLoad: true }); </script> </body> </html>