Extract baggage, check-in, and support policies from ai

This workflow automates the extraction and structuring of airline policy data — including online check-in rules, baggage allowances, customer support details, and cancellation terms — from official carrier websites. Using AI and vector indexing, it creates a centralized, searchable knowledge base for fast access and analytics.

## Who it´s for
- Automation specialists in aviation collecting airline policy data
- Customer support teams needing quick access to up-to-date flight rules
- Developers building semantic search systems over airline documentation
- Analysts comparing carrier conditions on baggage, refunds, and check-in

## What the automation does
- Triggered via chat command or manual execution
- Fetches a list of airline URLs from Google Sheets
- Scrapes each webpage using HTTP requests
- Uses an LLM (Ollama via LangChain) to extract structured JSON data
- Stores extracted results back in Google Sheets
- Embeds and indexes data in PGVector for semantic retrieval

## What´s included
- Ready-to-use n8n workflow
- Trigger and handler logic
- Integrations with Google Sheets, Ollama API, PostgreSQL/PGVector, and HTTP services
- Basic textual guide for launch and adaptation

## Requirements for setup
- Access to n8n (cloud or self-hosted)
- Google account with enabled Sheets API
- Local or remote server running Ollama with a loaded model
- PostgreSQL instance with PGVector extension and write access
- Target airline website URLs

## Benefits and outcomes
- Centralized repository of fragmented airline policy data
- Reduces manual data collection time from hours to minutes
- Enables fast semantic search through PGVector embeddings
- Powers chatbots and support systems with real-time info
- Automatically updates reference data when carrier policies change

## Important: template only
Important: you are purchasing a ready-made automation workflow template only. Rollout into your infrastructure, connecting specific accounts and services, 1:1 setup help, custom adjustments for non-standard stacks and any consulting support are provided as a separate paid service at an individual rate. To discuss custom work or 1:1 help, contact via Telegram: @gleb923.