LinkedIn Job Monitor: Smart Filtering + Google Sheets + Telegram/WhatsApp Alerts

Description

Automated LinkedIn Job Monitoring with AI Filtering, Google Sheets & Telegram Alerts

📋 Description

Automates LinkedIn job searches across multiple countries and categories, filters results with AI, stores data in Google Sheets, and sends weekly Telegram notifications. Perfect for professionals seeking opportunities in software development, web development, and digital marketing.

Workflow Process: Weekly scheduler triggers SerpAPI searches → AI processes and filters jobs → Saves to Google Sheets → Sends country-by-country analytics via Telegram/WhatsApp.

🛠️ Prerequisites

SerpAPI Account** (free 100 searches/month) - Get API key from serpapi.com
Telegram Bot Token** - Create via @BotFather
Google Sheets** - OAuth2 credentials + shareable spreadsheet
WhatsApp Business Cloud** (optional)

📋 Setup Instructions

1. Create Google Spreadsheet
Set column headers: job_title | company_name | location | salary_raw | salary_numeric | remote_status | description | application_url | date_posted | country | timestamp_added | job_id | source

2. Replace Placeholders
YOUR_SERPAPI_KEY_HERE → Your SerpAPI key
YOUR_GOOGLE_SHEET_ID_HERE → Spreadsheet ID from URL
YOUR_TELEGRAM_CHAT_ID_HERE → Your Telegram chat ID
YOUR_PHONE_NUMBER_HERE → WhatsApp number (optional)

3. Configure Search Parameters
Modify "Initialize Variables" node:
job_types: "software development,web development,digital marketing"
countries: "qatar,uae,saudi arabia"

4. Set Credentials
Add SerpAPI HTTP credentials
Configure Telegram bot credentials
Set up Google OAuth2 credentials

Column Requirements: Ensure Google Sheets has exact column names as specified above for proper data mapping.