January 22, 2026

Reddit to Google Sheets, lead notes logged for you

Lisa Granqvist Partner Workflow Automation Expert

Get a free AI assessment → ⬇️ Use template

Manual Reddit lead research sounds simple until you’re staring at 20 tabs, trying to remember why one post mattered, and realizing you never wrote anything down. Then you go to follow up… and it’s gone.

This Reddit lead logging automation hits marketers hardest, but founders doing their own outreach feel it too. Same for agency teams who need a steady pipeline without hiring a researcher. The outcome is straightforward: posts get captured, qualified, summarized, and logged so you can follow up faster.

Below, you’ll see what this n8n workflow does, what results to expect, and what you need to run it reliably.

How This Automation Works

The full n8n workflow, from trigger to final output:

n8n Workflow Template: Reddit to Google Sheets, lead notes logged for you

Click to explore

flowchart LR

    subgraph sg0["When clicking ‘Test workflow’ Flow"]
        direction LR
        n0@{ icon: "mdi:play-circle", form: "rounded", label: "When clicking ‘Test workflow’", pos: "b", h: 48 }
        n1@{ icon: "mdi:robot", form: "rounded", label: "Post Summarization", pos: "b", h: 48 }
        n2["<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/merge.svg' width='40' height='40' /></div><br/>Merge Input"]
        n3@{ icon: "mdi:database", form: "rounded", label: "Output The Results", pos: "b", h: 48 }
        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/merge.svg' width='40' height='40' /></div><br/>Merge 3 Inputs"]
        n5@{ icon: "mdi:swap-horizontal", form: "rounded", label: "Filter Posts By Features", pos: "b", h: 48 }
        n6@{ icon: "mdi:swap-horizontal", form: "rounded", label: "Filter Posts By Content", pos: "b", h: 48 }
        n7@{ icon: "mdi:swap-vertical", form: "rounded", label: "Select Key Fields", pos: "b", h: 48 }
        n8["<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 Posts"]
        n9@{ icon: "mdi:brain", form: "rounded", label: "OpenRouter Chat Model", pos: "b", h: 48 }
        n10@{ icon: "mdi:brain", form: "rounded", label: "OpenRouter Chat Model1", pos: "b", h: 48 }
        n11@{ icon: "mdi:robot", form: "rounded", label: "Basic LLM Chain", pos: "b", h: 48 }
        n12@{ icon: "mdi:swap-vertical", form: "rounded", label: "Edit Fields", pos: "b", h: 48 }
        n13@{ icon: "mdi:swap-vertical", form: "rounded", label: "Edit Fields1", pos: "b", h: 48 }
        n8 --> n5
        n12 --> n4
        n2 --> n6
        n13 --> n4
        n4 --> n3
        n11 --> n2
        n7 --> n2
        n7 --> n11
        n1 --> n12
        n9 -.-> n11
        n10 -.-> n1
        n6 --> n1
        n6 --> n13
        n5 --> n7
        n0 --> n8
    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 n0 trigger
    class n1,n11 ai
    class n9,n10 aiModel
    class n5,n6 decision
    class n3 database
    classDef customIcon fill:none,stroke:none
    class n2,n4,n8 customIcon

The Problem: Reddit Leads Die in Your Browser Tabs

Reddit is full of high-intent posts, but “finding” them is not the same as using them. You spot a thread where someone is clearly asking for help, you think “I’ll come back,” and then the day gets away from you. Or you paste a link into a doc with zero context, so a week later it’s just a random URL. Worse, you end up replying late, after the OP already chose a solution. Honestly, the mental overhead is the killer. You’re doing research, triage, note-taking, and memory management all at once.

It adds up fast. Here’s where the process usually breaks down.

You waste about 10 minutes per promising post just capturing context, and it still ends up incomplete.
Lead quality is inconsistent because you’re judging “intent” in your head, not using a repeatable filter.
Good threads slip through when you’re busy, which means you follow up late or not at all.
Your CRM never gets the early-stage research, so the pipeline looks empty even when Reddit is buzzing.

The Solution: Reddit Posts → AI Lead Notes → Google Sheets

This workflow turns Reddit browsing into a structured lead capture system. It starts by pulling Reddit posts based on keywords you care about, then checks basic engagement signals so you’re not analyzing junk. Next, it maps the important fields (title, link, metrics, and any other essentials) and sends the content through an AI “need classifier” to understand what the person is actually trying to solve. If the post passes your content checks, an AI summarizer generates clean notes you can act on. Finally, everything is merged into one consistent record and appended to Google Sheets, so every lead is searchable, sortable, and ready for outreach.

The workflow starts when you run it in n8n (often on a schedule once you’re happy with it). From there, Reddit retrieval, filtering, classification, and summarization happen automatically. Google Sheets becomes your living lead notebook, updated with each run.

What You Get: Automation vs. Results

What This Workflow Automates

Results You’ll Get

Searches Reddit for posts based on your chosen keywords.
Filters posts using engagement/metric checks so low-signal threads don’t waste your time.
Classifies the business need with an AI agent so “intent” becomes a usable field.
Summarizes each post into lead notes and appends them to Google Sheets automatically.

Get a ready-to-review lead list in about 5 minutes instead of an hour of tab-hopping.
Consistent notes per lead, so you remember why the link mattered.
Faster follow-up because the sheet is already pre-qualified and searchable.
Cleaner handoffs to a teammate since context lives with the link.
A simple pipeline you can run daily without “research days.”

Example: What This Looks Like

Say you review 30 Reddit posts a day across a few keywords. Manually, if you spend about 5 minutes per post to open it, judge intent, pull the link, and write a usable note, that’s roughly 2.5 hours. With this workflow, you run it once, wait a few minutes for AI summarization, then skim the Google Sheet in about 15 minutes and pick the best leads. Net result: about 2 hours back on a normal day, and your notes are actually consistent.

What You’ll Need

n8n instance (try n8n Cloud free)
Self-hosting option if you prefer (Hostinger works well)
Reddit to retrieve posts via OAuth app.
Google Sheets to store lead notes in a table.
OpenRouter API key (get it from your OpenRouter account settings)

Skill level: Intermediate. You’ll connect OAuth accounts, add an API key, and tweak filters and prompts to match what a “qualified lead” means for you.

Don’t want to set this up yourself? Talk to an automation expert (free 15-minute consultation).

How It Works

A run kicks things off. The workflow uses a Manual Start trigger in the provided version, then retrieves Reddit posts that match your keyword search. Once it’s validated, you can also schedule it to run automatically.

Posts get filtered and normalized. An “If” check validates post metrics (so you can ignore zero-engagement threads), then a mapping step pulls only the fields you’ll actually want in a lead sheet.

AI turns raw threads into lead notes. The workflow classifies the business need using an AI agent (via OpenRouter chat models), checks for content flags, and generates a readable summary that feels like a mini research brief.

Everything lands in Google Sheets. Several merge steps combine the original post data, the classification, and the summary into one row, then the workflow appends it to your spreadsheet so it’s ready for review and outreach.

You can easily modify your keywords to target different subreddits or problems based on your needs. See the full implementation guide below for customization options.

Step-by-Step Implementation Guide

Step 1: Configure the Manual Trigger

Start the workflow with a manual run so you can validate the Reddit search and AI outputs before scheduling it.

Add and open Manual Start Trigger.
No fields are required in this node; keep the default configuration.
Confirm the connection from Manual Start Trigger to Retrieve Reddit Posts.

Step 2: Connect Reddit and Fetch Posts

Pull posts from a target subreddit using a specific search keyword and sort order.

Open Retrieve Reddit Posts and set Operation to search.
Set Keyword to how do I find leads.
Set Subreddit to =Entrepreneur.
In Additional Fields, set Sort to hot.
Credential Required: Connect your Reddit credentials.

Step 3: Filter and Map Essential Post Fields

Validate post quality and normalize the data you will pass into the AI classifier and output stream.

In Validate Post Metrics, set conditions to ensure the post has engagement and content: Ups greater than 2, Selftext notEmpty, and post date after {{ $today.minus(180,'days').toISO() }}.
Use expressions exactly as shown: {{ $json.ups }}, {{ $json.selftext }}, {{ DateTime.fromSeconds($json.created).toISO() }}, and {{ $today.minus(180,'days').toISO() }}.
In Map Essential Fields, map these assignments: upvotes → {{ $json.ups }}, subreddit_subscribers → {{ $json.subreddit_subscribers }}, postcontent → {{ $json.selftext }}, url → {{ $json.url }}, date → {{ DateTime.fromSeconds($json.created).toISO() }}.
Confirm the parallel split: Map Essential Fields outputs to both Combine Input Streams and Business Need Classifier in parallel.

Step 4: Configure AI Classification and Summarization

Classify whether posts represent a business need and summarize qualifying posts.

Open Primary Chat Model and set Model to openai/gpt-4.1-mini.
Open Business Need Classifier and verify the prompt text: =Decide whether this reddit post is describing a business-related problem or a need for a solution.
Ensure the Human message in Business Need Classifier is =Reddit post: {{ $json.postcontent }}.
Open Secondary Chat Model and set Model to openai/gpt-4.1-mini.
Confirm Primary Chat Model is connected as the language model for Business Need Classifier and Secondary Chat Model is connected to Generate Post Summary — ensure credentials are added to the parent nodes (Primary Chat Model and Secondary Chat Model), not the sub-nodes.

Credential Required: Connect your OpenRouter credentials in Primary Chat Model and Secondary Chat Model. The AI sub-nodes do not store credentials.

Step 5: Route, Summarize, and Prepare Output Fields

Merge classification output with post metadata, summarize qualifying posts, and build the final dataset for Google Sheets.

In Combine Input Streams, set Mode to combine and Combine By to combineByPosition.
In Check Content Flag, set the condition to: Left Value {{ $json.output }} equals yes.
Confirm the parallel split: Check Content Flag outputs to both Generate Post Summary and Prepare Output Fields in parallel.
In Format Summary Fields, set summary to {{ $json.response.text }}.
In Prepare Output Fields, map values: date {{ $json.date }}, subreddit_subscribers {{ $json.subreddit_subscribers }}, url {{ $json.url }}, upvotes {{ $json.upvotes }}, postcontent {{ $json.postcontent }}, business_opportunity {{ $json.output }}.
In Merge Three Sources, set Mode to combine and Combine By to combineByPosition.

⚠️ Common Pitfall: If the Combine Input Streams and Merge Three Sources nodes receive mismatched item counts, the combine-by-position merge will misalign data. Make sure both branches output the same number of items.

Step 6: Configure Spreadsheet Output

Append the final merged dataset to Google Sheets for tracking lead opportunities.

Open Append to Spreadsheet and set Operation to append.
Select Document with ID [YOUR_ID].
Select Sheet Name as Find-Leads (gid 979106892).
Keep Mapping Mode at autoMapInputData to map fields automatically.
Credential Required: Connect your Google Sheets credentials.

Step 7: Test and Activate Your Workflow

Run a manual test to confirm Reddit extraction, AI classification, summary output, and Google Sheets append behavior.

Click Execute Workflow on Manual Start Trigger to run a live test.
Verify that Validate Post Metrics outputs only recent posts with ups greater than 2 and non-empty content.
Confirm Business Need Classifier returns yes or no and that Generate Post Summary produces a summary in Format Summary Fields.
Check Google Sheets to ensure Append to Spreadsheet adds a new row with date, upvotes, URL, content, business flag, and summary.
When the test is successful, switch the workflow to Active for production use.

🔒

Unlock Full Step-by-Step Guide

Get the complete implementation guide + downloadable template

Common Gotchas

Reddit OAuth credentials can expire or need specific permissions. If things break, check the Reddit developer app settings and your n8n Reddit credential selection 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.
Default prompts in AI nodes are generic. Add your brand voice early or you’ll be editing outputs forever.

Frequently Asked Questions

How long does it take to set up this Reddit lead logging automation?

About an hour if your Reddit, OpenRouter, and Google credentials are ready.

Do I need coding skills to automate Reddit lead logging?

No. You’ll mostly connect accounts and adjust filters and prompts.

Is n8n free to use for this Reddit lead logging 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 OpenRouter API usage, which depends on the model you choose.

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 customize this Reddit lead logging workflow for different keywords and lead criteria?

Yes, and you should. Most people tweak the Reddit search inputs, then adjust the Validate Post Metrics and Check Content Flag logic to match what “qualified” means. You can also rewrite the Business Need Classifier and Generate Post Summary prompts so the sheet captures your exact fields (pain point, urgency, budget hints, competitor mentions). If you prefer a different model provider later, you can swap the OpenRouter chat model nodes without changing the overall flow.

Why is my Reddit connection failing in this workflow?

Usually it’s an OAuth issue: the Reddit app client ID/secret changed, the redirect URI doesn’t match what n8n expects, or the credential in the “Retrieve Reddit Posts” node isn’t selected anymore. It can also fail if the account lacks access to certain subreddits, or if you’re hitting rate limits by pulling too much too often. Re-authenticate first, then reduce the volume and try again.

How many posts can this Reddit lead logging automation handle?

On n8n Cloud Starter, you can run a healthy amount of daily scans for a small team, and self-hosting removes execution limits (your server becomes the bottleneck). Practically, most people process tens to a few hundred posts per run, then tighten filters so AI summarization only runs on the best ones.

Is this Reddit lead logging automation better than using Zapier or Make?

Often, yes, because this workflow depends on multi-step logic: filtering, merging streams, and running AI classification plus summarization before writing to Sheets. n8n handles branching and “if this, then that” flows cleanly, and you can self-host to avoid per-task pricing when volume grows. Zapier or Make can still work if you only need something simple (for example, “new Reddit post → append row”), but you’ll start bolting on extra steps quickly. The moment you care about consistent lead notes, it’s nicer to keep the logic in one place. If you want help choosing, Talk to an automation expert.

A good Reddit lead is perishable. This workflow captures the signal while it’s fresh, then hands you a sheet full of next steps.

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": "",
"name": "Automated Reddit Lead Analysis",
"versionId": "",
"meta": {
"instanceId": "24cb434b44df3891b64dc4acd94f69f9dd57ab46392e96e2ea3cbe396c5f5bc7"
},
"nodes": [
{
"id": "flowpast-topbar-3849",
"name": "Flowpast Branding",
"type": "n8n-nodes-base.stickyNote",
"position": [
0,
45
],
"parameters": {
"color": 7,
"width": 1140,
"height": 80,
"content": "## Flowpast.com | Automation Workflow Library\n**\ud83d\udcd6 Full tutorial & setup guide:** flowpast.com"
},
"typeVersion": 1
},
{
"id": "b0a2f427-1788-4707-b2ca-07b7ba9878ab",
"name": "Manual Start Trigger",
"type": "n8n-nodes-base.manualTrigger",
"position": [
1030,
250
],
"parameters": [],
"typeVersion": 1
},
{
"id": "6a6143e1-6181-45a0-988f-e8ed7e634bd8",
"name": "Retrieve Reddit Posts",
"type": "n8n-nodes-base.reddit",
"position": [
875,
200
],
"parameters": {
"keyword": "how do I find leads",
"operation": "search",
"subreddit": "=Entrepreneur",
"additionalFields": {
"sort": "hot"
}
},
"typeVersion": 1
},
{
"id": "f59b3a35-9502-4a69-8b18-6760538765ab",
"name": "Validate Post Metrics",
"type": "n8n-nodes-base.if",
"position": [
595,
255
],
"parameters": {
"options": [],
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "0823d10a-ad54-4d82-bcea-9dd236e97857",
"operator": {
"type": "number",
"operation": "gt"
},
"leftValue": "={{ $json.ups }}",
"rightValue": 2
},
{
"id": "bb8187aa-f0f1-4999-8d4b-bdc9abba0618",
"operator": {
"type": "string",
"operation": "notEmpty",
"singleValue": true
},
"leftValue": "={{ $json.selftext }}",
"rightValue": ""
},
{
"id": "539f0f5c-025a-4f82-9b3a-2ef1ad3a2d96",
"operator": {
"type": "dateTime",
"operation": "after"
},
"leftValue": "={{ DateTime.fromSeconds($json.created).toISO() }}",
"rightValue": "={{ $today.minus(180,'days').toISO() }}"
}
]
}
},
"typeVersion": 2.2
},
{
"id": "405f37a4-d3a8-4d92-8add-ad232be014b7",
"name": "Map Essential Fields",
"type": "n8n-nodes-base.set",
"position": [
450,
235
],
"parameters": {
"options": [],
"assignments": {
"assignments": [
{
"id": "e5082ecc-3add-474e-bdb5-b8ad64729930",
"name": "upvotes",
"type": "string",
"value": "={{ $json.ups }}"
},
{
"id": "a92b5859-fbcc-40c2-95e0-452b12530d98",
"name": "subreddit_subscribers",
"type": "number",
"value": "={{ $json.subreddit_subscribers }}"
},
{
"id": "a846e21c-6cff-4521-9e0c-a32fa1305376",
"name": "postcontent",
"type": "string",
"value": "={{ $json.selftext }}"
},
{
"id": "b8045389-684d-4872-9e32-9a6b5511eb2b",
"name": "url",
"type": "string",
"value": "={{ $json.url }}"
},
{
"id": "f182fedc-1b09-40fe-aeb5-2473263da442",
"name": "date",
"type": "string",
"value": "={{ DateTime.fromSeconds($json.created).toISO() }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "9f2020d1-77f2-4dbc-b6ce-7dae7acd1263",
"name": "Business Need Classifier",
"type": "@n8n/n8n-nodes-langchain.chainLlm",
"position": [
165,
190
],
"parameters": {
"text": "=Decide whether this reddit post is describing a business-related problem or a need for a solution.",
"messages": {
"messageValues": [
{
"message": "The post should mention a specific challenge or requirement that a business is trying to address. Is this post about a business problem or need for a solution ? Output only yes or no"
},
{
"type": "HumanMessagePromptTemplate",
"message": "=Reddit post:  {{ $json.postcontent }}"
}
]
},
"promptType": "define"
},
"typeVersion": 1.6
},
{
"id": "9541106a-af9c-4326-91b1-07f68c9ee386",
"name": "Combine Input Streams",
"type": "n8n-nodes-base.merge",
"position": [
0,
245
],
"parameters": {
"mode": "combine",
"options": [],
"combineBy": "combineByPosition"
},
"typeVersion": 3
},
{
"id": "d88efb10-91cf-4ac0-9f7b-796bfa8a75ab",
"name": "Check Content Flag",
"type": "n8n-nodes-base.if",
"position": [
150,
395
],
"parameters": {
"options": [],
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "d5d38c01-3a88-4767-b488-d9c04145bb8f",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.output }}",
"rightValue": "yes"
}
]
}
},
"typeVersion": 2.2
},
{
"id": "9bf6edaf-e2ad-4702-8730-0600775531cb",
"name": "Generate Post Summary",
"type": "@n8n/n8n-nodes-langchain.chainSummarization",
"position": [
320,
440
],
"parameters": {
"options": []
},
"typeVersion": 2
},
{
"id": "b048b2f6-3c46-4ad2-8255-5b0509e9da0f",
"name": "Format Summary Fields",
"type": "n8n-nodes-base.set",
"position": [
605,
405
],
"parameters": {
"options": [],
"assignments": {
"assignments": [
{
"id": "7038812d-f325-4196-89b6-3623d81dec7b",
"name": "summary",
"type": "string",
"value": "={{ $json.response.text }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "16c397ea-1625-43c6-8602-9150a79858a4",
"name": "Merge Three Sources",
"type": "n8n-nodes-base.merge",
"position": [
765,
445
],
"parameters": {
"mode": "combine",
"options": [],
"combineBy": "combineByPosition"
},
"typeVersion": 3
},
{
"id": "b0ad0465-0daa-48f6-a9c5-8dadca2ca4e1",
"name": "Append to Spreadsheet",
"type": "n8n-nodes-base.googleSheets",
"position": [
1040,
390
],
"parameters": {
"columns": {
"value": [],
"schema": [],
"mappingMode": "autoMapInputData",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": [],
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 979106892,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/[YOUR_ID]/edit#gid=979106892",
"cachedResultName": "Find-Leads"
},
"documentId": {
"__rl": true,
"mode": "id",
"value": "[YOUR_ID]"
}
},
"typeVersion": 4.5
},
{
"id": "924219fa-ae4d-44b3-a42d-e2c67dc85545",
"name": "Prepare Output Fields",
"type": "n8n-nodes-base.set",
"position": [
270,
610
],
"parameters": {
"options": [],
"assignments": {
"assignments": [
{
"id": "1f34c3f3-7be7-474c-9026-7058807a7b3d",
"name": "date",
"type": "string",
"value": "={{ $json.date }}"
},
{
"id": "0e0e5227-e37b-43fc-8a88-2bb76631108d",
"name": "subreddit_subscribers",
"type": "number",
"value": "={{ $json.subreddit_subscribers }}"
},
{
"id": "68e2ca82-6b1d-42ec-acc7-b784e9ed61b5",
"name": "url",
"type": "string",
"value": "={{ $json.url }}"
},
{
"id": "946800a2-ec8b-4f99-a4db-9248bf305747",
"name": "upvotes",
"type": "string",
"value": "={{ $json.upvotes }}"
},
{
"id": "da86d4d3-db84-44e3-a684-38aff2fd5b77",
"name": "postcontent",
"type": "string",
"value": "={{ $json.postcontent }}"
},
{
"id": "b67148e1-67a5-4b10-be6c-c819ff910be0",
"name": "business_opportunity",
"type": "string",
"value": "={{ $json.output }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "571bf6e7-ef36-4a7d-9e9d-e97aef4e7015",
"name": "Primary Chat Model",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenRouter",
"position": [
220,
145
],
"parameters": {
"model": "openai/gpt-4.1-mini",
"options": []
},
"typeVersion": 1
},
{
"id": "7e157fc9-a7cd-42d4-80d5-233308a2441a",
"name": "Secondary Chat Model",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenRouter",
"position": [
515,
560
],
"parameters": {
"model": "openai/gpt-4.1-mini",
"options": []
},
"typeVersion": 1
}
],
"pinData": {
"Combine Input Streams": [
{
"url": "https://www.reddit.com/r/smallbusiness/comments/1iqletb/need_help_and_advice_for_a_business_name_idea/",
"date": "2025-02-16T13:42:12.000+08:00",
"output": "yes",
"upvotes": "4",
"postcontent": "Hello guys,\n\nMy partner and I are planning to open an accounting business that will focus on tax services such as filling taxes and tax advisor and we have plan for future to add wealth management and capital advising. Initially, we were thinking of using the name \"Global Solutions,\" but we found out that another company already has it, so we can\u2019t use it.\n\nWe\u2019re looking for a professional name that\u2019s easy to pronounce and somewhat similar to \"Global Solutions.\" Also, unique enough that we won\u2019t want to change it in the future. Any ideas or suggestions would be greatly appreciated! We would love to list all name suggestions to share with my partner so we can pick the best one.\n\nThanks in advance for your help! Appreciate it! ",
"subreddit_subscribers": 1944498
},
{
"url": "https://www.reddit.com/r/smallbusiness/comments/1iob5ez/business_acquisition_loan_what_are_my_odds_what/",
"date": "2025-02-13T12:34:29.000+08:00",
"output": "yes",
"upvotes": "3",
"postcontent": "Hello!  \nLongtime friends have offered to sell my their local biz.    \n12 years running, last year did 950k gross, 325K SDE.  \nYOY growth has been good.  \n650k price.  \nThey have offered to seller finance up to 61.5% of the purchase price so far.  \nThey might go even higher on the seller financing if I ask.\n\n**The good (about me):**  \n  \n\\- I have good credit, probably 720+.  \n\\- I do have \\~200k equity in my home, I'm willing to collateralize.  \n  \n**The ugly (about me):**  \n  \n\\- I have only 5% down possible for equity injection, but would prefer 0%  \nI read that with a SBA 7(a) loan the seller can do 5% of my equity injection with a standby note (deferred payment until SBA loan is paid off).  I'm not sure if that could be done in tandem with another (much larger) note that would be payable (in payments) at closing.  \n  \n\\- I've had no / negative income the last couple of years.  I took some time off from my 20+ year profession, lived off of savings and some credit while I explored other career paths because I needed a change.  I did learn a couple of high value trades, and did incur some expenses in that process.\n\n\\- No direct industry experience.  I do have much professional experience I bring to the table, but not in this industry.  I have managed people on my team... but not employees.  \n\n**The rest:**  \n  \nThey are willing to hire me as store manager now, if that helps.    \nThey will be providing complete training and ongoing support.  \nIt is a simple business, really.  \nThey obviously believe in their business, given the willingness to seller finance so much of it.  \n  \nWhat are the odds I could get a SBA 7(a) loan with 5% down?  \nAre there any loans with 0% down?  \n  \nI would like to get an extra 50k or so for startup costs - it is an acquisition however I'm going to have startup expenses like first and last months lease payments, jurisdictional inspections, electricity deposit, liability insurance / workman's comp, that sort of stuff.\n\nI realize the scenario is not ideal, however it seems to me there should be SOME option out there given that all I have to do is not mess up the business!  It's a great business, well loved in the community.  \nThere is good room in the revenue for me to make accelerated loan repayments, establish business savings, grow the business, and even pay myself enough to cover my living expenses.  That is one heck of a deal, I have to find some way to pull this off!\n\nI'm willing to look at less fantastic loan offers with higher rates.    \nIt really seems to me that some entity would be willing to lend based on the cashflow / success / stability / of the existing business.\n\nOne idea I had - if sellers would be willing to carry 100% for 12-24 months, would I then likely have an easier time qualifying for a SBA 7(a) loan to pay off their note, or part of it (depending on what they want)?\n\nAnother idea - store manager -> partner -> partner buyout  \nI do need to find out their maximum timeline for getting out.  \n  \nHad I known a couple of years ago this was going to come up, I would have made different decisions!  \nI really don't want to sell my house and rent something in order to do this, but I'm considering that as a last resort.  \nIf these weren't my longtime friends whom I trust with my life, I wouldn't consider this.  I'd be too chicken.  This is like winning the lottery to me, frankly... I'm not the perfect buyer on paper but they really want me to have it.  They know it will be my baby, as it has been theirs.\n\nGrateful for any solutions / ideas, thank you in advance!  =D\n\n",
"subreddit_subscribers": 1944498
},
{
"url": "https://www.reddit.com/r/smallbusiness/comments/1ikcdi5/seeking_a_reliable_alternative_to_stripe_for/",
"date": "2025-02-08T10:09:44.000+08:00",
"output": "yes",
"upvotes": "3",
"postcontent": "Hi everyone,\n\nI'm looking for advice on the **best alternative to Stripe** for my service-based business. Here\u2019s the situation:\n\n* I handle **monthly recurring payments** from customers who prefer paying by **credit card**.\n* My customers provide me with their credit card information, and I need a solution to **send invoices** or **auto-charge their cards monthly** without issues.\n\n# Problems I\u2019ve Faced:\n\n1. **Stripe**: I\u2019ve lost countless disputes despite providing proof of service, and I\u2019m fed up with their **chargeback process**.\n2. **Square**: I processed just **two paid invoices totaling $180**, and they **deactivated my account**, holding my money for **90 days**!\n\nI\u2019m desperate to find a platform that:\n\n* Allows **invoicing** and **recurring auto-charges**.\n* Has **minimal chargebacks or disputes**, or at least a fair dispute resolution process. or **BEST: no disputes at all**\n* Doesn\u2019t hold funds unnecessarily or shut down accounts without notice.\n\nI\u2019m open to hearing about **any reliable options**, whether they are traditional payment processors, blockchain-based platforms, or other innovative solutions.\n\n**Please help!** Any advice would mean the world to me right now.\n\nThank you in advance for your suggestions!",
"subreddit_subscribers": 1944498
},
{
"url": "https://www.reddit.com/r/smallbusiness/comments/1ibkmzd/business_number_being_used_to_spam_call_people/",
"date": "2025-01-28T05:28:30.000+08:00",
"output": "yes",
"upvotes": "7",
"postcontent": "So I just got off the phone with the umpteenth person who has gotten a spam call from someone spoofing with our business number, and I\u2019m just waiting for the day that we start getting negative reviews based on this.\n\nWe\u2019ve gotten angry calls from people for a number of scams, and apparently it\u2019s repeated calls to them.\n\nI feel bad, cos those calls make me mad too, but I get tired of getting cussed out several times a week, and having to explain what spam calls are. I haven\u2019t found any solutions online that look like they\u2019d actually solve the problem.\n\nDoes anyone else get this with their business numbers?",
"subreddit_subscribers": 1944498
},
{
"url": "https://www.reddit.com/r/smallbusiness/comments/1i43orw/im_a_small_business_owner_which_software_should_i/",
"date": "2025-01-18T17:06:49.000+08:00",
"output": "yes",
"upvotes": "38",
"postcontent": "I generate about $100k in annual revenue and don\u2019t have payroll. What software would you recommend, and why? Currently, I create invoices using Excel, but I\u2019m looking for a more efficient solution to send invoices and receive payments seamlessly.\n\nAlso, is there a fee every time I receive a payment? For example, if I receive $20k, $10k, $30k, or $40k?",
"subreddit_subscribers": 1944498
},
{
"url": "https://www.reddit.com/r/smallbusiness/comments/1i1euah/small_business_automation_can_someone_help_me/",
"date": "2025-01-15T03:54:19.000+08:00",
"output": "yes",
"upvotes": "3",
"postcontent": "So I am looking for ways to bring some automations to my business by leveraging the technology available and I started with programing a smart chat bot for my website that literally is an agent who knows everything about my company which is nice when I am not around.  Then I took it further and thought that I could make automated virtual receptionist for my company which I did which makes life better because when I am on a job I miss probably a few calls a day and then when I try to reach them back, they usually have already started to talk to other competitors and then it gets challenging from there.  So this has been my solution and now I never miss a call and started building automations to even sell for me on my products and services that I offer and now even can send a booking link to them by text and email and this has allowed me to convert better and not miss an opportunity that comes my way.  I say all this because I created another on that is used strictly to role play with and I need testers to help me refine and debug it.  Essentially I just need other business owners to role play with my agent and provide any feedback that would make it better or enhance it.  \n\nIf you're willing to help me test it just call [YOUR_PHONE].  Thanks in advance to anyone who tries it out!            ",
"subreddit_subscribers": 1944498
},
{
"url": "https://www.reddit.com/r/smallbusiness/comments/1hzlhcg/customer_emailcommunication_tracker/",
"date": "2025-01-12T20:17:33.000+08:00",
"output": "yes",
"upvotes": "3",
"postcontent": "What system do you use for customer communication?\n\nLooking for recommendations on CSR communication. I have a retail store with one full time retail manager and a handful of seasonal and part time associates. \n\nWebsite inquiries for retail are routed to a generic email of which all associates can respond. The goal was that with a generic email (accessed from one terminal plus an iPad) customers would get responded to quickly but Mozilla Thunderbird\u2019s interface is clunky and associates never remember to \u201cfile\u201d completed conversations. \n\nI am frugal (hence one email address) but am willing to invest in a solution that can better track inquiries (only a handful a week) to provide a better experience. Just curious what you might use that works well. ",
"subreddit_subscribers": 1944498
},
{
"url": "https://www.reddit.com/r/smallbusiness/comments/1hyzgts/had_a_customer_fire_themselves_and_it_felt_good/",
"date": "2025-01-12T00:24:35.000+08:00",
"output": "yes",
"upvotes": "57",
"postcontent": "My work had a newer customer that we were happy to have because we knew they were working with our competition. We did some work for them and they would blame us for their problems. We would offer solutions and never hear back and to top it off they paid late. I also met the owner at a trade show and he treated me like I wasn't even there when I went to say thank you. He just looked at me blankly and ignored me. So we stopped calling.\n\nThen a half year later they send some work in. I quoted it extremely high. They asked for a price discount so they could get the job for their customer. I went down 10% knowing it was still high. Then the owner emailed back about his 25 year relationship with our competitor and how they would do it at half the price. \n\nI felt happy wasting their time and money. Also, if our competitor is so great, why did they start sending us work? \n\nI'm glad we won't hear from them. I have many other customers that are fantastic to work with and pay on time. ",
"subreddit_subscribers": 1944498
},
{
"url": "https://www.reddit.com/r/smallbusiness/comments/1hnqv0q/attention_business_owners_using_benchco/",
"date": "2024-12-28T06:31:18.000+08:00",
"output": "yes",
"upvotes": "8",
"postcontent": "You may have seen in your email that [Bench.co](http://Bench.co) is closing its doors for bookkeeping services. They are giving business owners until **March 7th, 2025**, at **5 PM** ET to download their financial data.\n\nDon't wait until the last minute! This is absolutely critical - your financial data is too important to risk losing. The timing couldn't be worse in the middle of the holidays and so close to year-end... and the lack of advance warning is frustrating.\n\nI know this situation will leave many business owners scrambling for a new bookkeeping solution. But don\u2019t stress\u2014there are excellent alternatives out there that can serve you even better!\n\nI primarily wanted to make this post to alert people of the closure (in case you missed the email) and encourage everyone to secure their data ASAP. If you're looking for a reliable path forward, I'd recommend exploring smaller firms or individual remote bookkeepers. Many offer highly personalized services at a wide range of prices - with services often far better quality than Bench.\n\nI'm not here to promote my business, but if you're feeling overwhelmed or don't know where to start, I'm happy to chat and share advice based on my experience running a remote bookkeeping and accounting firm. At the end of the day, I hope all Bench clients find a bookkeeping service that's a better fit: personalized, reliable, and capable of supporting your business long-term.\n\n  \nTo add a question and make sure I'm following the sub rules: \n\nWhat are you currently doing for your bookkeeping and accounting? How did you find that solution and what do you wish was different about it?",
"subreddit_subscribers": 1944498
}
]
},
"connections": {
"Retrieve Reddit Posts": {
"main": [
[
{
"node": "Validate Post Metrics",
"type": "main",
"index": 0
}
]
]
},
"Format Summary Fields": {
"main": [
[
{
"node": "Merge Three Sources",
"type": "main",
"index": 0
}
]
]
},
"Combine Input Streams": {
"main": [
[
{
"node": "Check Content Flag",
"type": "main",
"index": 0
}
]
]
},
"Prepare Output Fields": {
"main": [
[
{
"node": "Merge Three Sources",
"type": "main",
"index": 1
}
]
]
},
"Merge Three Sources": {
"main": [
[
{
"node": "Append to Spreadsheet",
"type": "main",
"index": 0
}
]
]
},
"Business Need Classifier": {
"main": [
[
{
"node": "Combine Input Streams",
"type": "main",
"index": 0
}
]
]
},
"Map Essential Fields": {
"main": [
[
{
"node": "Combine Input Streams",
"type": "main",
"index": 1
},
{
"node": "Business Need Classifier",
"type": "main",
"index": 0
}
]
]
},
"Generate Post Summary": {
"main": [
[
{
"node": "Format Summary Fields",
"type": "main",
"index": 0
}
]
]
},
"Primary Chat Model": {
"ai_languageModel": [
[
{
"node": "Business Need Classifier",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Secondary Chat Model": {
"ai_languageModel": [
[
{
"node": "Generate Post Summary",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Check Content Flag": {
"main": [
[
{
"node": "Generate Post Summary",
"type": "main",
"index": 0
},
{
"node": "Prepare Output Fields",
"type": "main",
"index": 0
}
]
]
},
"Validate Post Metrics": {
"main": [
[
{
"node": "Map Essential Fields",
"type": "main",
"index": 0
}
]
]
},
"Manual Start Trigger": {
"main": [
[
{
"node": "Retrieve Reddit Posts",
"type": "main",
"index": 0
}
]
]
}
},
"cleaning_summary": "Removed original sticky notes, rebranded with Flowpast header, renamed all nodes, sanitized IDs, updated connections and pinData keys, and reorganized layout with mirrored zigzag spacing."
}