Turn Reddit posts into content ideas with Telegram, Apify, GPT and Sheets

Reddit Content Saver Pipeline

> A Telegram-triggered n8n workflow that scrapes Reddit posts, analyzes them with AI, and saves structured content ideas to Google Sheets.

---

Overview

Send a Reddit post URL to a Telegram bot. The pipeline scrapes the post and comments, runs AI analysis for content insights, deduplicates against previously processed links, and logs everything to Google Sheets — all automatically.

---

Workflow Diagram

Telegram Trigger
 └─► Typing Indicator
 └─► Get Sheets Log (dedup source)
 └─► Dedup Check
 ├─► [DUPLICATE] Notify user → stop
 └─► [NEW] Apify Reddit Scrape
 └─► Extract Content
 ├─► [NO CONTENT] Notify user → stop
 └─► [HAS CONTENT] AI Analysis
 └─► Save to Sheets
 └─► Success Reply

---

Step-by-Step Breakdown

1. Telegram Trigger

Listens for incoming messages on the Reddit Bot Telegram account. The message is expected to contain a Reddit post URL.

2. Typing Indicator

Immediately sends a typing indicator back to the user so they know the bot received the message.

3. Get row(s) in sheet

Fetches all previously processed Reddit URLs from the Google Sheets pipeline log. This is the source of truth for duplicate detection.

Template: https://docs.google.com/spreadsheets/d/1Q0F7Th6cdiqYKJIPwx_G0td59QkRMjNJMxpU3xOVGMU/edit?usp=sharing

4. Dedup Check (Code Node)

Extracts the Reddit URL from the Telegram message using regex, then normalizes both the incoming URL and all stored URLs (strips www., lowercases, removes trailing slashes) before comparing. Sets an is_duplicate flag.

5. Duplicate Branch (If Node)

Condition	Action
Duplicate detected	Sends Telegram message with original submission date and summary → stops
New link	Continues to Apify scraping

6. Reddit Scrape (Apify — Reddit Scraper Lite)

Runs the trudax/reddit-scraper-lite actor against the Reddit URL. Scrapes the post and up to top 10 comments using a residential proxy.

7. Get Dataset Items

Retrieves the results from the completed Apify actor run.

8. Extract & Clean Data (Code Node)

Restructures the raw Apify output — extracts post_title, post_body, and comment_summary_text into a flat object for downstream use.

9. Content Validation (If Node)

Checks whether the scraped post has at least a title, body, or comment text.

Condition	Action
Has content	Continues to AI analysis
No content	Sends "No Content Found" Telegram reply → stops

10. AI: Analyze Content (LangChain + OpenAI)

Passes the post and comments to an OpenAI GPT model. Analyzes the content for ideas, themes, and insights. A Structured Output Parser enforces a consistent JSON response shape.

11. Edit Fields

Maps the AI output into a clean, flat structure ready for Google Sheets ingestion.

12. Save to Google Sheets

Appends a new row to the pipeline log with post metadata, AI analysis results, and the source URL.

13. Success Confirmation

Sends a Telegram message confirming the post has been saved, with a link to the Google Sheet.

---

Platforms & APIs

Platform	Role
Telegram	User input (send Reddit URL) and all bot replies
Apify — reddit-scraper-lite	Scrapes Reddit post content and comments via residential proxy
OpenAI GPT (via n8n LangChain)	AI content analysis and structured output generation
Google Sheets	Persistent storage for processed posts and duplicate-detection log
n8n	Workflow orchestration

---

Error States

Scenario	Bot Response
URL was previously submitted	"You shared this link previously on [date] — [title/summary] — check GSheets [link]"
Scraped post returned no usable content	"No Reddit link found. Send me a Reddit post URL and I will analyze it for content ideas."

---

Credentials Required

Credential	Used By
Telegram Bot Token	Trigger + all reply nodes
Apify API Key	Reddit Scraper actor
OpenAI API Key	AI analysis node
Google Sheets OAuth	Read (dedup) + Write (save)