{"product_id":"n8n-workflow-contract-utilization-alerts-with-groq-google-sheets","title":"n8n Workflow: Contract Utilization Alerts with Groq \u0026 Google Sheets","description":"\u003ch3\u003eKeep every contract on track—automatically\u003c\/h3\u003e\n\u003cp\u003eThis \u003cstrong\u003en8n Workflow: Contract Utilization Alerts with Groq \u0026amp; Google Sheets\u003c\/strong\u003e runs every 6 hours to calculate contract utilization from your Google Sheets data, flag contracts that are too low or too high, and send \u003cstrong\u003eGmail\u003c\/strong\u003e and \u003cstrong\u003eSlack\u003c\/strong\u003e alerts—using \u003cstrong\u003eGroq\u003c\/strong\u003e to generate a recommended action for underutilized contracts.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScheduled execution:\u003c\/strong\u003e Triggers \u003cem\u003eevery 6 hours\u003c\/em\u003e to keep utilization reporting current.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads active contracts:\u003c\/strong\u003e Loads contract rows from Google Sheets and keeps only active entries with a \u003cstrong\u003enon-empty contract ID\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalizes and merges spend:\u003c\/strong\u003e Pulls spend records from a separate Google Sheets tab, normalizes key fields, and merges spend with contracts by \u003cstrong\u003econtract ID\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCalculates utilization:\u003c\/strong\u003e Aggregates spend per contract and computes utilization as \u003cstrong\u003etotal spend ÷ total contract value\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLow utilization (below 0.4):\u003c\/strong\u003e When a contract is underutilized, \u003cstrong\u003eGroq\u003c\/strong\u003e generates a short insight and recommended action. The workflow writes \u003cstrong\u003eutilization\u003c\/strong\u003e, \u003cstrong\u003erisk\u003c\/strong\u003e, and \u003cstrong\u003eaction\u003c\/strong\u003e back to Google Sheets and sends alerts via \u003cstrong\u003eGmail\u003c\/strong\u003e and \u003cstrong\u003eSlack\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eHigh utilization (above 0.9):\u003c\/strong\u003e When a contract is nearly fully utilized, the workflow updates the contract to \u003cstrong\u003einactive\u003c\/strong\u003e in Google Sheets and sends completion notifications via \u003cstrong\u003eGmail\u003c\/strong\u003e and \u003cstrong\u003eSlack\u003c\/strong\u003e. Otherwise, it updates utilization and sets \u003cstrong\u003e“No action required”\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eAlert finance\/ops teams when a contract’s spend is lagging so they can intervene early.\u003c\/li\u003e\n  \u003cli\u003eAutomatically close or mark contracts inactive once utilization crosses a high threshold.\u003c\/li\u003e\n  \u003cli\u003eGive decision-ready guidance for underutilized contracts by writing Groq-generated insights into your contract tracking sheet.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e Google Sheets, Gmail, Slack\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGroq usage:\u003c\/strong\u003e Generates short insights and recommended actions for contracts with utilization \u0026lt; 0.4\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCore n8n nodes \/ logic:\u003c\/strong\u003e \u003cem\u003eif\u003c\/em\u003e, \u003cem\u003eset\u003c\/em\u003e, \u003cem\u003ecode\u003c\/em\u003e, \u003cem\u003egmail\u003c\/em\u003e, \u003cem\u003emerge\u003c\/em\u003e, \u003cem\u003eslack\u003c\/em\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSetup requirements:\u003c\/strong\u003e Add Google Sheets credentials and configure spreadsheet ID and the Contracts and spend sheet names. Ensure Contracts includes columns for updates (e.g., \u003cstrong\u003econtract_id\u003c\/strong\u003e, \u003cstrong\u003etotal_value\u003c\/strong\u003e, \u003cstrong\u003estatus\u003c\/strong\u003e, \u003cstrong\u003eutilization\u003c\/strong\u003e, \u003cstrong\u003erisk\u003c\/strong\u003e, \u003cstrong\u003eaction\u003c\/strong\u003e, \u003cstrong\u003elast_updated\u003c\/strong\u003e) and the spend sheet includes \u003cstrong\u003espend_id\u003c\/strong\u003e, \u003cstrong\u003econtract_id\u003c\/strong\u003e, and \u003cstrong\u003eamount\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45865754656947,"sku":"N8N-18395","price":34.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/YmhbIg4JkLYAvVB-3ek9E_QlQPaqsg.png?v=1787043701","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-contract-utilization-alerts-with-groq-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}