Optimize Tender PDFs: LlamaParse & WhatsApp Automation Workflow

Streamline Tender Management with LlamaParse & WhatsApp Automation Workflow

Elevate your tender management process by seamlessly integrating PDF parsing and comprehensive Q&A capabilities directly in WhatsApp. With our cutting-edge workflow, you can extract critical tender data, organize it in Google Sheets, and make it instantly chat-searchable for quick access and streamlined communication.

What this Workflow Does

• Receive and Process Tenders: Upload tender PDF documents through an n8n form, automatically generating a normalized document ID for streamlined management.
• Advanced PDF Parsing: Utilize LlamaParse to extract full-text data and essential metadata, including predefined tender sections, for accurate record-keeping.
• Organize and Track: Normalize extracted data, compute days-until-deadline and bid scores, then update your Google Sheets tender tracker, ensuring you never miss a deadline.
• Create Embeddings for Q&A: Convert parsed text into paragraph-aligned chunks and generate embeddings via Google Gemini, storing them in Supabase for instant retrieval.
• WhatsApp Integration for Instant Queries: Upon receiving a query via WhatsApp, conduct a vector search using Supabase, powered by Google Gemini embeddings, to deliver context-aware responses using the Anthropic DeepSeek model.

Use Cases

• Simplified Tender Analysis: Ideal for organizations handling multiple tender submissions, this workflow provides structured metadata extraction for seamless tracking and analysis.
• Real-time Engagement: Empower your team with the ability to ask and receive contextually accurate answers via WhatsApp on-the-go, enhancing collaboration and decision-making.
• Enhanced Document Management: Streamline the organization and retrieval of tender documents with Google Sheets integration and Supabase storage for efficient document management.

Technical Details

• Integrations Used: LlamaParse, Google Sheets, Google Gemini Embeddings API, Supabase, Anthropic/DeepSeek for Q&A, WhatsApp
• Nodes Included: Code, Merge, Supabase, WhatsApp, Sticky Note, Form Trigger