AutomationFlowsAI & RAG › Track Top Social Media Trends with Reddit, Twitter, and Gpt-4o to Sp/drive

Track Top Social Media Trends with Reddit, Twitter, and Gpt-4o to Sp/drive

Byplemeo @plemeo on n8n.io

Content creators, marketers, journalists, and product teams who need a quick, automated snapshot of what the internet is talking about—served as a ready-to-use spreadsheet every morning. Manual Trigger / Cron starts the flow. Set Config picks today’s date and a topic keyword…

Event trigger★★★★☆ complexityAI-powered15 nodesHTTP RequestSpreadsheet FileAgentOpenAI ChatMicrosoft SharePoint
AI & RAG Trigger: Event Nodes: 15 Complexity: ★★★★☆ AI nodes: yes Added:

This workflow corresponds to n8n.io template #6272 — we link there as the canonical source.

This workflow follows the Agent → HTTP Request recipe pattern — see all workflows that pair these two integrations.

The workflow JSON

Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →

Download .json
{
  "id": "WEsO2dwjCaN6NwQT",
  "meta": {
    "templateCredsSetupCompleted": true
  },
  "name": "Compile top social-media trends to spreadsheet on SharePoint (or Drive/Dropbox)",
  "tags": [
    {
      "id": "wpMIpESnBZpdPCpj",
      "name": "Marketing",
      "createdAt": "2025-06-03T11:38:37.020Z",
      "updatedAt": "2025-06-03T11:38:37.020Z"
    }
  ],
  "nodes": [
    {
      "id": "a4dd01b9-57d6-41ff-9630-1bc6276f48da",
      "name": "Reddit API",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -336,
        48
      ],
      "parameters": {},
      "typeVersion": 3
    },
    {
      "id": "fd03075f-7e22-48a8-b92a-ef397a7d74e6",
      "name": "Merge Data",
      "type": "n8n-nodes-base.merge",
      "position": [
        -96,
        192
      ],
      "parameters": {},
      "typeVersion": 2.1
    },
    {
      "id": "b5dd36d6-a175-4695-8a02-0e92237bc0d3",
      "name": "Aggregate Content",
      "type": "n8n-nodes-base.code",
      "position": [
        80,
        192
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "aa228c26-feb4-4d9e-9535-2da2b4aa3635",
      "name": "Prepare Excel",
      "type": "n8n-nodes-base.code",
      "position": [
        608,
        192
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "ada69f9a-3b99-4c41-98df-9fed26498184",
      "name": "Create Excel",
      "type": "n8n-nodes-base.spreadsheetFile",
      "position": [
        832,
        192
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "f6df2ff4-fd06-4073-bc41-a71d2c614010",
      "name": "AI Agent",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        288,
        -16
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "9fc152ce-46e6-45c2-8d3f-72a9e34f5b3a",
      "name": "OpenAI Chat Model",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        288,
        192
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "302e51be-be21-4883-b62a-21c8fc6c4ca4",
      "name": "When clicking \u2018Execute workflow\u2019",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        -768,
        192
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "c625cc58-a4aa-4090-9b31-53c92fda8d37",
      "name": "Microsoft SharePoint",
      "type": "n8n-nodes-base.microsoftSharePoint",
      "position": [
        1040,
        192
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "fd72d6de-d25d-4bb1-922b-8a4f0d3d7bca",
      "name": "Get Twitter Trends",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -336,
        320
      ],
      "parameters": {},
      "typeVersion": 4.2
    },
    {
      "id": "71e4af0b-959f-48ee-9554-73d08a13abc2",
      "name": "Set Config",
      "type": "n8n-nodes-base.set",
      "position": [
        -560,
        192
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "5915a721-4aca-4f8f-892e-df152dc2b9a0",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -832,
        -208
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "e7497dd8-57ed-4ffd-94a3-f04bb18da3c4",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        112,
        -336
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "0101f056-16c6-41ba-a9cc-c5778d3ca64d",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        720,
        -112
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "39c76494-1a64-4756-9f20-81c087c24342",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        720,
        384
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "90332d89-dc21-48da-858b-695d269c8396",
  "connections": {
    "AI Agent": {
      "main": [
        [
          {
            "node": "Prepare Excel",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Merge Data": {
      "main": [
        [
          {
            "node": "Aggregate Content",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Reddit API": {
      "main": [
        [
          {
            "node": "Merge Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Set Config": {
      "main": [
        [
          {
            "node": "Reddit API",
            "type": "main",
            "index": 0
          },
          {
            "node": "Get Twitter Trends",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Create Excel": {
      "main": [
        [
          {
            "node": "Microsoft SharePoint",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Prepare Excel": {
      "main": [
        [
          {
            "node": "Create Excel",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Aggregate Content": {
      "main": [
        [
          {
            "node": "AI Agent",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "OpenAI Chat Model": {
      "ai_languageModel": [
        [
          {
            "node": "AI Agent",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Get Twitter Trends": {
      "main": [
        [
          {
            "node": "Merge Data",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "When clicking \u2018Execute workflow\u2019": {
      "main": [
        [
          {
            "node": "Set Config",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
Pro

For the full experience including quality scoring and batch install features for each workflow upgrade to Pro

About this workflow

Content creators, marketers, journalists, and product teams who need a quick, automated snapshot of what the internet is talking about—served as a ready-to-use spreadsheet every morning. Manual Trigger / Cron starts the flow. Set Config picks today’s date and a topic keyword…

Source: https://n8n.io/workflows/6272/ — original creator credit. Request a take-down →

More AI & RAG workflows → · Browse all categories →

Related workflows

Workflows that share integrations, category, or trigger type with this one. All free to copy and import.

AI & RAG

Content creators, SEO specialists, and marketing teams who want to automatically generate SEO-optimized content based on trending topics—complete with AI-generated images, optional videos, and ready-t

Spreadsheet File, OpenAI Chat, Microsoft SharePoint +3
AI & RAG

K&S-Media Downloadliste SQL. Uses httpRequest, agent, googleSheets, lmChatOpenAi. Event-driven trigger; 97 nodes.

HTTP Request, Agent, Google Sheets +3
AI & RAG

🎯 Create viral TikToks, Shorts, Reels, podcasts, and ASMR videos in minutes — all on autopilot.

OpenAI, HTTP Request, Form Trigger +7
AI & RAG

Generate AI viral videos with NanoBanana & VEO3, shared on socials via Blotato 2. Uses @blotato/n8n-nodes-blotato, googleSheets, lmChatOpenAi, toolThink. Event-driven trigger; 94 nodes.

@Blotato/N8N Nodes Blotato, Google Sheets, OpenAI Chat +9
AI & RAG

RAG CHATBOT Main. Uses telegram, telegramTrigger, lmChatOpenAi, n8n-nodes-mcp. Event-driven trigger; 87 nodes.

Telegram, Telegram Trigger, OpenAI Chat +8