Automated Vendor Quotation Comparison with AI Summaries

This n8n workflow streamlines the process of collecting, analyzing, and sharing vendor quotations. It begins with a webhook trigger that accepts file uploads of vendor quotes in formats like PDF or Excel. The uploaded files are then parsed through a code node to extract key data points such as vendor name, price, delivery time, and features. This data is sent to an AI summarization API, which generates a concise comparison summary using advanced language models. The workflow waits for the AI’s response before formatting the summary into a structured table. This table is then logged into a Google Sheet for record-keeping. Finally, the curated comparison is emailed to stakeholders, facilitating quick decision-making. This automation is ideal for procurement teams or project managers seeking to efficiently evaluate multiple vendor bids, saving time and reducing manual errors.