Score content virality with OpenAI, Google Sheets and Slack
Needs changesWhat this workflow does
This AI workflow has 20 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 hooks.slack.com, api.sendgrid.com and sheets.googleapis.com over HTTP.
How it runs
Trigger: When an HTTP POST request hits its webhook URL (plus 1 other trigger).
- Normalize Content Input (Edit Fields (Set)): sets 8 fields: title, body, platform…
- Python - Validate Content Input (Code): runs custom Python code
- Filter: keeps only the items that match a condition
- Load Platform Config (Edit Fields (Set)): sets 2 fields: platform_config, scoring_weights
- Fetch Historical Performance Data (HTTP Request): calls an HTTP API
- Fetch Trending Topics & Signals (HTTP Request): calls an HTTP API
- Fetch Audience Behavior Signals (HTTP Request): calls an HTTP API
- Python - Merge & Normalize Signals (Code): runs custom Python code
- Wait: pauses before continuing
- AI - Virality Score & Analysis (AI Agent): runs an AI agent, with model: OpenAI Chat Model
…plus 7 more steps. See the full node list below.
Services it uses
HTTP calls to: hooks.slack.com, api.sendgrid.com, sheets.googleapis.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 - Virality Score & Analysis (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 - Virality Score & Analysis (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 - Code
n8n-nodes-base.code - Filter
n8n-nodes-base.filter - HTTP Request
n8n-nodes-base.httpRequest - Wait
n8n-nodes-base.wait - AI Agent
@n8n/n8n-nodes-langchain.agent - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Respond to Webhook
n8n-nodes-base.respondToWebhook
From the author
Quick Overview This workflow accepts content submissions via webhook or a weekday schedule, pulls historical performance from Google Sheets, fetches trend and audience signals via HTTP APIs, uses OpenAI to predict a 0–100 virality score with recommendations,…