January 22, 2026

Reddit to Google Sheets, only viral posts saved

Lisa Granqvist Partner Workflow Automation Expert

Get a free AI assessment → ⬇️ Use template

You find a great AskReddit thread, swear you’ll use it later, and then it disappears into a sea of open tabs and half-saved notes. Next week you do it again. Same scroll, same “I’ll remember this” lie.

This Reddit Sheets automation is for marketers building content calendars, founders who need ideas on demand, and creators running Shorts who can’t waste mornings hunting for “the one” prompt. The payoff is simple: a clean backlog of only high-potential threads, already scored, with repeats removed.

You’ll see how the workflow pulls trending posts, screens them, deduplicates against what you already saved, scores virality using AI, then appends only the best candidates into Google Sheets.

How This Automation Works

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

n8n Workflow Template: Reddit to Google Sheets, only viral posts saved

Click to explore

flowchart LR

    subgraph sg0["Manual Launch Flow"]
        direction LR
        n0@{ icon: "mdi:play-circle", form: "rounded", label: "Manual Launch Trigger", pos: "b", h: 48 }
        n1["<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/httprequest.dark.svg' width='40' height='40' /></div><br/>Fetch Confession Posts"]
        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/code.svg' width='40' height='40' /></div><br/>Screen Post Content"]
        n3["<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/>Select Viral Candidates"]
        n4@{ icon: "mdi:database", form: "rounded", label: "Retrieve Sheet Rows", pos: "b", h: 48 }
        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/merge.svg' width='40' height='40' /></div><br/>Combine With Sheet Data"]
        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/>Remove Existing Entries"]
        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/code.svg' width='40' height='40' /></div><br/>Assign Sequence Numbers"]
        n8@{ icon: "mdi:robot", form: "rounded", label: "Generate Virality Rating", 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/merge.svg' width='40' height='40' /></div><br/>Merge Scores Stream"]
        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/code.svg' width='40' height='40' /></div><br/>Apply Rating Field"]
        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/code.svg' width='40' height='40' /></div><br/>Filter High Ratings"]
        n12@{ icon: "mdi:database", form: "rounded", label: "Append Sheet Records", pos: "b", h: 48 }
        n5 --> n6
        n9 --> n10
        n7 --> n8
        n7 --> n9
        n11 --> n12
        n6 --> n7
        n10 --> n11
        n8 --> n9
        n1 --> n2
        n4 --> n5
        n2 --> n3
        n3 --> n5
        n3 --> n4
        n0 --> n1
    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 n8 ai
    class n4,n12 database
    class n1 api
    class n2,n3,n6,n7,n10,n11 code
    classDef customIcon fill:none,stroke:none
    class n1,n2,n3,n5,n6,n7,n9,n10,n11 customIcon

Why This Matters: Your “idea backlog” is full of junk

AskReddit is basically an infinite content generator, but the volume is the trap. You can spend about 45 minutes scrolling, save 30 links, and still end up with nothing you actually want to produce. Then comes the quiet time-waster: duplicates, near-duplicates, and threads that look good until you open them and realize there’s no story, no tension, and no hook. Meanwhile your Google Sheet (or Notion doc, or Slack channel) becomes a dumping ground. When it’s time to create, you’re “researching” again instead of shipping.

It adds up fast. Here’s where it breaks down.

You keep saving the same themes because nothing checks your existing backlog before you add more.
Manual vetting is inconsistent, so strong threads get buried next to low-effort posts.
Your team can’t agree on what “viral potential” means, which leads to endless re-picking.
By the time you decide, the trend has cooled and the thread is no longer useful.

What You’ll Build: A scored, deduped AskReddit idea pipeline

This workflow automatically collects trending AskReddit-style posts, filters out the weak ones, and saves only the best candidates into Google Sheets. It starts by fetching a batch of posts from Reddit via an HTTP request, then it screens the content so you’re not scoring obvious junk or posts that won’t translate into a short. Next, it pulls your existing rows from Google Sheets and merges that data with the new batch so the workflow can remove anything you’ve already captured. After that, it assigns sequence numbers and uses an AI rating step (OpenAI via n8n’s LangChain node) to generate a virality rating. Finally, it keeps only the high ratings and appends those winners to your sheet, ready for scripting in the next phase of your pipeline.

The workflow kicks off manually (or on a schedule if you prefer). Reddit posts are screened and shortlisted, then checked against your existing Sheet to dedupe. AI scoring happens after the shortlist, and only high-rated threads get written to Google Sheets.

What You’re Building

What Gets Automated

What You’ll Achieve

Pull new AskReddit posts automatically via the Reddit API.
Screen posts to keep only prompts with usable content.
Compare against your existing Google Sheet rows and remove duplicates.
Generate an AI-based virality rating and filter to “only the best”.

Turn a 45-minute scroll session into about 10 minutes of review.
Keep one clean backlog your whole team can trust.
Stop re-saving the same threads week after week.
Pick topics faster because every row is pre-scored.
Feed Phase 2 (scripts, videos, publishing) with better inputs.

Expected Results

Say you want 20 solid thread ideas per week. Manually, a typical process is: about 45 minutes finding posts, 30 minutes checking for duplicates in your sheet, and another 30 minutes arguing with yourself about what’s “good”, so call it roughly 2 hours. With this workflow, you run it, wait a few minutes for scoring, then spend about 10–15 minutes scanning the top-rated rows and picking winners. That’s around 90 minutes back each week, and the backlog stays clean instead of bloated.

Before You Start

n8n instance (try n8n Cloud free)
Self-hosting option if you prefer (Hostinger works well)
Reddit API access to fetch AskReddit posts
Google Sheets to store your scored idea backlog
OpenAI API key (get it from the OpenAI API dashboard)

Skill level: Intermediate. You’ll connect accounts, paste an API key, and edit a couple of fields and filters confidently.

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

Step by Step

A manual run (or a schedule) triggers the pull. The workflow starts with a manual launch trigger, then uses an HTTP request to fetch a fresh batch of posts from Reddit.

Posts get screened before you waste time scoring them. A screening step evaluates the post content and narrows the list down to candidates that are more likely to work as prompts (the difference between “interesting thread” and “usable content seed” matters).

Deduping happens against your existing Google Sheet. The workflow retrieves your current sheet rows, merges them with the candidates, then removes anything already logged so your backlog stays genuinely new.

AI generates a virality rating, then only high scores get saved. The workflow assigns sequence numbers, sends each candidate through an OpenAI rating step, merges scores back into the dataset, filters for high ratings, and appends the final set into Google Sheets.

You can easily modify the scoring logic to match your niche and your audience. See the full implementation guide below for customization options.

Step-by-Step Implementation Guide

Step 1: Configure the Manual Trigger

Start the workflow manually while you validate the Reddit pipeline and scoring logic.

Add the Manual Launch Trigger node as your trigger.
Keep default settings for Manual Launch Trigger to allow manual runs.
(Optional) Leave the Flowpast Branding sticky note unchanged for documentation context.

Step 2: Connect Google Sheets

Configure the sheet read/write operations used to avoid duplicates and store high-scoring posts.

Open Retrieve Sheet Rows and select the spreadsheet in Document and worksheet in Sheet.
Credential Required: Connect your googleSheetsOAuth2Api credentials in Retrieve Sheet Rows.
Open Append Sheet Records and select the same Document and Sheet used for reading.
Credential Required: Connect your googleSheetsOAuth2Api credentials in Append Sheet Records.

Tip: Replace the placeholder sheet identifiers like [YOUR_ID] in both Google Sheets nodes before testing.

Step 3: Configure Reddit Fetching and Initial Screening

Pull hot posts from r/confession and filter out unwanted topics and low-engagement content.

In Fetch Confession Posts, set URL to https://www.reddit.com/r/confession/hot.json?limit=30.
In Fetch Confession Posts, enable Send Headers and add the header User-Agent with value n8n-askreddit-scraper.
In Screen Post Content, keep the JS filter that excludes titles containing trump, president, war, and israel, and maps fields like post_id, title, selftext, score, and num_comments.
In Select Viral Candidates, keep the JS logic requiring score > 60, num_comments > 40, and over_18 === false.

Step 4: Merge with Existing Sheet Data and De-duplicate

Branch the filtered posts to merge with the existing sheet, remove duplicates, and sequence new items.

Ensure Select Viral Candidates outputs to both Combine With Sheet Data and Retrieve Sheet Rows in parallel.
Verify Combine With Sheet Data merges the candidate posts with the sheet rows, then flows to Remove Existing Entries.
In Remove Existing Entries, keep the JS that compares post_id to existing Reddit Post ID values to prevent duplicates.
In Assign Sequence Numbers, keep the JS that adds a sequential number field to each new item.

Step 5: Set Up AI Scoring and High-Score Filtering

Send each candidate to the AI model, merge scores back to items, and filter for high virality.

Assign Sequence Numbers outputs to both Generate Virality Rating and Merge Scores Stream in parallel.
In Generate Virality Rating, select model gpt-4o and keep the prompt that rates virality using {{$json.title}}.
Credential Required: Connect your openAiApi credentials in Generate Virality Rating.
In Merge Scores Stream, set Mode to combine and Combine By to combineByPosition.
In Apply Rating Field, keep the JS that maps the AI response to virality_score using item.json.message?.content.trim().
In Filter High Ratings, keep the filter that allows only virality_score >= 6.

⚠️ Common Pitfall: If the AI response includes extra text, Filter High Ratings may fail to parse the number. Ensure the prompt returns only a numeric score.

Step 6: Configure Output to Google Sheets

Append only high-scoring posts into your Google Sheet with the correct field mappings.

In Append Sheet Records, set Operation to append.
Map columns exactly as configured, including Date to {{new Date().toISOString().slice(0, 10)}}, Number to {{ $json.number }}, Upvotes to {{ $json.score }}, Comments to {{ $json.num_comments }}, Question to {{ $json.title }}, Reddit Post ID to {{ $json.post_id }}, and Virality Score to {{ $json.virality_score }}.
Keep static values like TYPE set to CONFESSION and Status set to TODO.

Step 7: Test and Activate Your Workflow

Run a manual test to validate data flow, AI scoring, and sheet updates before activating.

Click Execute Workflow starting from Manual Launch Trigger.
Confirm Fetch Confession Posts returns JSON data and Screen Post Content outputs cleaned items.
Verify Generate Virality Rating returns a numeric score and Filter High Ratings outputs only items with scores >= 6.
Check your Google Sheet to ensure Append Sheet Records added rows with the expected fields.
When satisfied, toggle the workflow to Active for production use.

🔒

Unlock Full Step-by-Step Guide

Get the complete implementation guide + downloadable template

Troubleshooting Tips

Reddit API credentials can expire or require the right app settings. If the “Fetch Confession Posts” request starts failing, check your Reddit app credentials and redirect settings first.
If you’re using AI rating at any real volume, OpenAI can rate limit you. Slow down the run, reduce batch size, or add a short wait if the rating step returns empty or inconsistent results.
Google Sheets failures are often permission-related. Confirm the connected Google account can edit the target sheet, and that the “Append Sheet Records” node points to the right spreadsheet and tab.

Quick Answers

What’s the setup time for this Reddit Sheets automation automation?

About 30 minutes if your Reddit, Google, and OpenAI accounts are ready.

Is coding required for this automate Reddit scoring?

No. You’ll connect accounts and adjust a couple of filters and fields.

Is n8n free to use for this Reddit Sheets automation 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, which are usually a few dollars a month at small volumes.

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 Reddit Sheets automation workflow for different use cases?

Yes, pretty easily. You can change what Reddit endpoint you pull from in the “Fetch Confession Posts” HTTP Request node, then tweak the screening and candidate selection logic to match your format (questions, stories, controversies). Most people also adjust the “Generate Virality Rating” prompt so the score reflects their platform, like YouTube Shorts vs. TikTok. If you want stricter deduping, update the “Remove Existing Entries” logic to match on URL plus normalized title.

Why is my Google Sheets connection failing in this workflow?

Usually it’s a permissions issue on the spreadsheet or the connected Google account. Reconnect Google Sheets in n8n, then confirm the sheet and tab selected in “Retrieve Sheet Rows” and “Append Sheet Records” still exist. If you recently renamed the tab, n8n can keep pointing at the old one. Also check that your Google account isn’t blocked by a workspace admin rule.

What volume can this Reddit Sheets automation workflow process?

On n8n Cloud Starter, you can typically run thousands of executions per month, and self-hosting has no execution cap (your server becomes the limit). Practically, AI scoring is the bottleneck, so most teams run this in batches a few times per week instead of trying to rate hundreds of posts every hour.

Is this Reddit Sheets automation automation better than using Zapier or Make?

Often, yes. This workflow uses multi-step filtering, merging against existing Sheet rows for dedupe, and a custom AI rating step, which is where Zapier and Make can get clunky or pricey at scale. n8n also lets you self-host, which is a big deal if you run lots of executions. That said, if you only want “save new Reddit post to Google Sheets” with no scoring and no dedupe, Zapier or Make will feel quicker to set up. Talk to an automation expert if you want help choosing.

Once this is running, your idea backlog stops being a graveyard of links and becomes a real input to production. The workflow handles the sorting and cleanup so you can focus on the part that actually matters: making the content.

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": "",
"meta": {
"instanceId": "a25025ee662ed8ba49591e1e1b90d085d502fd2e753e3307d3fcfcfe885fa469",
"templateId": "",
"templateCredsSetupCompleted": ""
},
"name": "Reddit Content Scoring Pipeline",
"tags": [],
"nodes": [
{
"id": "flowpast-topbar-7923",
"name": "Flowpast Branding",
"type": "n8n-nodes-base.stickyNote",
"position": [
0,
20
],
"parameters": {
"color": 7,
"width": 1220,
"height": 80,
"content": "## Flowpast.com | Automation Workflow Library\n**\ud83d\udcd6 Full tutorial & setup guide:** flowpast.com"
},
"typeVersion": 1
},
{
"id": "9c8ba3f0-8f62-476e-8f0d-1af27da4c271",
"name": "Manual Launch Trigger",
"type": "n8n-nodes-base.manualTrigger",
"position": [
10,
125
],
"parameters": [],
"typeVersion": 1
},
{
"id": "1fbba9af-2a49-43f9-aeae-fc5b009e51a9",
"name": "Fetch Confession Posts",
"type": "n8n-nodes-base.httpRequest",
"position": [
245,
170
],
"parameters": {
"url": "https://www.reddit.com/r/confession/hot.json?limit=30",
"options": {
"response": {
"response": {
"responseFormat": "json"
}
}
},
"sendHeaders": true,
"headerParameters": {
"parameters": [
{
"name": "User-Agent",
"value": "n8n-askreddit-scraper"
}
]
}
},
"typeVersion": 4.2
},
{
"id": "301ccc14-a647-4e4b-918b-6d2ffe0bac33",
"name": "Screen Post Content",
"type": "n8n-nodes-base.code",
"position": [
430,
120
],
"parameters": {
"jsCode": "return items[0].json.data.children\n  .filter(post => {\n    const title = post.data.title.toLowerCase();\n    return !title.includes(\"trump\") &&\n           !title.includes(\"president\") &&\n           !title.includes(\"war\") &&\n           !title.includes(\"israel\");\n  })\n  .map(post => {\n    const data = post.data;\n    return {\n      json: {\n        post_id: data.id,\n        title: data.title,\n        selftext:data.selftext,\n        score: data.score,\n        num_comments: data.num_comments,\n        over_18: data.over_18 // to filter NSFW later\n      }\n    };\n  });\n"
},
"typeVersion": 2
},
{
"id": "20b6d540-0241-4fcd-a5d1-9bd836953edd",
"name": "Select Viral Candidates",
"type": "n8n-nodes-base.code",
"position": [
680,
165
],
"parameters": {
"jsCode": "return items.filter(item => {\n  const { score, num_comments, over_18 } = item.json;\n  return score > 60 && num_comments > 40 && over_18 === false;\n});"
},
"typeVersion": 2
},
{
"id": "da7d00b2-64dd-46ec-a90f-f355b129fef5",
"name": "Retrieve Sheet Rows",
"type": "n8n-nodes-base.googleSheets",
"position": [
605,
380
],
"parameters": {
"options": [],
"sheetName": {
"__rl": true,
"mode": "list",
"value": "[YOUR_ID]",
"cachedResultUrl": "",
"cachedResultName": "ASKREDDIT"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "[YOUR_ID]",
"cachedResultUrl": "",
"cachedResultName": "n8n Resume Studio"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "credential-id",
"name": ""
}
},
"executeOnce": true,
"typeVersion": 4.5
},
{
"id": "de14ca44-907d-4fc5-a67f-66a76318cec5",
"name": "Combine With Sheet Data",
"type": "n8n-nodes-base.merge",
"position": [
400,
330
],
"parameters": [],
"typeVersion": 3
},
{
"id": "78d810f4-8d49-440f-975f-1520d4a41714",
"name": "Remove Existing Entries",
"type": "n8n-nodes-base.code",
"position": [
225,
375
],
"parameters": {
"jsCode": "const inputData = $input.all(); // gets all input items\n\nconst redditPosts = inputData.filter(i => i.json.post_id);\nconst existingRows = inputData.filter(i => i.json[\"Reddit Post ID\"]);\n\nconst existingPostIds = new Set(\n  existingRows\n    .map(row => row.json[\"Reddit Post ID\"])\n    .filter(id => id !== undefined && id !== null)\n    .map(id => id.toString())\n);\n\nreturn redditPosts.filter(item =>\n  !existingPostIds.has(item.json.post_id.toString())\n);\n"
},
"typeVersion": 2
},
{
"id": "91f6516f-3fd6-42ab-9f3d-815159158e76",
"name": "Assign Sequence Numbers",
"type": "n8n-nodes-base.code",
"position": [
0,
335
],
"parameters": {
"jsCode": "let count = 1;\nreturn items.map(item => {\n  return {\n    json: {\n      number: count++,\n      ...item.json\n    }\n  };\n});\n"
},
"typeVersion": 2
},
{
"id": "f3fa1876-7a35-4307-989a-1b2b5df7ff66",
"name": "Generate Virality Rating",
"type": "@n8n/n8n-nodes-langchain.openAi",
"position": [
235,
525
],
"parameters": {
"modelId": {
"__rl": true,
"mode": "list",
"value": "gpt-4o",
"cachedResultName": "GPT-4O"
},
"options": [],
"messages": {
"values": [
{
"role": "assistant",
"content": "You're an expert in viral content analysis. Rate the virality potential (1\u201310) of this Reddit question based on emotional engagement, curiosity, and relatability: {{$json.title}}. Respond with just the number.\n"
}
]
}
},
"credentials": {
"openAiApi": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 1.8
},
{
"id": "82c8e67f-3f68-4aaa-9616-eb2ae9da3541",
"name": "Merge Scores Stream",
"type": "n8n-nodes-base.merge",
"position": [
405,
570
],
"parameters": {
"mode": "combine",
"options": [],
"combineBy": "combineByPosition"
},
"typeVersion": 3
},
{
"id": "357ae2b6-972d-432e-a6e4-ef9f291717ba",
"name": "Apply Rating Field",
"type": "n8n-nodes-base.code",
"position": [
670,
530
],
"parameters": {
"jsCode": "return items.map((item, index) => {\n  return {\n    json: {\n      ...item.json,\n      virality_score: item.json.message?.content.trim()\n    }\n  };\n});\n"
},
"typeVersion": 2
},
{
"id": "65d1201d-59c6-43af-a4da-8d45a02fac9c",
"name": "Filter High Ratings",
"type": "n8n-nodes-base.code",
"position": [
835,
575
],
"parameters": {
"jsCode": "return items.filter(item => {\n  const score = parseInt(item.json.virality_score, 10);\n  return score >= 6;\n});\n"
},
"typeVersion": 2
},
{
"id": "95197a4e-63c2-4e88-af7c-7a9e2d0a57de",
"name": "Append Sheet Records",
"type": "n8n-nodes-base.googleSheets",
"position": [
1120,
535
],
"parameters": {
"columns": {
"value": {
"Date": "={{new Date().toISOString().slice(0, 10)}}",
"TYPE": "CONFESSION",
"Number": "={{ $json.number }}",
"Status": "TODO",
"Upvotes": "={{ $json.score }}",
"Answer 1": "={{ $json.selftext }}",
"Comments": "={{ $json.num_comments }}",
"Question": "={{ $json.title }}",
"Reddit Post ID": "={{ $json.post_id }}",
"Virality Score": "={{ $json.virality_score }}"
},
"schema": [
{
"id": "Number",
"type": "string",
"display": true,
"required": false,
"displayName": "Number",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Date",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Date",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Question",
"type": "string",
"display": true,
"required": false,
"displayName": "Question",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Virality Score",
"type": "string",
"display": true,
"required": false,
"displayName": "Virality Score",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Upvotes",
"type": "string",
"display": true,
"required": false,
"displayName": "Upvotes",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Comments",
"type": "string",
"display": true,
"required": false,
"displayName": "Comments",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Reddit Post ID",
"type": "string",
"display": true,
"required": false,
"displayName": "Reddit Post ID",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Status",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Answer 1",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Answer 1",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Answer 2",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Answer 2",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Answer 3",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Answer 3",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Answer 4",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Answer 4",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Answer 5",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Answer 5",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Answer 6",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Answer 6",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "AUDIO ID",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "AUDIO ID",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "YouTube Video Title",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "YouTube Video Title",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "YouTube Description",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "YouTube Description",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "YouTube Tags",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "YouTube Tags",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "YouTube Video ID",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "YouTube Video ID",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "YouTube Link",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "YouTube Link",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "CTR (Click-Through Rate)",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "CTR (Click-Through Rate)",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Average View Duration",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Average View Duration",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Audience Retention %",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Audience Retention %",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Likes",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Likes",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Comments Count",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Comments Count",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Thumbnail Version",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Thumbnail Version",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Title Version",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Title Version",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Optimization Notes",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Optimization Notes",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Last Updated",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Last Updated",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "TYPE",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "TYPE",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": [],
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "[YOUR_ID]",
"cachedResultUrl": "",
"cachedResultName": "ASKREDDIT"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "[YOUR_ID]",
"cachedResultUrl": "",
"cachedResultName": "n8n Resume Studio"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 4.5
}
],
"active": false,
"pinData": [],
"settings": "{\"executionOrder\":\"v1\"}",
"versionId": "",
"connections": {
"Combine With Sheet Data": {
"main": [
[
{
"node": "Remove Existing Entries",
"type": "main",
"index": 0
}
]
]
},
"Merge Scores Stream": {
"main": [
[
{
"node": "Apply Rating Field",
"type": "main",
"index": 0
}
]
]
},
"Assign Sequence Numbers": {
"main": [
[
{
"node": "Generate Virality Rating",
"type": "main",
"index": 0
},
{
"node": "Merge Scores Stream",
"type": "main",
"index": 0
}
]
]
},
"Filter High Ratings": {
"main": [
[
{
"node": "Append Sheet Records",
"type": "main",
"index": 0
}
]
]
},
"Remove Existing Entries": {
"main": [
[
{
"node": "Assign Sequence Numbers",
"type": "main",
"index": 0
}
]
]
},
"Apply Rating Field": {
"main": [
[
{
"node": "Filter High Ratings",
"type": "main",
"index": 0
}
]
]
},
"Generate Virality Rating": {
"main": [
[
{
"node": "Merge Scores Stream",
"type": "main",
"index": 1
}
]
]
},
"Fetch Confession Posts": {
"main": [
[
{
"node": "Screen Post Content",
"type": "main",
"index": 0
}
]
]
},
"Retrieve Sheet Rows": {
"main": [
[
{
"node": "Combine With Sheet Data",
"type": "main",
"index": 1
}
]
]
},
"Screen Post Content": {
"main": [
[
{
"node": "Select Viral Candidates",
"type": "main",
"index": 0
}
]
]
},
"Append Sheet Records": {
"main": [
[]
]
},
"Select Viral Candidates": {
"main": [
[
{
"node": "Combine With Sheet Data",
"type": "main",
"index": 0
},
{
"node": "Retrieve Sheet Rows",
"type": "main",
"index": 0
}
]
]
},
"Manual Launch Trigger": {
"main": [
[
{
"node": "Fetch Confession Posts",
"type": "main",
"index": 0
}
]
]
}
}
}