Operations · Intermediate

Vendor quote collection and comparison

Extract pricing details and line items from vendor emails into a structured comparison table

Use with BotBento Markdown

Opens BotBento. Paste the prompt into a bot; nothing is preconfigured.

  1. When something happensVendor quote received via email
  2. ThenExtract pricing and delivery terms
  3. ResultPopulate comparison spreadsheet

Monitor an inbox for incoming vendor bids and proposals, parse pricing schedules, lead times, and unit costs from email bodies or attached files, and organize the information into a centralized spreadsheet for evaluation.

Prompt to start with

BotBentoRecommended
Monitor inbound emails for quotes and estimates. Parse message text and attached PDF estimates to extract item descriptions, quantities, unit prices, turnaround times, and validity dates. Enter the extracted data into the comparison spreadsheet. If details are missing or conflicting, draft a follow-up inquiry to the vendor. Never send emails, initiate orders, or delete any records without explicit user approval.