Back to Templates
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.
Chat Trigger - Start
node.Fetch Airline URLs
node.Scrape Airline Webpage
node.Extract info with LLM
node with a Chat Model.Wait for Response
node.Store Extracted Data
node.Generate Embeddings
node and store in Postgres vector DB with the Save to Vector DB
node.Split Long Text
node and delay the next batch with the Wait Before Next Batch
node.Tweak the Extract info with LLM
node to adjust JSON output or modify the Fetch Airline URLs
node to pull from different sheet fields.