AutomationMart
Home/Browse/Airline web check-in data extraction with Ollama AI, Google Sheets & Postgres Vector DB
n8n

Airline web check-in data extraction with Ollama AI, Google Sheets & Postgres Vector DB

n8nn8n13 modulesv1.0
Google Sheets

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
Airline web check-in data extraction with Ollama AI, Google Sheets & Postgres Vector DB workflow diagram

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.

n8n

How to import this n8n workflow

  1. 1

    Download the workflow JSON file after purchase.

  2. 2

    Open n8n → click the menu → Import from File.

  3. 3

    Select the downloaded JSON and import.

  4. 4

    Set up credentials for each node that requires them.

  5. 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

Use this template to create a Revolut draft payment to a courier and send a Slack notification once a WooCommerce order is created. The setup of the template assumes you have your shipping and courier data stored in 2 separate Google Sheets. Sheet #1 has to include these columns: Country, Name of the courier, Shipping fee. Sheet #2 has to include these columns: Name of the courier and payment details. To see which details are required to create a Revolut draft payment depending on the country

Free

Send data to Google Sheets after parsing JSON from an action event

Automatically parse JSON from action events and send data to Google Sheets. Streamline data management with HTTP, JSON, and Google Sheets integration.

Free

Build production-ready user authentication with Airtable and JWT

This n8n workflow provides a comprehensive solution for user authentication and management, leveraging Airtable as the backend database. It includes flows for user sign-up and login, aswell as the sample crud operations retrieving user details, and updating user information. Youtube Video of me explaining the flow: How it Works User Sign-Up Flow 1. Receives POST request: A webhook listens for POST requests containing new user details (email, first name, last name, password). 2. Checks for exist

Free

Send data to Google Sheets from an action trigger

Trigger an action to send data to Google Sheets from an app. Automatically add a new row with HTTP.

Free

Trigger Smaily Automation Workflow with data from Google Sheets

When a new row with data is created in Google Sheets, the data are sent to Smaily and the automation workflow is triggered.

Free

Send Slack alerts for technology usage

This template helps you track companies based on the technologies they use and receive alerts in Slack. It starts with a technology name from Google Sheets, finds companies using that technology via PredictLeads, enriches each company with firmographic data, and optionally adds detailed technology context. The results are sent to Slack, enabling teams to monitor technology adoption and spot relevant opportunities in real time.

Free

Sequential Google Sheets data processing with execution control

Preventing Simultaneous Executions of Scheduled Workflows This n8n template provides a robust solution for processing data from Google Sheets in a controlled manner, specifically designed to prevent simultaneous executions of a scheduled workflow. This is crucial for maintaining data integrity, avoiding race conditions, and ensuring that your automated processes handle data sequentially. What This Workflow Does and Why It's Important Many automated tasks involve processing a list of items, like

Free

Generate logos and images with consistent visual styles using Imagen 3.0

This n8n template allows you to use AI to generate logos or images which mimic visual styles of other logos or images. The model used to generate the images is Google's Imagen 3.0. With this template, users will be able to automate design and marketing tasks such as creating variants of existing designs, remixing existing assets to validate different styles and explore a range of designs which would have been otherwise too expensive and time-consming previously. ![banner](

Free

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.

Log in to review
Free
No ratings yet

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.

₹2,499/ session
3 hrs · video call
  • Configure live on Google Meet / Zoom
  • Free follow-up if workflow has defects
  • Platform expert assigned to you
Book installation session
Free