Simulate business decisions with Google Sheets, GPT-4.1 and Slack
Needs changesWhat this workflow does
This AI workflow has 15 nodes and runs when an HTTP POST request hits its webhook URL (plus 1 other trigger). Along the way it connects OpenAI Chat Model. It also calls sheets.googleapis.com and hooks.slack.com over HTTP.
How it runs
Trigger: When an HTTP POST request hits its webhook URL (plus 1 other trigger).
- Prepare Scenario Context (Edit Fields (Set)): sets 6 fields: scenarioType, scenarioDescription, targetMetric…
- Filter: keeps only the items that match a condition
- Fetch Historical Data (HTTP Request): calls sheets.googleapis.com
- Python - Parse & Summarize History (Code): runs custom Python code
- Wait: waits 1 minutes
- JS - Build Prompt Context (Code): runs custom JavaScript code
- Wait: pauses before continuing
- AI - Simulate Outcomes (AI Agent): runs an AI agent, with model: OpenAI Chat Model
- JS - Format Simulation Report (Code): runs custom JavaScript code
- Log Simulation to Google Sheet (HTTP Request): calls sheets.googleapis.com (POST)
…plus 2 more steps. See the full node list below.
Services it uses
HTTP calls to: sheets.googleapis.com, hooks.slack.com
Before you upgrade to n8n 3.0
1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:
- AI Agent v1 (old agent modes) in AI - Simulate Outcomes (v1.6): replace with Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent.
Rather not rewrite it? Many of these flows can be rebuilt in Make (free plan).
| Removed in 3.0 | Replace with |
|---|---|
| AI Agent v1 (old agent modes) AI - Simulate Outcomes (v1.6) | Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent. |
Nodes used (10)
- Webhook
n8n-nodes-base.webhook - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Edit Fields (Set)
n8n-nodes-base.set - Filter
n8n-nodes-base.filter - HTTP Request
n8n-nodes-base.httpRequest - Code
n8n-nodes-base.code - Wait
n8n-nodes-base.wait - AI Agent
@n8n/n8n-nodes-langchain.agent - Respond to Webhook
n8n-nodes-base.respondToWebhook - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi
From the author
Quick Overview This workflow simulates business decision scenarios using Google Sheets data and AI analysis, generating what-if reports and recommendations for pricing, campaign, or hiring moves, and logs results to Google Sheets and Slack. How it works 1.…