Monitor procurement spend and risks with Google Sheets, Groq Llama and Gmail

by WeblineIndia ✓ · 17 views · created 2026-07-20 · Market Research, AI Summarization

What this workflow does

This AI workflow has 17 nodes and runs on a schedule (every 15 minutes). Along the way it connects Google Sheets, Groq Chat Model and Gmail.

How it runs

Trigger: On a schedule (every 15 minutes).

1. Fetch Procurement Transactions (Google Sheets): uses Google Sheets
2. Fetch Department Budgets (Google Sheets): uses Google Sheets
3. Merge: merges the data from its input branches
4. Spend Intelligence Engine (Code): runs custom JavaScript code
5. AI Procurement Risk Analyzer (AI Agent): runs an AI agent, with model: Groq Chat Model
6. Generate Executive Dashboard Metrics (Code): runs custom JavaScript code
7. Prepare Dashboard Metadata (Edit Fields (Set)): sets 5 fields: workflow_name, workflow_version, environment…
8. Transform Dashboard For Sheets (Code): runs custom JavaScript code
9. Route Dashboard Records (Switch): routes items into 3 branches
10. Store Executive Summary (Google Sheets): append

…plus 4 more steps. See the full node list below.

Services it uses

Google SheetsGroq Chat ModelGmail

Before you upgrade to n8n 3.0

Nodes used (11)

• Google Sheetsn8n-nodes-base.googleSheets
• Coden8n-nodes-base.code
• Groq Chat Model@n8n/n8n-nodes-langchain.lmChatGroq
• Switchn8n-nodes-base.switch
• No Operation, do nothingn8n-nodes-base.noOp
• Schedule Triggern8n-nodes-base.scheduleTrigger
• Mergen8n-nodes-base.merge
• AI Agent@n8n/n8n-nodes-langchain.agent
• Ifn8n-nodes-base.if
• Gmailn8n-nodes-base.gmail
• Edit Fields (Set)n8n-nodes-base.set

From the author

Quick Overview This workflow runs every 15 minutes to pull procurement transactions and department budgets from Google Sheets, calculate spend utilization and forecasts, generate executive risk insights with Groq Llama, write dashboard records back to Google…

View the original on n8n.io → Check your own copy