AI-powered airline data extraction to JSON & Sheets

# Airline data extraction via webhook: AI to Google Sheets and PGVector

This workflow automates the collection and structuring of information from airline websites — including online check-in rules, baggage allowances, customer support contacts, and cancellation policies. Structured JSON is generated and stored, while embeddings are created in a vector database for fast semantic retrieval. Designed for developers, analysts, and travel tech platforms.

## Who it´s for
- Airlines seeking to systematize their public-facing policies.
- Booking platforms requiring up-to-date check-in and baggage data.
- Chatbot developers serving travelers.
- Analysts building knowledge bases on carrier policies.
- Flight aggregators updating info directly from airline sites.

## What the automation does
- Triggered via HTTP webhook or chat command.
- Fetches a list of airline URLs from Google Sheets.
- Scrapes page content using Jina AI Scraper.
- Processes text with an Ollama-powered LLM via LangChain to extract structured data.
- Stores extracted JSON back into Google Sheets.
- Indexes data into PGVector as embeddings for semantic search.

## What´s included
- Ready-to-use n8n workflow.
- Webhook trigger and Google Sheets reader logic.
- Integrations with Jina AI Scraper, Ollama, Google Sheets API, and PostgreSQL (PGVector).
- Basic written instructions for setup and adaptation.

## Requirements for setup
- n8n instance with external API access.
- Google Sheets account with read/write permissions.
- Running Ollama instance (local or cloud) with a suitable model (e.g., llama3).
- PostgreSQL database with PGVector extension enabled.
- Jina AI Scraper API key if authentication is required.

## Benefits and outcomes
- Eliminates manual data collection from dozens of airline websites.
- Enables automatic updates to a centralized sheet and vector DB.
- Powers fast, accurate responses via semantic search.
- Feeds precise, current data to AI chatbots.
- Centralized rule storage independent of human input.
- Scalable: add new URLs with a single entry.

## 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 chat