January 22, 2026

Gmail to Supabase, organized Reddit insights on demand

Lisa Granqvist Partner Workflow Automation Expert

Get a free AI assessment → ⬇️ Use template

Reddit is full of the exact words your market uses. But if those insights arrive as a pile of Gmail alerts, they’re basically unsearchable the moment you close the tab.

This Gmail Supabase insights automation hits growth marketers first, honestly. But product managers and founders feel it too, because the best feature ideas and objection clues keep slipping through the cracks.

You’ll turn F5Bot emails into tagged, filterable entries in Supabase, then pull an AI summary of any thread on demand. The result is a living “voice of customer” database you can actually use.

How This Automation Works

Here’s the complete workflow you’ll be setting up:

n8n Workflow Template: Gmail to Supabase, organized Reddit insights on demand

Click to explore

flowchart LR

    subgraph sg0["Message a model Flow"]
        direction LR
        n4["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/reddit.svg' width='40' height='40' /></div><br/>Get many comments in a post"]
        n5["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/reddit.svg' width='40' height='40' /></div><br/>Get a post"]
        n6["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/code.svg' width='40' height='40' /></div><br/>Code in JavaScript2"]
        n7["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/webhook.dark.svg' width='40' height='40' /></div><br/>Webhook"]
        n8@{ icon: "mdi:robot", form: "rounded", label: "Message a model", pos: "b", h: 48 }
        n9["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/webhook.dark.svg' width='40' height='40' /></div><br/>Respond to Webhook"]
        n10["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/supabase.svg' width='40' height='40' /></div><br/>Update a row"]
        n11["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/supabase.svg' width='40' height='40' /></div><br/>Get a row"]
        n7 --> n11
        n11 --> n5
        n5 --> n4
        n8 --> n9
        n8 --> n10
        n6 --> n8
        n4 --> n6
    end

    subgraph sg1["Schedule Flow"]
        direction LR
        n0@{ icon: "mdi:message-outline", form: "rounded", label: "Gmail", pos: "b", h: 48 }
        n1@{ icon: "mdi:play-circle", form: "rounded", label: "Schedule Trigger", pos: "b", h: 48 }
        n2@{ icon: "mdi:robot", form: "rounded", label: "OpenAI", pos: "b", h: 48 }
        n3@{ icon: "mdi:swap-vertical", form: "rounded", label: "Loop Over Items", pos: "b", h: 48 }
        n12["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/supabase.svg' width='40' height='40' /></div><br/>Create a row"]
        n0 --> n3
        n2 --> n12
        n12 --> n3
        n3 --> n2
        n1 --> n0
    end

    %% Styling
    classDef trigger fill:#e8f5e9,stroke:#388e3c,stroke-width:2px
    classDef ai fill:#e3f2fd,stroke:#1976d2,stroke-width:2px
    classDef aiModel fill:#e8eaf6,stroke:#3f51b5,stroke-width:2px
    classDef decision fill:#fff8e1,stroke:#f9a825,stroke-width:2px
    classDef database fill:#fce4ec,stroke:#c2185b,stroke-width:2px
    classDef api fill:#fff3e0,stroke:#e65100,stroke-width:2px
    classDef code fill:#f3e5f5,stroke:#7b1fa2,stroke-width:2px
    classDef disabled stroke-dasharray: 5 5,opacity: 0.5
    class n1 trigger
    class n8,n2 ai
    class n7,n9 api
    class n6 code
    classDef customIcon fill:none,stroke:none
    class n4,n5,n6,n7,n9,n10,n11,n12 customIcon

Why This Matters: Reddit insights die in your inbox

F5Bot is great at one thing: telling you a keyword showed up on Reddit. The problem starts after that. You open an alert, skim it, think “we should use this,” and then it disappears into the Gmail void with 40 other messages. A week later you’re writing copy, planning a roadmap, or prepping sales talk tracks, and you can’t find the thread where someone explained the exact reason they won’t switch. It’s not just time. It’s lost context, missed patterns, and teams arguing from opinions instead of receipts.

The friction compounds. Here’s where it breaks down in real life.

You end up re-reading the same types of threads because nothing is categorized or searchable.
Great quotes never make it into docs, decks, or campaigns, so you keep rewriting messaging from memory.
Competitor comparisons get missed because you only saw the post, not the comment chain where people get specific.
By the time you share the “insight,” it’s a vague summary, not a linkable, verifiable source your team trusts.

What You’ll Build: Gmail-to-Supabase Reddit intelligence system

This workflow runs on a simple idea: every Reddit mention should become structured data, not another email you forget. On an hourly schedule, n8n checks your Gmail inbox for new F5Bot alerts and extracts the mentions inside. Each mention is then processed by an AI classifier (OpenAI Chat Model via n8n’s AI nodes) that tags topic and sentiment in plain terms your team can filter later. Those tagged mentions are stored in Supabase so you can search, sort, and build dashboards around them. When you need deeper context, a webhook lets you request an “AI Summary” for a specific record, and the workflow fetches the Reddit post plus its full comment chain, builds a readable thread view, and returns an actionable summary you can paste into Slack, a doc, or a product ticket.

The workflow starts with Gmail ingestion and batching so it can process multiple alerts cleanly. Then it shifts into classification and storage in Supabase. Finally, it supports on-demand deep dives that pull full Reddit context and generate a usable summary in seconds.

What You’re Building

What Gets Automated

What You’ll Achieve

Scan Gmail every hour for new F5Bot alert emails.
Process alerts in batches so multiple mentions don’t break your flow.
Use AI to tag each mention with sentiment and a topic label.
On request, fetch the full Reddit thread and generate a clean summary.

Turn inbox clutter into a searchable Supabase dataset in about an hour, then continuously.
Share real objections and quotes with links, not “I think users said…” summaries.
Spot repeat complaints and feature requests across weeks of threads.
Pull competitor comparison language straight from comment chains.
Make marketing, product, sales, and support work off the same source of truth.

Expected Results

Let’s say you track 10 keywords and F5Bot sends about 20 alerts per day. Manually, even a quick “open, skim, copy key lines, paste into a doc, add a label” routine is maybe 5 minutes each, which is around 2 hours daily. With this workflow, the hourly Gmail scan and classification runs without you, and you only spend time when you request a deep summary (often a minute to click, then a short wait for the AI reply). You get most of that time back, plus the insights are searchable later.

Before You Start

n8n instance (try n8n Cloud free)
Self-hosting option if you prefer (Hostinger works well)
Gmail to read F5Bot alert emails
Supabase to store and query mentions
OpenAI API key (get it from the OpenAI dashboard)

Skill level: Beginner. You’ll connect accounts, paste API keys, and test a few sample emails and thread summaries.

Want someone to build this for you? Talk to an automation expert (free 15-minute consultation).

Step by Step

Hourly inbox check in Gmail. A schedule trigger runs every hour, looks for new F5Bot alert emails, and extracts the mention payload from each message.

Batch processing for stability. Mentions are looped in batches so n8n can handle spikes (a busy subreddit day) without timing out or dropping items.

AI classification that makes the data usable. The OpenAI model analyzes each mention and assigns tags like topic and sentiment, which makes filtering in Supabase or a dashboard straightforward.

Store mentions, then summarize threads on demand. New records are inserted into Supabase immediately. When you request an “AI Summary” (through a webhook), the workflow fetches the Reddit post and comments, builds readable thread context, generates a summary, and writes it back to Supabase plus returns it to the requester.

You can easily modify the topics you tag for (for example “pricing,” “integrations,” “performance”) to match your product. See the full implementation guide below for customization options.

Step-by-Step Implementation Guide

Step 1: Configure the Schedule Trigger

This workflow starts every hour, pulling new Reddit mention emails and processing them automatically.

Add and open Hourly Schedule Starter.
Set the schedule rule to run every hour by keeping Interval set to hours.
Confirm Hourly Schedule Starter is connected to Email Inbox Reader.

If you want faster monitoring, change the interval in Hourly Schedule Starter and adjust the Gmail filter window accordingly in Email Inbox Reader.

Step 2: Connect Gmail for Mention Intake

Emails provide the mention content used for classification and Supabase storage.

Open Email Inbox Reader and set Operation to getAll with Return All enabled.
In Filters, set Sender to [YOUR_EMAIL].
Set Received After to {{ $now.minus(1,"hour") }}.
Credential Required: Connect your gmailOAuth2 credentials.

⚠️ Common Pitfall: If [YOUR_EMAIL] is not replaced with a real sender address, Email Inbox Reader will return no results.

Step 3: Set Up Batching and AI Mention Classification

The workflow batches email items and uses AI to classify mentions by category and sentiment.

Open Batch Item Iterator and keep default settings to iterate through items from Email Inbox Reader.
Open AI Mention Classifier and set Model to gpt-5.
In the user message content, keep the expressions that extract email content: {{ $json.html.split('\n')[3].removeTags().split(': ')[1].toString() }} and {{ $json.html.split('\n')[4].removeTags().split(': ')[0].toString().trim() }}.
Enable JSON Output by keeping true in AI Mention Classifier.
Credential Required: Connect your openAiApi credentials.

Keep the system prompt in AI Mention Classifier aligned with your company context so the categorization stays accurate.

Step 4: Configure Supabase Insert for Mentions

Each classified mention is inserted into Supabase for tracking and later enrichment.

Open Insert Supabase Record and set Table to all_mentions.
Map fields using the existing expressions, including title {{ $('Email Inbox Reader').first().json.html.split('\n')[3].removeTags().split(': ')[1].toString() }}, body {{ $('Email Inbox Reader').first().json.html.split('\n')[4].removeTags().split(': ')[0].toString().trim() }}, and account {{ $('Email Inbox Reader').first().json.html.split('\n')[3].removeTags().split(':')[0].split(' ')[4].slice(1,-1).toString().toString() }}.
Keep the link field’s URL-extraction expression as provided, and posted_at set to {{ $('Email Inbox Reader').first().json.headers.date.toDateTime() }}.
Map AI outputs to category, sentiment, and classification_reasoning using {{ $('AI Mention Classifier').first().json.message.content.Category }}, {{ $('AI Mention Classifier').first().json.message.content.Sentiment }}, and {{ $('AI Mention Classifier').first().json.message.content.Reasoning }}.
Credential Required: Connect your supabaseApi credentials.

Step 5: Configure Webhook, Reddit Retrieval, and Thread Insight Generation

This path enriches a stored mention by fetching Reddit post details and comments, then generating an insight summary.

Open Incoming Webhook Listener and confirm Path is 8bc532ac-315a-4987-9f21-3d48c50f2b99, HTTP Method is POST, and Response Mode is responseNode.
In Fetch Supabase Entry, set Table to all_mentions and filter id with {{ $json.body.id }}. Credential Required: Connect your supabaseApi credentials.
Configure Retrieve Post Details with Operation get, Post ID {{ $json.link.split("/comments/")[1].split("/")[0] }}, and Subreddit {{ $json.account.split("/r/")[1].split("/")[0] }}. Credential Required: Connect your redditOAuth2Api credentials.
Configure Fetch Post Comments with Resource postComment, Operation getAll, Return All enabled, Post ID {{ $json.id }}, and Subreddit {{ $json.subreddit }}. Credential Required: Connect your redditOAuth2Api credentials.
Keep the JavaScript in Build Comment Markdown to generate a single markdown string from nested comments.
In Thread Insight Generator, set Model to gpt-5 and keep the prompt input: {{"Main Post: " + $("Retrieve Post Details").first().json.selftext + "\nComments in markdown format: " + $json.markdown}}. Credential Required: Connect your openAiApi credentials.
Thread Insight Generator outputs to both Return Webhook Reply and Modify Supabase Entry in parallel.
In Return Webhook Reply, set Respond With to text and Response Body to {{ $('Thread Insight Generator').first().json.output[0].content[0].text }}.
In Modify Supabase Entry, set Operation to update, filter by id {{ $("Fetch Supabase Entry").first().json.id }} and link with =*{{ $('Retrieve Post Details').first().json.id }}*. Map thread_summary to {{ $json.output[0].content[0].text }} and raw_full_thread to {{"Main Post: " + $("Retrieve Post Details").first().json.selftext + "\nComments in markdown format: " + $json.markdown}}. Credential Required: Connect your supabaseApi credentials.

Use the webhook URL from Incoming Webhook Listener as a callback target for systems that want immediate analysis of a stored mention.

Step 6: Test and Activate Your Workflow

Validate both the hourly email ingestion and the webhook-driven thread analysis.

Click Execute Workflow to run Hourly Schedule Starter manually and confirm Email Inbox Reader returns recent emails.
Verify a new row is created in all_mentions after AI Mention Classifier and Insert Supabase Record complete.
Send a POST request to Incoming Webhook Listener with { "id": "YOUR_RECORD_ID" } to validate the enrichment path.
Confirm Return Webhook Reply returns the AI summary and Modify Supabase Entry updates thread_summary and raw_full_thread fields.
Toggle the workflow to Active for production use.

🔒

Unlock Full Step-by-Step Guide

Get the complete implementation guide + downloadable template

Troubleshooting Tips

Gmail credentials can expire or need specific permissions. If things break, check the connected Google account inside n8n’s Credentials menu first.
If you’re using Wait nodes or external rendering, processing times vary. Bump up the wait duration if downstream nodes fail on empty responses.
OpenAI prompts that ship “generic” will produce generic tags. Bake your categories and a few examples into the AI nodes early, or you will be cleaning labels in Supabase later.

Quick Answers

What’s the setup time for this Gmail Supabase insights automation?

About 45 minutes if your Gmail, Supabase, and OpenAI accounts are ready.

Is coding required for this Gmail Supabase insights automation?

No coding required. You’ll mainly connect accounts, then test with a real F5Bot email.

Is n8n free to use for this Gmail Supabase insights workflow?

Yes. n8n has a free self-hosted option and a free trial on n8n Cloud. Cloud plans start at $20/month for higher volume. You’ll also need to factor in OpenAI API costs (often just a few cents per batch of mentions, depending on volume).

Where can I host n8n to run this automation?

Two options: n8n Cloud (managed, easiest setup) or self-hosting on a VPS. For self-hosting, Hostinger VPS is affordable and handles n8n well. Self-hosting gives you unlimited executions but requires basic server management.

Can I modify this Gmail Supabase insights workflow for different use cases?

Yes, and you should. The fastest win is editing the AI Mention Classifier instructions so tags match your product language (features, integrations, pricing, bugs). You can also change the Gmail search query to watch multiple inboxes or labels, and adjust the Supabase tables/fields if your dashboard needs extra columns like “priority” or “owner.” If you don’t use Reddit summaries, you can disable the on-demand webhook path and keep only the “capture + classify” part.

Why is my Gmail connection failing in this workflow?

Usually it’s expired Google OAuth access or the wrong Gmail permissions. Reconnect the Gmail credential in n8n, then confirm the workflow can read the mailbox/label your F5Bot alerts land in. If you recently changed your Google Workspace security settings, that can also silently block the connection until you re-authorize.

What volume can this Gmail Supabase insights workflow process?

Plenty for most small teams: dozens to a few hundred mentions a day is typical, and batching keeps it stable.

Is this Gmail Supabase insights automation better than using Zapier or Make?

Often, yes. The “capture emails, loop through mentions, classify with AI, store in Supabase, then support an on-demand webhook summary” flow is the kind of multi-path automation that gets awkward (and pricey) in Zapier. n8n also makes it easier to mix scheduled runs with webhook-triggered deep dives in the same workflow. Make can handle pieces of this, but the Reddit thread pull plus comment formatting tends to require more custom work. If you just need a simple “Gmail email → spreadsheet row,” Zapier is fine. Talk to an automation expert if you want a quick recommendation based on your volumes and team habits.

Once your Reddit signals live in Supabase instead of Gmail, they start compounding. Set it up once, and your next launch, landing page, and roadmap review gets a lot easier.

Need Help Setting This Up?

Our automation experts can build and customize this workflow for your specific needs. Free 15-minute consultation—no commitment required.

Lisa Granqvist

Workflow Automation Expert

Expert in workflow automation and no-code tools.

{
"id": null,
"meta": {
"instanceId": "88f3b04c8aaa03a43c69b919c87da86bb532a2f75074f3d11b01bd5d2eb998b4",
"templateCredsSetupCompleted": null,
"templateId": null
},
"name": "Automated Reddit Mention Analysis",
"tags": [],
"nodes": [
{
"id": "flowpast-topbar-11182",
"name": "Flowpast Branding",
"type": "n8n-nodes-base.stickyNote",
"position": [
0,
80
],
"parameters": {
"color": 7,
"width": 1280,
"height": 80,
"content": "## Flowpast.com | Automation Workflow Library\n**\ud83d\udcd6 Full tutorial & setup guide:** flowpast.com"
},
"typeVersion": 1
},
{
"id": "c8d3265b-69a0-44ce-8807-948e0632b4a8",
"name": "Hourly Schedule Starter",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
1180,
180
],
"parameters": {
"rule": {
"interval": [
{
"field": "hours"
}
]
}
},
"typeVersion": 1.2
},
{
"id": "927d0c54-a30e-4f29-b994-56b2b8fc16ed",
"name": "Email Inbox Reader",
"type": "n8n-nodes-base.gmail",
"position": [
940,
230
],
"webhookId": "cbb6fc22-380e-40aa-81c0-e9d933e6a918",
"parameters": {
"simple": false,
"filters": {
"sender": "[YOUR_EMAIL]",
"receivedAfter": "={{ $now.minus(1,\"hour\") }}"
},
"options": [],
"operation": "getAll",
"returnAll": true
},
"credentials": {
"gmailOAuth2": {
"id": "credential-id",
"name": ""
}
},
"notesInFlow": false,
"typeVersion": 2.1,
"alwaysOutputData": false
},
{
"id": "4f06dfab-72aa-49df-bc47-fa293bc025f0",
"name": "Batch Item Iterator",
"type": "n8n-nodes-base.splitInBatches",
"position": [
700,
190
],
"parameters": {
"options": []
},
"typeVersion": 3
},
{
"id": "f5d3777f-5619-4c2a-a23b-6cee1a3651ab",
"name": "AI Mention Classifier",
"type": "@n8n/n8n-nodes-langchain.openAi",
"position": [
460,
240
],
"parameters": {
"modelId": {
"__rl": true,
"mode": "list",
"value": "gpt-5",
"cachedResultName": "GPT-5"
},
"options": [],
"messages": {
"values": [
{
"role": "system",
"content": "# Your Role  \nYou are an **expert social intelligence analyst for [COMPANY]**.\n\nYour task is to analyze how [COMPANY] is discussed across **Reddit**.\n\nApproach each mention with the mindset of a **strategic listener** \u2014 someone who interprets online discussions not just at face value, but as valuable signals for **brand perception, community sentiment, and product opportunities**.\n\nYour analysis will directly inform **[COMPANY]'s Growth and Product teams**, helping them identify:  \n- Product feedback or friction points  \n- Potential feature opportunities  \n- Community engagement moments  \n- Gaps in messaging or positioning  \n\nYou will interpret these mentions with a strategic lens to understand **user perception, sentiment, and intent**, helping the [COMPANY] team identify opportunities for engagement, product improvement, and community growth.\n\n---\n\n# About [COMPANY]  \n[...] similar to [CLOSE COMPETITORS].\n\n## Audience  \n[...]\n\n## Reference Context  \n- With [COMPANY] users build [...]  \n- They need [...]  \n- **Ideal for:** [...]  \n- **Not for:** [...]  \n\n---\n\n### Your Mission  \nWhen a reddit mention is provided, analyze it as if you were reporting to [COMPANY]\u2019s **Growth and Product teams**. You should:  \n- Understand the **context** of the mention.  \n- Identify **why** the user is talking about [COMPANY].  \n- Classify it based on its **purpose or intent** (support, feedback, feature request, etc.).  \n- Determine the **sentiment** (positive, negative, neutral) toward [COMPANY].\n\n---\n\n### Classification Categories  \nChoose **one** of the following categories for each mention:\n\n1. **Support** \u2014 Mentions asking for help, reporting bugs, or describing technical issues.  \n2. **Feature Requests** \u2014 Suggestions or ideas for new features or enhancements.  \n3. **Product Insight** \u2014 Feedback, opinions, or comparisons with competitors that reveal how users perceive the product.  \n4. **Pre-Sales Queries** \u2014 Questions about pricing, plans, or purchase decisions.  \n5. **Community Engagement** \u2014 Mentions showcasing projects, tutorials, use cases, or positive discussions about [COMPANY].  \n6. **Miscellaneous** \u2014 Off-topic mentions or unrelated references that don\u2019t fit other categories.\n\n---\n\n### Sentiment Guidelines  \nLabel the sentiment as one of the following:  \n- **Positive:** Expresses satisfaction, excitement, appreciation, or constructive enthusiasm.  \n- **Negative:** Expresses frustration, criticism, or disappointment.  \n- **Neutral:** Informational, factual, or balanced statements without emotional tone.\n\n---\n\n### Output Requirements  \nProvide your analysis in the following JSON format.  \n**Do not explain or elaborate beyond the JSON output.**\n\n```json\n{\n  \"Category\": \"[Selected category]\",\n  \"Sentiment\": \"[Positive/Negative/Neutral]\",\n  \"Reasoning\": \"[A concise explanation of why this category and sentiment were chosen]\"\n}\n"
},
{
"content": "={{ $json.html.split('\\n')[3].removeTags().split(': ')[1].toString()}}\n{{ $json.html.split('\\n')[4].removeTags().split(': ')[0].toString().trim()}}"
}
]
},
"jsonOutput": true
},
"credentials": {
"openAiApi": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 1.6
},
{
"id": "a0421654-8eca-47f2-a845-a4a910a89110",
"name": "Insert Supabase Record",
"type": "n8n-nodes-base.supabase",
"position": [
220,
200
],
"parameters": {
"tableId": "all_mentions",
"fieldsUi": {
"fieldValues": [
{
"fieldId": "title",
"fieldValue": "={{ $('Email Inbox Reader').first().json.html.split('\\n')[3].removeTags().split(': ')[1].toString()}}"
},
{
"fieldId": "body",
"fieldValue": "={{ $('Email Inbox Reader').first().json.html.split('\\n')[4].removeTags().split(': ')[0].toString().trim()}}"
},
{
"fieldId": "link",
"fieldValue": "={{\n  (() => {\n    const html = $('Email Inbox Reader').first().json.html.toString();\n    const rawUrl = html.extractUrl().split(\"'\")[0];\n\n    try {\n      const parsed = new URL(rawUrl);\n      let u = parsed.searchParams.get('u');\n      if (!u) return rawUrl;\n\n      // Decode multiple times if necessary\n      for (let i = 0; i < 3; i++) {\n        try {\n          const decoded = decodeURIComponent(u);\n          if (decoded === u) break;\n          u = decoded;\n        } catch (e) { break; }\n      }\n\n      return u;\n    } catch (e) {\n      const match = rawUrl.match(/[?&]u=([^&]+)/);\n      return match ? decodeURIComponent(match[1]) : rawUrl;\n    }\n  })()\n}}"
},
{
"fieldId": "account",
"fieldValue": "={{ $('Email Inbox Reader').first().json.html.split('\\n')[3].removeTags().split(':')[0].split(' ')[4].slice(1,-1).toString().toString()}}"
},
{
"fieldId": "posted_at",
"fieldValue": "={{ $('Email Inbox Reader').first().json.headers.date.toDateTime() }}"
},
{
"fieldId": "category",
"fieldValue": "={{ $('AI Mention Classifier').first().json.message.content.Category }}"
},
{
"fieldId": "sentiment",
"fieldValue": "={{ $('AI Mention Classifier').first().json.message.content.Sentiment }}"
},
{
"fieldId": "classification_reasoning",
"fieldValue": "={{ $('AI Mention Classifier').first().json.message.content.Reasoning }}"
}
]
}
},
"credentials": {
"supabaseApi": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 1
},
{
"id": "76e8800f-2a65-4857-b04b-2120bb15060b",
"name": "Incoming Webhook Listener",
"type": "n8n-nodes-base.webhook",
"position": [
1160,
520
],
"webhookId": "8bc532ac-315a-4987-9f21-3d48c50f2b99",
"parameters": {
"path": "8bc532ac-315a-4987-9f21-3d48c50f2b99",
"options": [],
"httpMethod": "POST",
"responseMode": "responseNode"
},
"typeVersion": 2.1
},
{
"id": "5f25486e-481b-4d23-9bca-8bb0a27d12ab",
"name": "Fetch Supabase Entry",
"type": "n8n-nodes-base.supabase",
"position": [
920,
570
],
"parameters": {
"filters": {
"conditions": [
{
"keyName": "id",
"keyValue": "={{ $json.body.id }}"
}
]
},
"tableId": "all_mentions",
"operation": "get"
},
"credentials": {
"supabaseApi": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 1
},
{
"id": "2c78e59d-3410-460d-98b3-fde760c36300",
"name": "Retrieve Post Details",
"type": "n8n-nodes-base.reddit",
"position": [
680,
520
],
"parameters": {
"postId": "={{ $json.link.split(\"/comments/\")[1].split(\"/\")[0] }}",
"operation": "get",
"subreddit": "={{ $json.account.split(\"/r/\")[1].split(\"/\")[0] }}"
},
"credentials": {
"redditOAuth2Api": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 1
},
{
"id": "b3a58467-8195-4993-883a-c96e3fa439c1",
"name": "Fetch Post Comments",
"type": "n8n-nodes-base.reddit",
"position": [
440,
570
],
"parameters": {
"postId": "={{ $json.id }}",
"resource": "postComment",
"operation": "getAll",
"returnAll": true,
"subreddit": "={{ $json.subreddit }}"
},
"credentials": {
"redditOAuth2Api": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 1
},
{
"id": "306a28ef-5cec-4f1b-9373-185789101e6c",
"name": "Build Comment Markdown",
"type": "n8n-nodes-base.code",
"position": [
200,
520
],
"parameters": {
"jsCode": "// Get all comment objects from previous node (\"Fetch Post Comments\")\nconst comments = items.map(item => item.json);\n\n// Recursive Markdown builder to handle replies\nfunction toMarkdown(list, level = 0) {\n  let md = '';\n  for (const c of list) {\n    // Skip deleted or invalid comments\n    if (!c || !c.author || !c.body) continue;\n\n    const indent = '  '.repeat(level);\n    const body = c.body\n      .replace(/\\n+/g, ' ')\n      .replace(/\\s{2,}/g, ' ')\n      .trim();\n\n    // Build a permalink \u2014 Reddit provides 'permalink' directly (relative path)\n    const permalink = c.permalink\n      ? `https://www.reddit.com${c.permalink}`\n      : '';\n\n    // Format one Markdown line per comment\n    md += `${indent}- **[${c.author}](${permalink || '#'})**: ${body}\\n`;\n\n    // Handle nested replies recursively\n    if (c.replies?.data?.children?.length) {\n      const replies = c.replies.data.children\n        .filter(r => r.kind === 't1')\n        .map(r => r.data);\n      md += toMarkdown(replies, level + 1);\n    }\n  }\n  return md;\n}\n\n// Build markdown for all comments\nconst markdown = toMarkdown(comments);\n\n// Output a single Markdown string\nreturn [{ json: { markdown } }];"
},
"typeVersion": 2
},
{
"id": "02f1396c-5b8d-47f2-9951-e5f4287bd8e9",
"name": "Thread Insight Generator",
"type": "@n8n/n8n-nodes-langchain.openAi",
"position": [
20,
570
],
"parameters": {
"modelId": {
"__rl": true,
"mode": "list",
"value": "gpt-5",
"cachedResultName": "GPT-5"
},
"options": [],
"responses": {
"values": [
{
"role": "system",
"content": "# Role  \nYou are an **Elite Insight Analyst** tasked with analyzing a Reddit discussion that includes posts and comments about **[TOPIC]** creation using tools such as **[COMPANY & COMPETITORS]** or similar platforms.  \n\nYour goal is **not to summarize linearly**, but to extract **insightful signals** that could be valuable to the **[COMPANY] product, marketing, business, or customer teams**.\n\n---\n\n# Tone & Depth  \nYour analysis should be:  \n- **Concise but insightful** \u2014 focus on signals, not noise.  \n- **Neutral and evidence-based** \u2014 represent the conversation fairly, link to specific comments for reference.  \n- **Strategic in framing** \u2014 highlight what matters to product, growth, or customer experience.  \n\n---\n\n# Framework  \nPlease produce your output **in bullet points** using the structure below.\n\n---\n\n## **Topic / Theme Summary**  \n- What is the overall topic or question being discussed?  \n- Why is this conversation happening now (if apparent)?  \n\n---\n\n## **Key Insights & Takeaways**  \nSummarize the main ideas, opinions, or trends shared in the thread.  \nHighlight anything related to **[COMPANY], [TOOL CATEGORY], competitors, pricing, UX, AI features, integrations**.\n\nGroup insights by theme, such as:  \n- Product feedback  \n- Support issues  \n- Performance concerns  \n- Community sentiment  \n- Workflow preferences  \n- Comparisons to competitors  \n\n---\n\n## **Actionable Signals for [COMPANY]**  \n- Identify specific feedback or requests that could inform **product roadmap decisions**.  \n- Note **pain points** or gaps users are experiencing (what they wish existed, what\u2019s confusing, what\u2019s broken).  \n- Flag **positive mentions** \u2014 what users love, recommend, or repeatedly praise.  \n- If **competitors are mentioned**, summarize how [COMPANY] is being compared (positively or negatively).  \n\n---\n\n## **Sentiment & Tone Snapshot**  \n- Overall tone of the thread: **positive / neutral / negative**.  \n- Any **strong emotions**, recurring frustrations, or standout enthusiasm signals.  "
},
{
"content": "={{\"Main Post: \" + $(\"Retrieve Post Details\").first().json.selftext + \"\\nComments in markdown format: \" + $json.markdown}}"
}
]
},
"builtInTools": []
},
"credentials": {
"openAiApi": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 2
},
{
"id": "166bcece-240d-411f-8837-3b89f2580a7a",
"name": "Return Webhook Reply",
"type": "n8n-nodes-base.respondToWebhook",
"position": [
0,
720
],
"parameters": {
"options": {
"responseHeaders": {
"entries": [
{
"name": "Content-Type",
"value": "text/html"
}
]
}
},
"respondWith": "text",
"responseBody": "={{ $('Thread Insight Generator').first().json.output[0].content[0].text }}"
},
"typeVersion": 1.4
},
{
"id": "c8a80cfa-2ea8-451a-ad5e-47ae68c0826f",
"name": "Modify Supabase Entry",
"type": "n8n-nodes-base.supabase",
"position": [
260,
720
],
"parameters": {
"filters": {
"conditions": [
{
"keyName": "id",
"keyValue": "={{ $(\"Fetch Supabase Entry\").first().json.id }}",
"condition": "eq"
},
{
"keyName": "link",
"keyValue": "=*{{ $('Retrieve Post Details').first().json.id }}*",
"condition": "ilike"
}
]
},
"tableId": "all_mentions",
"fieldsUi": {
"fieldValues": [
{
"fieldId": "thread_summary",
"fieldValue": "={{ $json.output[0].content[0].text }}"
},
{
"fieldId": "raw_full_thread",
"fieldValue": "={{\"Main Post: \" + $(\"Retrieve Post Details\").first().json.selftext + \"\\nComments in markdown format: \" + $json.markdown}}"
}
]
},
"operation": "update"
},
"credentials": {
"supabaseApi": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 1
}
],
"active": false,
"pinData": [],
"settings": {
"executionOrder": "v1"
},
"versionId": null,
"connections": {
"Email Inbox Reader": {
"main": [
[
{
"node": "Batch Item Iterator",
"type": "main",
"index": 0
}
]
]
},
"AI Mention Classifier": {
"main": [
[
{
"node": "Insert Supabase Record",
"type": "main",
"index": 0
}
]
]
},
"Incoming Webhook Listener": {
"main": [
[
{
"node": "Fetch Supabase Entry",
"type": "main",
"index": 0
}
]
]
},
"Fetch Supabase Entry": {
"main": [
[
{
"node": "Retrieve Post Details",
"type": "main",
"index": 0
}
]
]
},
"Retrieve Post Details": {
"main": [
[
{
"node": "Fetch Post Comments",
"type": "main",
"index": 0
}
]
]
},
"Insert Supabase Record": {
"main": [
[
{
"node": "Batch Item Iterator",
"type": "main",
"index": 0
}
]
]
},
"Modify Supabase Entry": {
"main": [
[]
]
},
"Batch Item Iterator": {
"main": [
[],
[
{
"node": "AI Mention Classifier",
"type": "main",
"index": 0
}
]
]
},
"Thread Insight Generator": {
"main": [
[
{
"node": "Return Webhook Reply",
"type": "main",
"index": 0
},
{
"node": "Modify Supabase Entry",
"type": "main",
"index": 0
}
]
]
},
"Hourly Schedule Starter": {
"main": [
[
{
"node": "Email Inbox Reader",
"type": "main",
"index": 0
}
]
]
},
"Build Comment Markdown": {
"main": [
[
{
"node": "Thread Insight Generator",
"type": "main",
"index": 0
}
]
]
},
"Fetch Post Comments": {
"main": [
[
{
"node": "Build Comment Markdown",
"type": "main",
"index": 0
}
]
]
}
}
}