Reddit Freelance Job Monitor with Google Sheets Tracking and Telegram Alerts

This n8n workflow automates the process of finding new freelance job postings on Reddit, tracking them in a Google Sheet, and sending instant notifications to Telegram. It helps freelancers stay on top of new opportunities without manually browsing Reddit.

What it does

1. Triggers on Schedule: The workflow runs at a predefined interval (e.g., every hour) to check for new job postings.
2. Fetches Reddit Posts: It makes an HTTP request to the Reddit API to retrieve recent posts from specified subreddits (e.g., /r/forhire, /r/freelance).
3. Processes Posts: The raw JSON response from Reddit is processed to extract relevant information like title, URL, and creation timestamp.
4. Filters for New Posts: It compares the fetched posts against a Google Sheet to identify only those that haven't been seen or processed before.
5. Adds New Posts to Google Sheets: New job postings are appended as new rows to a designated Google Sheet, creating a persistent log.
6. Sends Telegram Alerts: For each new job posting, a formatted message containing the job title and link is sent to a specified Telegram chat.

Prerequisites/Requirements

To use this workflow, you will need:

• n8n Instance: A running instance of n8n.
• Google Account: A Google account with access to Google Sheets. You'll need to create a new Google Sheets credential in n8n.
• Telegram Account: A Telegram account and a bot token. You'll need to create a new Telegram credential in n8n and know your chat ID.
• Reddit API: No explicit Reddit API key is usually required for public read-only access to subreddits, but rate limits might apply. The workflow uses a direct HTTP request.

Setup/Usage

1. Import the workflow:
   • Copy the provided JSON code.
   • In your n8n instance, click on "Workflows" in the left sidebar.
   • Click "New" and then "Import from JSON".
   • Paste the JSON and click "Import".
2. Configure Credentials:
   • Google Sheets: Locate the "Google Sheets" node. Click on "Credentials" and select or create a new Google Sheets OAuth2 credential. Ensure it has access to the spreadsheet you intend to use.
   • Telegram: Locate the "Telegram" node. Click on "Credentials" and select or create a new Telegram Bot API credential. You will need your bot token. Also, configure the Chat ID parameter in the node to the chat where you want to receive alerts.
3. Configure the Google Sheet:
   • Create a new Google Sheet in your Google Drive.
   • Note down the Spreadsheet ID from the URL (e.g., https://docs.google.com/spreadsheets/d/YOUR_SPREADSHEET_ID/edit).
   • In the "Google Sheets" node, set the Spreadsheet ID to your sheet's ID.
   • Ensure the sheet has appropriate headers if the workflow expects them (e.g., "Title", "URL", "Date").
4. Configure Reddit Subreddits and Keywords (Code Node - if applicable):
   • The "HTTP Request" node likely targets specific Reddit URLs. Review and adjust the URL to include the subreddits you want to monitor (e.g., /r/forhire+freelance).
   • If there's a "Code" node or "Filter" node, it might contain logic to filter posts by keywords or other criteria. Customize this logic to match your job search preferences.
5. Configure Schedule Trigger:
   • The "Schedule Trigger" node is set to run periodically. Adjust the interval (e.g., every 1 hour, every 30 minutes) to your preference.
6. Activate the Workflow: Once all configurations are complete, save the workflow and activate it by toggling the "Active" switch in the top right corner.

The workflow will now automatically run at the scheduled intervals, fetch Reddit posts, update your Google Sheet, and send Telegram notifications for new opportunities.