Compare Vendor Quotations with AI and Log to Google Sheets & Email
This workflow automates the process of receiving vendor quotations uploaded to Google Drive. It extracts text from the document, uses AI to extract key fields and then summarize and compare the contents, logs the results into Google Sheets, and sends an email notification to stakeholders.
Apps Used:
Google Drive
Google Sheets
Gmail
OpenAICategories:
How It Works
- 1When a new file is added to a Google Drive folder.
- 2Extract text from the uploaded document using appropriate tools (e.g., PDF OCR for PDFs, Google Docs node for Docs, Google Sheets node for Sheets).
- 3Use AI to extract key fields like vendor name, price, and items.
- 4Then, use AI to summarize and compare the extracted vendor quotation.
- 5Add the AI-generated comparison summary as a new row in Google Sheets.
- 6Send an email with the summary to relevant stakeholders.
Related Templates
Extract Invoice Data from Gmail to Google Sheets with AI
This workflow monitors your Gmail for new emails containing PDF invoice attachments. It uses AI to extract key financial data such as company information, invoice numbers, line items, and taxes from the PDF. Finally, it creates a new Google Sheet, populates it with the extracted data, and organizes the file in Google Drive for accounting purposes.
AI Resume Screening & Evaluation for HR with AI & Google Workspace
This workflow automates the screening and evaluation of job applications. When a candidate submits their application, their CV is uploaded to Google Drive. The system then uses AI to extract candidate information from the CV, retrieves the relevant job description from Google Sheets and Google Drive, and evaluates the candidate against the job requirements. Finally, it stores the results in Google Sheets and sends conditional notifications via Gmail or Slack.
Extract Invoice Data from Google Drive PDFs with AI and Email Alerts
This workflow automatically triggers when a new PDF invoice is uploaded to a specified Google Drive folder. It extracts key invoice details using AI, logs this data into a Google Sheet, and then generates and sends an email alert to the billing team via Gmail with a summary of the processed invoice.
Process Logistics Orders from Gmail with AI and Google Sheets
This workflow triggers when a new email containing an inbound order is received in Gmail. It then uses an AI model to extract key order details such as PO number, delivery date, SKU ID, and quantity from the email body. Finally, the extracted information is automatically added as a new row to a specified Google Sheet for logistics tracking.
Automate Employee Reimbursement Workflow with AI and Google Suite
This workflow automates the employee reimbursement process. When an employee submits a receipt via email, the system uses AI to extract key details and checks for duplicates. It then uploads the receipt to Google Drive, logs all the data in Google Sheets, and finally sends a comprehensive email notification to the finance team for payment processing.
AI-Powered PDF Invoice Parser with Google Drive and Google Sheets
This workflow automates invoice processing by monitoring a Google Drive folder for new PDF invoices. Upon detection of a new PDF, it extracts text content using OCR, then uses AI to parse and extract key invoice details like invoice number, date, and total amount. Finally, it stores the extracted, structured data into a Google Sheet for easy access and reporting.