n8n Workflow: Contract Utilization Alerts with Groq & Google Sheets

Keep every contract on track—automatically

This n8n Workflow: Contract Utilization Alerts with Groq & Google Sheets runs every 6 hours to calculate contract utilization from your Google Sheets data, flag contracts that are too low or too high, and send Gmail and Slack alerts—using Groq to generate a recommended action for underutilized contracts.

What this workflow does

• Scheduled execution: Triggers every 6 hours to keep utilization reporting current.
• Reads active contracts: Loads contract rows from Google Sheets and keeps only active entries with a non-empty contract ID.
• Normalizes and merges spend: Pulls spend records from a separate Google Sheets tab, normalizes key fields, and merges spend with contracts by contract ID.
• Calculates utilization: Aggregates spend per contract and computes utilization as total spend ÷ total contract value.
• Low utilization (below 0.4): When a contract is underutilized, Groq generates a short insight and recommended action. The workflow writes utilization, risk, and action back to Google Sheets and sends alerts via Gmail and Slack.
• High utilization (above 0.9): When a contract is nearly fully utilized, the workflow updates the contract to inactive in Google Sheets and sends completion notifications via Gmail and Slack. Otherwise, it updates utilization and sets “No action required”.

Use cases

• Alert finance/ops teams when a contract’s spend is lagging so they can intervene early.
• Automatically close or mark contracts inactive once utilization crosses a high threshold.
• Give decision-ready guidance for underutilized contracts by writing Groq-generated insights into your contract tracking sheet.

Technical details

• Integrations: Google Sheets, Gmail, Slack
• Groq usage: Generates short insights and recommended actions for contracts with utilization < 0.4
• Core n8n nodes / logic: if, set, code, gmail, merge, slack
• Setup requirements: Add Google Sheets credentials and configure spreadsheet ID and the Contracts and spend sheet names. Ensure Contracts includes columns for updates (e.g., contract_id, total_value, status, utilization, risk, action, last_updated) and the spend sheet includes spend_id, contract_id, and amount.