n8n Workflow: Score n8n Community Jobs with Gemini + Sheets + Telegram

Automatically score n8n Community Jobs and alert your Telegram channel with Gemini + Google Sheets

This n8n workflow checks the n8n Community Jobs RSS feed every 15 minutes, uses Google Gemini to classify and score new posts, and sends high-quality client requests to Telegram—while logging everything to Google Sheets.

What this workflow does

• Runs on a 15-minute schedule to fetch the latest items from the n8n Community Jobs RSS feed.
• Prevents duplicates by reading previously processed post IDs from the Google Sheets seen tab and filtering out already-seen RSS items.
• Records new IDs immediately by appending them to the seen tab before scoring.
• Sends each new post to Google Gemini (Generative Language API) and requests a JSON rating including request detection, language, type, scope, a numeric score, and a one-sentence summary (batched with a 7-second interval between requests).
• Alerts on quality: if the Gemini response indicates it’s a real client request with a score of 5 or higher, the workflow sends a formatted message to a Telegram chat.
• Logs all results (including low scores and non-requests) into the Google Sheets log tab for tracking and review.

Use cases

• Find and respond faster to high-intent automation work posted to n8n Community Jobs.
• Maintain a searchable history of rated opportunities in Google Sheets for later follow-up.
• Help SaaS operators and automation engineers triage requests using Gemini scoring and Telegram notifications.

Technical details

• Nodes/stack: RSS Feed Read, Google Sheets, HTTP Request (Generative Language API), Code, IF, Telegram, and supporting nodes (e.g., Sticky Note).
• Google Sheets tabs required: seen (id, date) and log (date, score, isRequest, type, language, summary, title, link).
• Gemini output is parsed as JSON to drive the Telegram alert logic.

Get notified instantly when the n8n Community Jobs match your criteria—without duplicate processing and with complete logging for continuous improvement.