AI-Powered USA States and Cities Data Extraction Workflow

This workflow is designed to automate the process of generating detailed information about the five largest states in the USA, including their three biggest cities and populations, using AI language models. Triggered manually, it starts with a prompt where a user inputs a specific query about US states and cities. A pre-set prompt node sends this query to a language model, which attempts to generate a structured response.

To ensure correctness and valid output, the workflow incorporates a structured output parser and an autofixing parser. These nodes validate and correct the AI’s response, making it conform to a predefined schema that details states, cities, and populations. The workflow leverages the OpenAI Chat Model through n8n’s LangChain nodes, enabling sophisticated language processing.

This workflow is useful in scenarios where automated, data-rich summaries or reports are needed based on natural language prompts. It is suitable for data analysis, educational tools, or generating geographic summaries dynamically.