AutomationFlowsMarketing & Ads › Reddit to Google Sheets: Tracking Freelance/job Leads

Reddit to Google Sheets: Tracking Freelance/job Leads

Byiamvaar @iamvaar on n8n.io

Goal: Get Reddit posts from specific subreddits, filter those mentioning freelance/gigs and n8n, extract top-level comments, remove mod replies, and store everything into Google Sheets.

Cron / scheduled trigger★★★★★ complexity33 nodesHTTP RequestRedditGoogle Sheets
Marketing & Ads Trigger: Cron / scheduled Nodes: 33 Complexity: ★★★★★ Added:

This workflow corresponds to n8n.io template #6364 — we link there as the canonical source.

This workflow follows the Google Sheets → HTTP Request recipe pattern — see all workflows that pair these two integrations.

The workflow JSON

Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →

Download .json
{
  "meta": {
    "templateCredsSetupCompleted": true
  },
  "nodes": [
    {
      "id": "04becc9e-1219-4d5d-87b0-d788b4566ed8",
      "name": "Hiring-related Comments",
      "type": "n8n-nodes-base.filter",
      "position": [
        1180,
        400
      ],
      "parameters": {},
      "typeVersion": 2.2
    },
    {
      "id": "db5366b3-0a45-4bef-bfb8-91c80f69a6b6",
      "name": "Schedule Trigger",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -1520,
        400
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "c72c05d0-b6d5-4307-986d-b12d0f9cf1e6",
      "name": "HTTP Request",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -680,
        -220
      ],
      "parameters": {},
      "typeVersion": 4.2
    },
    {
      "id": "f72871e6-c32b-412d-b8fe-5f4ce10c41f9",
      "name": "Extract Post Metadata",
      "type": "n8n-nodes-base.set",
      "position": [
        -460,
        -220
      ],
      "parameters": {},
      "executeOnce": true,
      "typeVersion": 3.4
    },
    {
      "id": "dce2b24f-e7c8-4100-86bb-f5d51bf2347b",
      "name": "Seperate array into individual posts",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        -240,
        -220
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "270581bf-6e27-48eb-bf93-30c1e11ff922",
      "name": "HTTP Request1",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -680,
        -20
      ],
      "parameters": {},
      "typeVersion": 4.2
    },
    {
      "id": "f3c70ed5-cd34-4213-84f3-0cd6628a6252",
      "name": "Extract Post Metadata1",
      "type": "n8n-nodes-base.set",
      "position": [
        -460,
        -20
      ],
      "parameters": {},
      "executeOnce": true,
      "typeVersion": 3.4
    },
    {
      "id": "eae24fb3-44fb-4cb8-b157-5b868b0f2d71",
      "name": "Seperate array into individual posts1",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        -240,
        -20
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "f3a59858-a094-425e-9cd2-cf0e7517d239",
      "name": "HTTP Request2",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -680,
        180
      ],
      "parameters": {},
      "typeVersion": 4.2
    },
    {
      "id": "a17fb5c2-36e2-41d1-a6e3-4ea4bc02eefa",
      "name": "Extract Post Metadata2",
      "type": "n8n-nodes-base.set",
      "position": [
        -460,
        180
      ],
      "parameters": {},
      "executeOnce": true,
      "typeVersion": 3.4
    },
    {
      "id": "7dbc702d-f62f-4aeb-a635-ad5a5e5b1120",
      "name": "Seperate array into individual posts2",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        -240,
        180
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "4f35c59b-e512-4629-971f-f11672ce1109",
      "name": "HTTP Request3",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -680,
        380
      ],
      "parameters": {},
      "typeVersion": 4.2
    },
    {
      "id": "09668680-9cdf-4436-8009-0e9b484f465b",
      "name": "Extract Post Metadata3",
      "type": "n8n-nodes-base.set",
      "position": [
        -460,
        380
      ],
      "parameters": {},
      "executeOnce": true,
      "typeVersion": 3.4
    },
    {
      "id": "ba230844-0a37-4d28-8805-f54bc1bb98f1",
      "name": "Seperate array into individual posts3",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        -240,
        380
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "9535e134-4a67-4997-ab27-b7503bdfe25d",
      "name": "HTTP Request4",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -680,
        580
      ],
      "parameters": {},
      "typeVersion": 4.2
    },
    {
      "id": "67130ebe-7cd2-43cc-bc90-7be9d0272a27",
      "name": "Extract Post Metadata4",
      "type": "n8n-nodes-base.set",
      "position": [
        -460,
        580
      ],
      "parameters": {},
      "executeOnce": true,
      "typeVersion": 3.4
    },
    {
      "id": "76c71a43-c722-497c-b679-b2def1ea80e9",
      "name": "Seperate array into individual posts4",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        -240,
        580
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "7ae47de8-56df-439f-9171-dfd822fd0315",
      "name": "HTTP Request5",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -680,
        780
      ],
      "parameters": {},
      "typeVersion": 4.2
    },
    {
      "id": "0a7a02a7-8da5-4e3b-97ef-9185150b463c",
      "name": "Extract Post Metadata5",
      "type": "n8n-nodes-base.set",
      "position": [
        -460,
        780
      ],
      "parameters": {},
      "executeOnce": true,
      "typeVersion": 3.4
    },
    {
      "id": "02422331-50c1-4514-a5de-816caa8fbcdf",
      "name": "Seperate array into individual posts5",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        -240,
        780
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "f3fe6f03-0837-47c0-9a42-2586d43a378b",
      "name": "Merge",
      "type": "n8n-nodes-base.merge",
      "position": [
        440,
        320
      ],
      "parameters": {},
      "typeVersion": 3.2
    },
    {
      "id": "561f0943-dfa3-4996-a5c9-d55816e6931b",
      "name": "HTTP Request6",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -680,
        980
      ],
      "parameters": {},
      "typeVersion": 4.2
    },
    {
      "id": "87672942-3f52-4b8e-b127-f29bfda058cf",
      "name": "Extract Post Metadata6",
      "type": "n8n-nodes-base.set",
      "position": [
        -460,
        980
      ],
      "parameters": {},
      "executeOnce": true,
      "typeVersion": 3.4
    },
    {
      "id": "8ce5fce5-8082-4faf-b0e9-22aa28007859",
      "name": "Seperate array into individual posts6",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        -240,
        980
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "25ecda48-9dda-4e09-a706-982f5c1c0dc6",
      "name": "HTTP Request7",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -680,
        1180
      ],
      "parameters": {},
      "typeVersion": 4.2
    },
    {
      "id": "5e3f5332-a0f2-42e1-bf0b-35b54426a79e",
      "name": "Extract Post Metadata7",
      "type": "n8n-nodes-base.set",
      "position": [
        -460,
        1180
      ],
      "parameters": {},
      "executeOnce": true,
      "typeVersion": 3.4
    },
    {
      "id": "3e65993e-6d66-43c5-8d10-5b82243325f4",
      "name": "Seperate array into individual posts7",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        -240,
        1180
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "d501a2c0-b965-4316-8984-9bbd7aa6fe80",
      "name": "Get many comments FROM multiple POSTS",
      "type": "n8n-nodes-base.reddit",
      "position": [
        660,
        420
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "4f66b9d6-d89f-4407-a991-6a6923d70ec9",
      "name": "Remove Mod Comments",
      "type": "n8n-nodes-base.if",
      "position": [
        880,
        420
      ],
      "parameters": {},
      "typeVersion": 2.2
    },
    {
      "id": "b2014028-66a1-427d-96da-bb50f2ed9327",
      "name": "Get present leads",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1460,
        400
      ],
      "parameters": {},
      "executeOnce": true,
      "typeVersion": 4.6,
      "alwaysOutputData": true
    },
    {
      "id": "cdb62081-0cf5-4963-8f11-4eaf555bf8b5",
      "name": "Filter Unique Leads",
      "type": "n8n-nodes-base.code",
      "position": [
        1680,
        400
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "370622ad-1a60-434f-b4e6-b480f8f346f1",
      "name": "Add Leads to Google Sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1900,
        400
      ],
      "parameters": {},
      "typeVersion": 4.6
    },
    {
      "id": "5ca55e9b-4989-4512-809d-a543c325dc92",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -3700,
        -260
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    }
  ],
  "connections": {
    "Merge": {
      "main": [
        [
          {
            "node": "Get many comments FROM multiple POSTS",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "HTTP Request": {
      "main": [
        [
          {
            "node": "Extract Post Metadata",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "HTTP Request1": {
      "main": [
        [
          {
            "node": "Extract Post Metadata1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "HTTP Request2": {
      "main": [
        [
          {
            "node": "Extract Post Metadata2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "HTTP Request3": {
      "main": [
        [
          {
            "node": "Extract Post Metadata3",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "HTTP Request4": {
      "main": [
        [
          {
            "node": "Extract Post Metadata4",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "HTTP Request5": {
      "main": [
        [
          {
            "node": "Extract Post Metadata5",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "HTTP Request6": {
      "main": [
        [
          {
            "node": "Extract Post Metadata6",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "HTTP Request7": {
      "main": [
        [
          {
            "node": "Extract Post Metadata7",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Schedule Trigger": {
      "main": [
        [
          {
            "node": "HTTP Request",
            "type": "main",
            "index": 0
          },
          {
            "node": "HTTP Request1",
            "type": "main",
            "index": 0
          },
          {
            "node": "HTTP Request2",
            "type": "main",
            "index": 0
          },
          {
            "node": "HTTP Request3",
            "type": "main",
            "index": 0
          },
          {
            "node": "HTTP Request4",
            "type": "main",
            "index": 0
          },
          {
            "node": "HTTP Request5",
            "type": "main",
            "index": 0
          },
          {
            "node": "HTTP Request6",
            "type": "main",
            "index": 0
          },
          {
            "node": "HTTP Request7",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get present leads": {
      "main": [
        [
          {
            "node": "Filter Unique Leads",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Filter Unique Leads": {
      "main": [
        [
          {
            "node": "Add Leads to Google Sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Remove Mod Comments": {
      "main": [
        [
          {
            "node": "Hiring-related Comments",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Extract Post Metadata": {
      "main": [
        [
          {
            "node": "Seperate array into individual posts",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Extract Post Metadata1": {
      "main": [
        [
          {
            "node": "Seperate array into individual posts1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Extract Post Metadata2": {
      "main": [
        [
          {
            "node": "Seperate array into individual posts2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Extract Post Metadata3": {
      "main": [
        [
          {
            "node": "Seperate array into individual posts3",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Extract Post Metadata4": {
      "main": [
        [
          {
            "node": "Seperate array into individual posts4",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Extract Post Metadata5": {
      "main": [
        [
          {
            "node": "Seperate array into individual posts5",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Extract Post Metadata6": {
      "main": [
        [
          {
            "node": "Seperate array into individual posts6",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Extract Post Metadata7": {
      "main": [
        [
          {
            "node": "Seperate array into individual posts7",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Hiring-related Comments": {
      "main": [
        [
          {
            "node": "Get present leads",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Seperate array into individual posts": {
      "main": [
        [
          {
            "node": "Merge",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get many comments FROM multiple POSTS": {
      "main": [
        [
          {
            "node": "Remove Mod Comments",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Seperate array into individual posts1": {
      "main": [
        [
          {
            "node": "Merge",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "Seperate array into individual posts2": {
      "main": [
        [
          {
            "node": "Merge",
            "type": "main",
            "index": 2
          }
        ]
      ]
    },
    "Seperate array into individual posts3": {
      "main": [
        [
          {
            "node": "Merge",
            "type": "main",
            "index": 3
          }
        ]
      ]
    },
    "Seperate array into individual posts4": {
      "main": [
        [
          {
            "node": "Merge",
            "type": "main",
            "index": 4
          }
        ]
      ]
    },
    "Seperate array into individual posts5": {
      "main": [
        [
          {
            "node": "Merge",
            "type": "main",
            "index": 5
          }
        ]
      ]
    },
    "Seperate array into individual posts6": {
      "main": [
        [
          {
            "node": "Merge",
            "type": "main",
            "index": 6
          }
        ]
      ]
    },
    "Seperate array into individual posts7": {
      "main": [
        [
          {
            "node": "Merge",
            "type": "main",
            "index": 7
          }
        ]
      ]
    }
  }
}
Pro

For the full experience including quality scoring and batch install features for each workflow upgrade to Pro

About this workflow

Goal: Get Reddit posts from specific subreddits, filter those mentioning freelance/gigs and n8n, extract top-level comments, remove mod replies, and store everything into Google Sheets.

Source: https://n8n.io/workflows/6364/ — original creator credit. Request a take-down →

More Marketing & Ads workflows → · Browse all categories →

Related workflows

Workflows that share integrations, category, or trigger type with this one. All free to copy and import.

Marketing & Ads

Build authentic Reddit presence and generate qualified leads through AI-powered community engagement that provides genuine value without spam or promotion.

HTTP Request, Reddit
Marketing & Ads

This workflow runs on scheduled weekly and monthly triggers to generate unified marketing performance reports. It processes multiple websites by collecting analytics data, paid ads performance, and CR

Gmail, Google Sheets, Google Analytics +3
Marketing & Ads

This workflow is a comprehensive solution for digital marketers, performance agencies, and e-commerce brands looking to scale their creative testing process on Meta Ads efficiently. It eliminates the

Google Drive, HTTP Request, Google Sheets
Marketing & Ads

This automation creates a seamless daily pipeline that: Pulls yesterday's website visitors from Leadfeeder Enriches company data using Apollo.io's powerful database Delivers enriched leads to your Goo

HTTP Request, Google Sheets, Error Trigger +1
Marketing & Ads

Watch target companies for C-level and VP hiring signals, then send AI-personalized outreach emails when leadership roles are posted.

Google Sheets, @Predictleads/N8N Nodes Predictleads, Slack +2