Social media analysis and automated email generation
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 13 nodes and runs on Google Sheets events. Along the way it connects OpenAI Chat Model and Google Sheets.
How it runs
Trigger: On Google Sheets events.
- If: checks a condition and branches into true / false
- Set your company's variables (Edit Fields (Set)): sets or maps fields
- Get twitter ID (HTTP Request): calls an HTTP API
- Get tweets (HTTP Request): calls an HTTP API
- Exract and limit X (Code): runs custom JavaScript code
- Get linkedin Posts (HTTP Request): calls an HTTP API
- Extract and limit Linkedin (Code): runs custom JavaScript code
- Generate Subject and cover letter based on match (Basic LLM Chain): sends a prompt to an LLM, with model: OpenAI Chat Model; output parser: Structured Output Parser
- Send Cover letter and CC me (Send Email): sends an email over SMTP
- Google Sheets: uses Google Sheets
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
- Still check Always Output Data on multi-output nodes (If/Switch) now adds an empty item only when every output is empty (If).
Nodes used (10)
- Edit Fields (Set)
n8n-nodes-base.set - HTTP Request
n8n-nodes-base.httpRequest - Code
n8n-nodes-base.code - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - Send Email
n8n-nodes-base.emailSend - Google Sheets Trigger
n8n-nodes-base.googleSheetsTrigger - Google Sheets
n8n-nodes-base.googleSheets - If
n8n-nodes-base.if
From the author
Social Media Analysis and Automated Email Generation > by Thomas Vie [email protected] Who is this for? This template is ideal for marketers, lead generation specialists, and business professionals seeking to analyze social media profiles of potential…