Automate Airline Web Check-in Data Extraction and Storage
This workflow extracts airline web check-in information from Google Sheets, processes it using AI to generate structured JSON data, and stores it in a Postgres vector database for advanced search capabilities.
The workflow begins by fetching airline web check-in URLs from a Google Sheet. It then scrapes the webpage content and uses a language model to extract structured data in JSON format. This data is updated back into the Google Sheet and embeddings are created for semantic search, which are stored in a Postgres vector database. This setup allows for efficient data retrieval and question-answering based on the stored information.
- Platform
- n8n
- Category
- AI
- Price
- $9.99
- Creator
- Isla Campbell
- wait
- stickyNote
- httpRequest
- googleSheets
- splitInBatches
- chainLlm
- chatTrigger
- lmChatOllama
- embeddingsOllama
- vectorStorePGVector
How to import this workflow into n8n
- 1Purchase or download the workflow to get the n8n workflow JSON file.
- 2In your n8n instance, open Workflows and choose "Import from File" (or paste the JSON with Ctrl+V on the canvas).
- 3Open each node marked with a credential warning and connect your own accounts and API keys.
- 4Run the workflow once manually to verify the data flow, then toggle it to Active.
Related AI workflows
- Launch Your First AI-Powered Chatbot with Actionable Tools$9.99
- Automate AI Video Creation and YouTube Upload with Google Sheets$14.99
- Build a WhatsApp Assistant with Memory, Google Suite, Multi-AI, Research, and Imaging$24.99
- Automate Blog Post Creation and Publishing with GPT, Leonardo AI, and WordPress$14.99
- Email Agent$500.99
- Automate SEO Keyword Generation with ChatGPT from Google Sheets$3.99
More from Isla Campbell
Need this deployed? We'll set it up for you.
Our automation experts deploy this workflow in your stack, connect your accounts, and verify it works — or build a custom solution from scratch.