Airline web check-in data extraction with Ollama AI, Google Sheets & Postgres Vector DB
Overview This workflow retrieves airline web check-in URLs from Google Sheets, scrapes their content, employs an LLM to generate structured JSON data, refreshes the sheet, creates embeddings, and saves them in a Postgres vector DB for future semantic searches or question-answering. Quick Notes - Verify that Google Sheets has accurate URLs for scraping. - Ensure the Postgres vector DB is set up correctly for embedding storage. Process Flow 1. Start the workflow with the Chat Trigger - Start node
At a glance
Airline web check-in data extraction with Ollama AI, Google Sheets & Postgres Vector DB is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Google Sheets. It's free to download. Follow the 5-step import below to go live in minutes.
- Platform
- n8n
- Connects
- Google Sheets
- Modules
- 13
- Price
- Free
- Version
- v1.0

About this workflow
Overview This workflow retrieves airline web check-in URLs from Google Sheets, scrapes their content, employs an LLM to generate structured JSON data, refreshes the sheet, creates embeddings, and saves them in a Postgres vector DB for future semantic searches or question-answering. Quick Notes - Verify that Google Sheets has accurate URLs for scraping. - Ensure the Postgres vector DB is set up correctly for embedding storage. Process Flow 1. Start the workflow with the Chat Trigger - Start node. 2. Retrieve airline check-in URLs using the Fetch Airline URLs node. 3. Scrape webpage data with the Scrape Airline Webpage node. 4. Extract JSON data using the Extract info with LLM node with a Chat Model. 5. Pause for a response with the Wait for Response node. 6. Update Google Sheets with the Store Extracted Data node. 7. Create embeddings with the Generate Embeddings node and store in Postgres vector DB with the Save to Vector DB node. 8. Break down long text with the Split Long Text node and delay the next batch with the Wait Before Next Batch node. Getting Started - Import the workflow into n8n and set up Google Sheets and Postgres vector DB credentials. - Run a test with a sample URL to confirm scraping and embedding storage. Tailored Adjustments Tweak the Extract info with LLM node to adjust JSON output or modify the Fetch Airline URLs node to pull from different sheet fields.
How to import this n8n workflow
- 1
Download the workflow JSON file after purchase.
- 2
Open n8n → click the menu → Import from File.
- 3
Select the downloaded JSON and import.
- 4
Set up credentials for each node that requires them.
- 5
Click Execute Workflow to test, then activate.
Setup guide
Setup guide included
Purchase to unlock the full step-by-step guide
Related N8n workflows
Create a Revolut Business draft payment for shipping and send a Slack notification from a new WooCommerce order
Send data to Google Sheets after parsing JSON from an action event
Build production-ready user authentication with Airtable and JWT
Send data to Google Sheets from an action trigger
Trigger Smaily Automation Workflow with data from Google Sheets
Send Slack alerts for technology usage
Sequential Google Sheets data processing with execution control
Generate logos and images with consistent visual styles using Imagen 3.0
Reviews
No reviews yet
Be the first to buy and share your experience.
Leave a review
Sign in to share your experience with this workflow.
Create a free account to purchase workflows.
- JSON blueprint — instant download
- Setup guide PDF included
- 5 downloads · valid 30 days
- Works with n8n
Need help setting this up?
Book a 3-hour live setup session with an Agility consultant.
- Configure live on Google Meet / Zoom
- Free follow-up if workflow has defects
- Platform expert assigned to you