Transform your job market research with this powerful n8n workflow that automatically logs job postings from Telegram into Google Sheets and generates intelligent market trend reports using Anthropic Claude AI. What this workflow does This comprehensive automation streamlines job posting analysis through a smart Telegram bot interface. When you forward job postings to your bot, Anthropic Claude extracts structured data including company name, role, seniority level, requirements, tech stack, salary, location, domain, and key signals. The workflow automatically appends this information to your Google Sheets database with timestamp tracking. The standout feature is the on-demand reporting system. Simply send "/report" to your Telegram bot, and the workflow analyzes all logged job postings to generate a concise, Telegram-friendly market trends report. This provides instant insights into hiring patterns, salary trends, and in-demand skills across your collected data. Security is built-in with Telegram chat ID verification, ensuring only authorized users can access your job analysis system. Use cases Recruitment agencies: Track competitor job postings and market salary ranges Job seekers: Analyze market trends in your field and identify skill gaps HR professionals: Benchmark compensation and requirements against industry standards Career consultants: Generate data-driven insights for clients about job market conditions Tech professionals: Monitor demand for specific programming languages and technologies Technical details This n8n workflow leverages multiple integrations for seamless automation: Telegram Bot API: Secure message handling and report delivery Anthropic Claude: AI-powered job posting analysis and trend reporting Google Sheets: Structured data storage with automatic row appending Core n8n nodes: IF conditions, Set operations, Code execution, and Sticky Notes for workflow organization Setup requires creating a Telegram bot via @BotFather, configuring Anthropic API credentials, and preparing a Google Sheet with predefined columns for job data collection. The workflow includes comprehensive error handling and user feedback through Telegram confirmations.
