Step 2: Connect Reddit as the Data Source

Pull new posts from the n8n subreddit for question extraction.

1. Open Retrieve Reddit Posts and set Operation to getAll.
2. Set Subreddit to n8n and Limit to 30.
3. Credential Required: Connect your redditOAuth2Api credentials.
4. Connect Retrieve Reddit Posts to Filter Question Titles.

Step 3: Filter Questions and Log to the Query Sheet

Identify question-style titles, then save them for downstream processing.

1. In Filter Question Titles, set JavaScript Code to:
2. const questionWords = ['who', 'what', 'when', 'where', 'why', 'how', 'can', 'does', 'is', 'should', 'do', 'are', 'could', 'would'];

return $input.all().filter(item => {
const rawTitle = item.json.title;
if (!rawTitle) return false;

const title = rawTitle.trim().toLowerCase();

const isQuestion =
title.endsWith('?') ||
questionWords.some(word =>
title.startsWith(word + ' ') ||
title.includes(' ' + word + ' ')
);

// 🪵 Debug log goes here:
if (isQuestion) console.log('✅ Question found:', title);

return isQuestion;
});
3. Open Append Query Sheet and set Operation to append.
4. Map Query to {{ $json.selftext }} and Title to {{ $json.title }}.
5. Set Document to [YOUR_ID] and Sheet to Queries.
6. Credential Required: Connect your googleSheetsOAuth2Api credentials.
7. Connect Append Query Sheet to Batch Iterator.

Step 4: Set Up AI Processing and Rephrasing

Rephrase the selected question and prepare it for content generation.

1. Connect Batch Iterator to Rephrase Question Agent (main output).
2. In Rephrase Question Agent, set Text to =Here is a question: {{ $json.Title }} Rephrase it without changing the meaning. Keep it as a question. I just need the question as the output nothing else.
3. Ensure Primary Chat Model is connected as the language model for Rephrase Question Agent and select model gpt-4o-mini.
4. Credential Required: Connect your openAiApi credentials on Primary Chat Model (not on Rephrase Question Agent).
5. Attach Context Memory Buffer as AI memory and set Session Key to {{ $json.Title }}.
6. Connect Rephrase Question Agent to Map Question Name and map name to {{ $json.output }}.

Step 5: Configure the Blog Sheet Upsert and Parallel AI Drafting

Store the rephrased title and generate slug, intro, steps, and conclusion in parallel.

1. In Upsert Blog Sheet, set Operation to appendOrUpdate.
2. Map name to {{ $json.name }}, set Document to [YOUR_ID], and Sheet to Blog.
3. Credential Required: Connect your googleSheetsOAuth2Api credentials.
4. Upsert Blog Sheet outputs to both Draft Intro Section and Draft Steps Section and Draft Conclusion and Generate URL Slug in parallel.
5. Configure AI prompts and memory for each draft node:
   • Generate URL Slug Text: =Based on {{ $json.name }} Create a website slug for it. For example: best-website-builder Just give me the slug as output nothing else with Slug Chat Model and Slug Memory Buffer (Session Key {{ $json.name }}).
   • Draft Intro Section Text: =Write a short intro for a blog post titled: {{ $json.name }} Make it easy to read, with easy vocabulary Just give me the intro as the output with Intro Chat Model and Intro Memory Buffer (Session Key {{ $('Upsert Blog Sheet').item.json.name }}).
   • Draft Steps Section Text: =Write a 'step by step guide' section for a blog post titled: {{ $json.name }} Make it easy to read, with easy vocabulary But make it very detailed Just give me the output with Steps Chat Model and Steps Memory Buffer (Session Key {{ $('Upsert Blog Sheet').item.json.name }}).
   • Draft Conclusion Text: =Write a short conclusion for a blog post titled: {{ $json.name }} Make it easy to read, with easy vocabulary Just give me the conclusion as the output with Conclusion Chat Model and Conclusion Memory Buffer (Session Key {{ $('Upsert Blog Sheet').item.json.name }}).
6. Credential Required: Connect your openAiApi credentials on Slug Chat Model, Intro Chat Model, Steps Chat Model, and Conclusion Chat Model.

Step 6: Map AI Outputs and Append the Blog Record

Assign each generated section to a field, then write the full record to the blog sheet.

1. In Assign Slug Field, map slug to {{ $json.output }}.
2. In Assign Intro Field, map Intro to {{ $json.output }}.
3. In Assign Steps Field, map Steps to {{ $json.output }}.
4. In Assign Conclusion Field, map Conclusion to {{ $json.output }}.
5. Each of Assign Slug Field, Assign Intro Field, Assign Steps Field, and Assign Conclusion Field should connect to Append Blog Output.
6. In Append Blog Output, set Operation to append and map: name → {{ $json.name }}, slug → {{ $json.slug }}, Intro → {{ $json.Intro }}, Steps → {{ $json.Steps }}, Conclusion → {{ $json.Conclusion }}.
7. Credential Required: Connect your googleSheetsOAuth2Api credentials.
8. Connect Append Blog Output back to Batch Iterator to continue batch processing.

Step 7: Test and Activate Your Workflow

Run a manual test to confirm records and AI content are written to your sheets.

1. Click Execute Workflow and trigger Manual Launch Trigger.
2. Verify that Append Query Sheet adds rows to the Queries sheet and that Upsert Blog Sheet and Append Blog Output populate the Blog sheet.
3. Confirm that the slug, intro, steps, and conclusion fields contain AI-generated text for each question.
4. When everything looks correct, toggle the workflow to Active for production use.