Score LinkedIn comments and draft replies with Azure OpenAI and Google Sheets
Needs changesWhat this workflow does
This AI workflow has 17 nodes and runs on a schedule (legacy Cron node) (plus 2 other triggers). Along the way it connects Google Sheets, Gmail, Azure OpenAI Chat Model and Serpapi (community) and 1 more.
How it runs
Trigger: On a schedule (legacy Cron node) (plus 2 other triggers).
- Search LinkedIn Posts via SerpAPI (Serp Api): uses Serp Api
- AI Reply Drafting Agent (AI Agent): runs an AI agent, with model: Azure OpenAI Chat Model
- Build Media Team Email Report (Code): runs custom JavaScript code
- Parse & Filter Search Results (Code): runs custom JavaScript code
- Format Reply for Sheet Update (Code): runs custom JavaScript code
- Send Email Report to Media Team (Gmail): uses Gmail
- Fetch Post Comments via ConnectSafely (Connect Safely Linked In): get all post comments
- Write AI Reply Back to Google Sheet (Google Sheets): append or update
- Flatten Comments into Rows (Code): runs custom JavaScript code
- AI Sentiment & Intent Detection Agent (AI Agent): runs an AI agent, with model: Azure OpenAI Chat Model
…plus 2 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:
- Cron in Trigger Every 15 Minutes1: replace with Schedule Trigger.
Rather not rewrite it? Many of these flows can be rebuilt in Make (free plan).
| Removed in 3.0 | Replace with |
|---|---|
| Cron Trigger Every 15 Minutes1 | Schedule Trigger |
Nodes used (9)
- Cron
n8n-nodes-base.cron - AI Agent
@n8n/n8n-nodes-langchain.agent - Code
n8n-nodes-base.code - Google Sheets
n8n-nodes-base.googleSheets - Google Sheets Trigger
n8n-nodes-base.googleSheetsTrigger - Gmail
n8n-nodes-base.gmail - Serp Api
n8n-nodes-serpapi.serpApi - Connect Safely Linked In
n8n-nodes-connectsafely-ai.connectSafelyLinkedIn - Azure OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatAzureOpenAi
From the author
📊 Description Automate LinkedIn comment monitoring and turn conversations into qualified sales opportunities using AI 🤖. This intelligent agent continuously scans LinkedIn posts mentioning your brand, analyzes every comment for buyer intent and sentiment,…