AI Bid Evaluation Agent: Gmail-Triggered Bid Extraction, Scoring & Approval Routing to Airtable

Problem:

A business receiving bid submissions via email had no automated way to extract structured bid details, evaluate and score each bid against approval criteria, and route results to their database, every bid required manual reading, assessment, and data entry, slowing down procurement decisions significantly.

Solution:

Built a Gmail-triggered n8n workflow that passes each incoming bid email through an Extract Bid Details AI agent (OpenAI + structured output parser) to pull all relevant data, splits the response into individual bid objects, runs parallel processing, formatting URLs and scoring each bid through a dedicated Score Bid AI agent with its own structured output parser, then merges results, calculates approval status automatically, sends the extracted and scored data to Airtable, and routes approved bids via HTTP request to downstream systems.

Result:

Delivered a fully automated bid processing pipeline that reads, extracts, scores, and routes every inbound bid without manual review, approval decisions are calculated automatically and all bid data lands in Airtable structured and ready for action the moment the email arrives.