Reddit Discussion to LinkedIn Content Strategy Generator - n8n Workflow

Content Strategists and Marketers focused on B2B, SaaS, or tech.
Founders seeking validated pain points for product marketing.
Users looking for advanced n8n templates leveraging large language models.
Professionals who need to scale social media content research using automation.

Finding timely and relevant content ideas that resonate with a professional audience is challenging. This advanced n8n workflow solves this by turning raw community discussions on Reddit into highly structured, actionable LinkedIn content outlines. By using a specialized n8n node setup, the automation targets specific subreddits and search terms, extracts detailed pain points and supporting quotes using GPT-4o, and synthesizes them into ready-to-use content strategies. This powerful n8n workflow ensures high keyword density and relevancy, making it one of the most effective n8n templates for content research. The final output is neatly organized in a Google Sheet, providing a central database for tracking potential LinkedIn posts.

The process is initiated by an n8n trigger, the 'On form submission' node, which accepts the target subreddit and a search term. First, the n8n workflow creates a new, uniquely named Google Sheet to store the results. Next, the Reddit n8n node, 'Get Posts,' fetches relevant discussions. A subsequent filter ensures that only posts with meaningful engagement (those containing comments) proceed.

Each valid post then enters a processing loop. Inside the loop, the workflow uses a Reddit n8n node to fetch all comments for that post. These comments are aggregated, combined with the original post content, and passed to the 'Generate insights' n8n node. This node utilizes the GPT-4o model, running as a LangChain Agent, to perform deep analytical work: identifying themes, extracting five distinct pain points, and synthesizing a narrative, following a strict Markdown structure defined in the prompt.

This rich analysis is then piped to the 'Suggest post topics' n8n node, where GPT-4o acts as a senior content strategist to generate 3–5 professional LinkedIn post outlines (including headlines, hooks, and CTAs) based on the supplied insights. Finally, a series of Set and Merge n8n node operations structure all the collected data—original content, raw comments, detailed analysis, and finalized post ideas—into clean columns. The Google Sheets n8n node then appends this entire record to the spreadsheet created at the start of the n8n workflow, completing the automation cycle.

To deploy this comprehensive n8n workflow template, follow these steps:

1. Import the JSON: Copy the provided n8n workflow JSON and paste it into your n8n instance using the 'New' -> 'Import from JSON' option.


2. Credentials Setup: This n8n workflow requires three sets of credentials:

1. Initial Run: Once credentials are set, execute the 'On form submission' n8n trigger. Enter the desired subreddit (e.g., 'marketing') and a search keyword (e.g., 'SaaS pricing').


2. Monitor: The n8n workflow will run, generating the spreadsheet link and populating it with AI-driven content ideas.

This n8n workflow uses a combination of core logic, data manipulation, and advanced AI n8n node types:

On form submission (n8n trigger): The starting point for this n8n automation. It collects the essential user inputs (Subreddit and Search Keyword).
Create spreadsheet (Google Sheets n8n node): Dynamically creates a new Google Sheet to store the results before the data extraction begins.
Get Posts & Get many comments in a post (Reddit n8n node): Handles interaction with the Reddit API, searching for discussions and retrieving all associated comments.
Filter only posts with comments (Filter n8n node): Essential flow control that restricts processing only to discussions that have engagement (comments > 0).
Generate insights (Langchain Agent n8n node): This is the core analysis step. It uses GPT-4o with a highly detailed prompt to extract pain points, supporting quotes, and high-level synthesis from the merged post and comment data.
Suggest post topics (Langchain OpenAI n8n node): Takes the detailed insights generated previously and acts as a LinkedIn strategist to propose 3–5 distinct, ready-to-use post ideas, complete with structured outlines.
Merge insights with post content and comments (Merge n8n node): Used extensively throughout the n8n workflow to ensure metadata, insights, and post ideas are correctly combined before final output.
Output The Results (Google Sheets n8n node): The final action n8n node, appending the fully processed and structured data to the generated spreadsheet.