Social Media Analysis and Automated Email Generation

Personalize here Set: - your name - your company name - your company activity, used to find a match with your leads - your email, used as the sender

Workflow Structure (13 nodes)
100%
Google Sheets Trigger
Google Sheets Trigger
If
If
Set
Set your company's variables
Http Request
Get twitter ID
Http Request
Get tweets
Code
Exract and limit X
Http Request
Get linkedin Posts
Code
Extract and limit Linkedin
Langchain.chain Llm
Generate Subject and cover letter based on match
Langchain.lm Chat Open Ai
OpenAI Chat Model
Langchain.output Parser Structured
Structured Output Parser
Email Send
Send Cover letter and CC me
Google Sheets
Google Sheets
Node Types:
transform
http
code
default
action
trigger
logic
Requires credentials

Prerequisites

Required Credentials (5)

Google Sheets

Used by: Google Sheets

Docs

Google Sheets Trigger

Used by: Google Sheets Trigger

Docs

HTTP Header Auth

Used by: Get linkedin Posts, Get twitter ID +1 more

Docs

OpenAI

Used by: OpenAI Chat Model

Docs

Smtp

Used by: Send Cover letter and CC me

Docs

Multiple services required

This workflow needs 5 different credentials. Make sure you have accounts for all services before importing.

Complexity

Advanced

Expert level. Custom code, complex logic, many integrations.

Setup time: ~1 hour
Score: 80/100
Custom Code
Conditional Logic
4 Integrations

When to Use This Workflow

Streamline Team Communication

Automatically route notifications and updates to the right channels and people.

Reduce information overload while keeping everyone informed.

Automated Reporting

Automatically collect and organize data into spreadsheets for analysis.

Spend less time on data entry and more time on insights.

Email Automation

Automate email responses, forwarding, or organization based on rules.

Handle routine email tasks automatically and focus on what matters.

workflow.json
{
  "nodes": [
    {
      "id": "a768bce6-ae26-464c-95fc-009edea4f94d",
      "name": "Set your company's variables",
      "type": "n8n-nodes-base.set",
      "position": [
        440,
        0
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "6a8063b6-1fd8-429a-9f13-b7512066c702",
              "name": "your_company_name",
              "type": "string",
              "value": "Pollup Data Services"
            },
...

Workflow Details

Nodes
19
Trigger
Event
Source
awesome
Added
Dec 4, 2025

Need Help?

Check out the official n8n documentation for detailed guides.

Related Workflows

Classify lemlist replies using OpenAI and automate reply handling

Get your lemlist API key 1. Go to your lemlist account or create one [HERE](https://app.lemlist.com/create-account) 2. G...

Lemlist
Lmchatopenai
Outputparserstructured
Slack
18 nodesEvent
Curated

AI-Powered Information Monitoring with OpenAI, Google Sheets, Jina AI and Slack

LLM Call 1 - Article Topic Relevance Classification This LLM call is used to classify whether the articles published on...

Lmchatopenai
Chainllm
Schedule
Rssfeedread
31 nodesScheduled
Curated

Auto-label incoming Gmail messages with AI nodes

Add AI labels to Gmail messages With this workflow you can automatically set labels for your Gmail message according to...

Gmail
Chainllm
Outputparserstructured
Lmchatopenai
19 nodesEvent
Curated

Extract spend details (template)

A. Get data - Set up labels in Gmail - Suggested using Gmail filters to move emails to labels automatically

Gmail
Outputparserstructured
Lmchatgooglegemini
Google-sheets
24 nodesEvent
Curated

Contact Form Text Classifier for eCommerce

Important notes This very simple workflow is ideal for eCommerce businesses or customer support teams looking to automat...

Form
Textclassifier
Lmchatopenai
Emailsend
14 nodesEvent
Curated

Gmail AI auto-responder: create draft replies to incoming emails

When I receive an Email

Gmail
Outputparserstructured
Lmchatopenai
Chainllm
12 nodesEvent
Curated