Monitor brand sentiment with Reddit, Hacker News, Google News and GPT-4o mini
Needs changesWhat this workflow does
This AI workflow has 16 nodes and runs on a schedule (cron 0 */4 * * *). Along the way it connects OpenAI Chat Model, Google Sheets and Gmail. It also calls google.serper.dev over HTTP.
How it runs
Trigger: On a schedule (cron 0 */4 * * *).
- Set config (Edit Fields (Set)): sets 10 fields: brandName, competitor1Name, competitor2Name…
- Search Reddit (HTTP Request): calls an HTTP API
- Search Hacker News (HTTP Request): calls an HTTP API
- Search the news (HTTP Request): calls google.serper.dev (POST)
- Combine the mentions (Code): runs custom JavaScript code
- Any mentions? (If): checks a condition and branches into true / false
- Analyse the mentions (AI Agent): runs an AI agent, with model: Chat model; output parser: Output Parser - Intelligence
- Nothing this window (Edit Fields (Set)): sets 1 field: status
- Build the alert (Code): runs custom JavaScript code
- Log to the sheet (Google Sheets): append
…plus 3 more steps. See the full node list below.
Services it uses
HTTP calls to: google.serper.dev
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 Analyse the mentions (v1.7): 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) Analyse the mentions (v1.7) | Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent. |
Nodes used (10)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Edit Fields (Set)
n8n-nodes-base.set - HTTP Request
n8n-nodes-base.httpRequest - Code
n8n-nodes-base.code - If
n8n-nodes-base.if - AI Agent
@n8n/n8n-nodes-langchain.agent - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Google Sheets
n8n-nodes-base.googleSheets - Gmail
n8n-nodes-base.gmail
From the author
Quick Overview This workflow runs every four hours to search Reddit, Hacker News, and Google News (via Serper) for mentions of your brand and competitors, uses OpenAI to analyze sentiment and crisis level, logs each run to Google Sheets, and sends a Gmail…