Tips for Procurement

📌 TLDR Summary Revolutionize your procurement efficiency: use AI to automate spend categorization, accelerate RFPs, synthesize complex contracts, streamline invoice approvals, and transform your supplier QBRs into engaging video narratives. 🚀 Spend Analysis - Tool: Google Sheets with Embedded AI - The Fix: Manually cleaning and categorizing thousands of raw transaction lines is tedious and error-prone. This trick automates data classification and outlier detection instantly. - How to do it: 1. Open your transaction export file in Google Sheets. 2. Locate and click the "Help me organize" star icon in the sidebar. 3. Enter the prompt: "Categorize these transaction descriptions by procurement category and identify any spend that deviates from the average." 🚀 Strategic Sourcing - Tool: Standard LLMs (Gemini / ChatGPT) - The Fix: Writing complex RFPs from scratch consumes hours of focus time. Use LLMs to generate professional, comprehensive templates based on your specific industry requirements. - How to do it: Draft a detailed RFP for [Service/Category], including a scope of work section, 5 mandatory technical requirements, a clear scoring rubric for vendor evaluation, and a 4-week timeline for proposal submission. 🚀 Contract Management - Tool: NotebookLM - The Fix: Locating specific clauses or liability terms across hundreds of pages of legal documentation is a major bottleneck. NotebookLM allows you to chat with your documents for instant retrieval. - How to do it: 1. Navigate to NotebookLM and create a new notebook. 2. Upload all relevant supplier contracts as PDF sources. 3. Use the chat interface to ask specific questions like, "What are the liability caps and termination notice periods across all these contracts?" 🚀 Purchasing (Procure-to-Pay) - Tool: Gemini Enterprise (Workspace) - The Fix: Managing invoice approval cycles via fragmented email threads causes significant delays. Integrate Gemini into your Workspace to summarize threads and draft responses quickly. - How to do it: 1. Open the relevant email thread regarding a pending invoice in Gmail. 2. Click the "Ask Gemini" star icon in the top right corner. 3. Input the prompt: "Summarize this email thread and draft a professional response approving the invoice as it matches the purchase order, or flag if there is a discrepancy." 🚀 Supplier Relationship Management (SRM) - Tool: Google Vids - The Fix: Standard PowerPoint QBRs are often ignored or unread by stakeholders. Convert your performance metrics into short, engaging video briefs that communicate value effectively. - How to do it: 1. Open Google Vids and select "Help me create." 2. Input a prompt summarizing your supplier’s performance, such as "Create a 2-minute summary video highlighting our top 3 successes and 2 improvement areas from our quarterly QBR data." 3. Customize the visual storyboard and share the generated link with your supplier for a high-impact review.