💼 Automated Internship & Job Offer Analyzer – N8N Project

Transform college placement updates into smart, structured insights with company ratings, reviews, and instant notifications.

🚀 Overview

Job Company Review is an n8n automation project designed to simplify how college students and placement coordinators process internship and job opportunity messages shared in TPO or college WhatsApp groups.

Whenever a new placement message is received, this workflow automatically:

1. Extracts and structures job information.
2. Summarizes it into an easy-to-read format.
3. Fetches company reviews and ratings from trusted web sources.
4. Stores all data in a Google Sheet for recordkeeping.
5. Sends formatted updates to a Discord and Telegram channel for instant team access.

🧠 What It Does

🔹 Intelligent Parsing

The automation listens for incoming placement messages (from TPO groups, scraped messages, or forwarded WhatsApp content) and identifies key elements like:

• Company name
• Role / Position
• Location
• Duration
• Stipend
• Deadline
• Eligibility & Requirements

🔹 Data Transformation

Using n8n’s data transformation nodes, the text is reformatted into a clean and visually consistent summary block.

⚙️ Workflow Summary

Trigger:

WhatsApp message received on placements group

Steps:

1. Extract job-related data using regex and AI parsing nodes.
2. Clean and format the data for readability.
3. Perform a company search → fetch ratings and reviews.
4. Store record in Google Sheets.
5. Send formatted embeds to Discord and Telegram.

🏢 Company Review Integration

To enhance decision-making, the workflow automatically performs a web search for the company mentioned in the offer and compiles:

• ⭐ Average rating (Trustpilot, Glassdoor, or Google Reviews)
• 🗣 Tone analysis (positive / neutral / negative mentions)
• 📊 Review count & trust indicators

This extra context helps students quickly understand whether a company has a good reputation before applying.

📋 Example Output

🧩 Tech Stack

• n8n – Workflow Automation
• Google Sheets – Data Storage
• Discord Bot – Channel Notifications
• Telegram Bot – Placement Alerts
• Google Web Search / SerpAPI – Company Review Extraction
• JavaScript Function Nodes – Text Parsing & Formatting

👨‍💻 Contributors

Developed by: Vansh Agarwal and Atharva Kolekar