Optimize Supplier Spend with Google Sheets & Slack Automation

Optimize Supplier Spend with Google Sheets & Slack Automation

Streamline your supplier management process with an innovative automation workflow that leverages Google Sheets, Slack, and advanced AI analysis. This automated solution spotlights potential savings by detecting overlapping suppliers, evaluating consolidation opportunities, and delivering actionable insights through Slack and Gmail notifications.

What this workflow does

• Runs weekly on a scheduled trigger to ensure continuous optimization of supplier spend.
• Extracts critical data such as supplier name, department, spend, risk rating, and stakeholder email from your Google Sheets spreadsheet.
• Identifies suppliers utilized across multiple departments and calculates potential savings and opportunity levels for consolidation.
• Engages the Groq-hosted LLM analysis to assess risks and derive recommendations, returning a detailed JSON output.
• Merges AI insights with savings data to craft a comprehensive recommendation report.
• Communicates findings instantly by posting recommendations to a specified Slack channel and dispatching detailed emails to relevant stakeholders via Gmail.

Use cases

• Procurement Teams: Quickly identify cost-saving opportunities across departments by consolidating suppliers to leverage better pricing terms.
• Financial Analysts: Use automated weekly reports to gain insights into potential risks and savings without manual data collation.
• Operations Managers: Receive timely alerts about supplier consolidation opportunities, enhancing collaborative efforts across various departments.

Technical details

• Integrations: Google Sheets, Slack, Gmail
• Nodes used: Set, Code, Gmail, Merge, Slack, Sticky Note
• AI Model: Groq-hosted LLM
• Setup Requirements:
  • Connect Google Sheets OAuth account, updating spreadsheet ID and sheet/tab parameters.
  • Add Groq API credentials for risk evaluation and recommendation generation.
  • Add Slack credentials, designating a target channel for updates.
  • Ensure Gmail OAuth2 credentials are active, with valid supplier email data fields in your spreadsheet.