Skip to main content

Reddit freelance job monitor with Google Sheets tracking and Telegram alerts

Workflow preview

Workflow preview
100%
Reddit freelance job monitor with Google Sheets tracking and Telegram alerts preview
Open on n8n.io
n8n Cloud
$20/month : Unlimited workflows
2500 executions/month
Try free
Bright Data
THE #1 IN WEB SCRAPING
Scrape any website without limits
Try free
HOSTINGER Hostinger Early Deal
DISCOUNT 20%
Self-hosted n8n
Unlimited workflows - from $4.99/mo
Try free
Apify
#1 hub for scraping, AI & automation
6000+ actors - $5 credits/mo
Try free

Important notice

This workflow is provided as-is. Please review and test before using in production.

1. Workflow Overview

What It Does This n8n workflow monitors Reddit for freelance job posts related to n8n and sends alerts via Telegram while logging relevant data in Google Sheets. It filters out duplicates and only ...

Best for

  • Lead Generation automation workflows
  • intermediate n8n builders looking for reusable templates

Tools used

n8n-nodes-base.scheduletrigger, n8n-nodes-base.httprequest, n8n-nodes-base.set, n8n-nodes-base.filter, n8n-nodes-base.googlesheets, n8n-nodes-base.code, n8n-nodes-base.telegram, n8n-nodes-base.splitout

Source and attribution

This workflow is cataloged by N8N Workflows and links back to its original n8n.io source page by iamvaar.

Original n8n.io source

1.1 Workflow description

Title
Reddit freelance job monitor with Google Sheets tracking and Telegram alerts
Workflow name
Reddit freelance job monitor with Google Sheets tracking and Telegram alerts

What It Does

This n8n workflow monitors Reddit for freelance job posts related to n8n and sends alerts via Telegram while logging relevant data in Google Sheets. It filters out duplicates and only stores unique, paid opportunities.

Workflow Steps

1. Schedule Trigger

Runs every 5 minutes.

2. Reddit Search

Sends a query to Reddit API for freelance-related keywords.

3. Extract Post Metadata

Parses out relevant data from Reddit response.

4. Separate Posts

Splits array into individual post items.

5. Filter Paid Jobs

Matches posts with keywords like "hiring", "paid", "job", etc.

6. Check Existing Records

Pulls already logged post IDs from Google Sheets.

7. Filter Unique Posts

Uses JavaScript to compare incoming posts with the existing ones and filters out duplicates.

8. Get UTC Date

Converts Reddit created_utc timestamp into readable format.

9. Save to Google Sheets

Appends unique posts with these fields:

  • id
  • title
  • url
  • flair
  • created_utc

10. Send Telegram Alert

Sends a formatted notification with clickable links and meta info.

Required Credentials

  • Reddit OAuth2 (application with access to search)
  • Google Sheets API (via service account)
  • Telegram Bot API (bot token, chat ID)

Google Sheet Configuration

Make sure the sheet has these columns:

  • id (used for deduplication)
  • title
  • url
  • flair
  • created_utc

> First row must be the header.

How to Set It Up

Reddit API

  1. Create a Reddit App at https://www.reddit.com/prefs/apps
  2. Set up OAuth2 credentials in n8n with correct scopes

Google Sheets

  1. Create a new Google Sheet
  2. Share with your service account email
  3. Add required columns in the first row

Telegram

  1. Create a bot via BotFather
  2. Copy the bot token
  3. Use a private chat or group, get the chat ID

Notes

  • Interval: Adjust schedule node to change frequency
  • Search Query: You can customize keywords in the Reddit API URL
  • Profanity: Clean output only; no slang or offensive words

Final Output

  • Google Sheets: A log of all new freelance Reddit posts
  • Telegram: Instant lead alerts for new job posts

1.2 Logical Blocks

This catalog entry is organized from the workflow JSON. The node-level section below shows the executable blocks available for review before importing the template.

2. Block-by-Block Analysis

Block 1 - Run Every 5 Minutes

Type / Role
n8n-nodes-base.scheduleTrigger - scheduleTrigger
Config choices
Version 1.2

Block 2 - Look for freelance requirement posts

Type / Role
n8n-nodes-base.httpRequest - httpRequest
Config choices
Version 4.2

Block 3 - Extract Post Metadata

Type / Role
n8n-nodes-base.set - set
Config choices
Version 3.4

Block 4 - Make sure the requirement is paid

Type / Role
n8n-nodes-base.filter - filter
Config choices
Version 2.2

Block 5 - Get UTC of Post

Type / Role
n8n-nodes-base.set - set
Config choices
Version 3.4

Block 6 - Check present Rows

Type / Role
n8n-nodes-base.googleSheets - googleSheets
Config choices
Version 4.6

Block 7 - Filter Unique Posts

Type / Role
n8n-nodes-base.code - code
Config choices
Version 2

Block 8 - Save in sheets

Type / Role
n8n-nodes-base.googleSheets - googleSheets
Config choices
Version 4.6

Block 9 - Inform User in telegram

Type / Role
n8n-nodes-base.telegram - telegram
Config choices
Version 1.2

Block 10 - Seperate array into individual posts

Type / Role
n8n-nodes-base.splitOut - splitOut
Config choices
Version 1

Block 11 - Sticky Note

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

3. Summary Table

Workflow Reddit freelance job monitor with Google Sheets tracking and Telegram alerts
Complexity intermediate
Nodes 11
Categories Lead Generation
Author iamvaar
Published 17 Jul 2025

4. Reproducing the Workflow from Scratch

  1. 1. Download the workflow JSON

    Use the JSON export at /data/workflows/6079/6079.json as the source template for this automation.

  2. 2. Import the template into n8n

    Open n8n, import the downloaded JSON, and review each node before activating the workflow.

  3. 3. Configure credentials and variables

    Replace placeholder credentials, API keys, webhook URLs, account IDs, and environment-specific values with your own settings.

  4. 4. Test with sample data

    Run the workflow manually or in a staging workspace, inspect node output, and confirm downstream systems receive the expected data.

  5. 5. Activate and monitor

    Enable the workflow only after testing, then monitor executions, errors, and rate limits during the first production runs.

5. General Notes & Resources

Review imported nodes carefully before activation. This catalog entry is intended to help you inspect the workflow structure, understand required services, and find related templates faster.

Node names, credentials, schedules, webhook paths, and external service limits may need adjustment for your workspace.

Download workflow JSON Original n8n.io source Lead Generation workflows

Frequently asked questions

What does Reddit freelance job monitor with Google Sheets tracking and Telegram alerts do?

What It Does This n8n workflow monitors Reddit for freelance job posts related to n8n and sends alerts via Telegram while logging relevant data in Google Sheets. It filters out duplicates and only ...

What do I need before importing this workflow?

Review the workflow JSON, configure any required credentials in n8n, and test the automation in a safe workspace before using it in production.

Can I customize this workflow?

Yes. Use the block-by-block analysis and the downloadable JSON to inspect each node, then adjust credentials, prompts, schedules, filters, or destinations for your Lead Generation use case.