AutomationMart
Home/Browse/AI-powered interview preparation system using local LLM for campus placements
n8n

AI-powered interview preparation system using local LLM for campus placements

n8nn8n18 modulesv1.0
GmailGoogle SheetsGemini

Overview An AI-powered, end-to-end interview preparation and mentoring automation system for campus placements. It enables placement cells to generate hyper-personalized 4-page interview preparation PDFs for shortlisted students, by combining job descriptions (JDs), candidate data, and LLMs via LangChain and Ollama. Note: This template requires self-hosted n8n to run community nodes like LangChain and Ollama. What This Workflow Does Accepts a CSV of shortlisted students and a JD via form upload

At a glance

AI-powered interview preparation system using local LLM for campus placements is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Gmail, Google Sheets, Gemini. It's free to download. Follow the 5-step import below to go live in minutes.

Platform
n8n
Connects
Gmail, Google Sheets, Gemini
Modules
18
Price
Free
Version
v1.0
AI-powered interview preparation system using local LLM for campus placements workflow diagram

About this workflow

Overview An AI-powered, end-to-end interview preparation and mentoring automation system for campus placements. It enables placement cells to generate hyper-personalized 4-page interview preparation PDFs for shortlisted students, by combining job descriptions (JDs), candidate data, and LLMs via LangChain and Ollama. Note: This template requires self-hosted n8n to run community nodes like LangChain and Ollama. What This Workflow Does Accepts a CSV of shortlisted students and a JD via form upload Analyzes student profile vs JD using Ollama LLM via LangChain Generates personalized interview preparation PDFs Sends the PDF to each student via email Logs all data in Google Sheets and prevents duplicate processing Workflow Preview 📷 Please add a workflow screenshot here showing the main nodes and flow Step-by-Step Flow 1. Form Submission CSV of shortlisted students + JD + company name is submitted via HTTP Request form trigger. 2. Data Parsing and Google Sheet Logging CSV parsed → structured rows added to Google Sheet named with company + batch. 3. Candidate Filtering Only students with N8NAgent = Not Generated are selected to avoid reprocessing. 4. AI-Powered Report Generation LangChain agent (via Ollama + Gemini Search Tool) generates a 4-page Markdown report: Page 1: Profile Summary, Skill Gap Analysis, Company Insights Page 2: 15–20 Personalized Interview Questions Page 3: 5 Group Discussion Topics + Strategy Page 4: Custom Preparation Plan + Suggested Resources 5. PDF Creation Markdown → Stylish PDF via APITemplate.io 6. Email Delivery Each student receives a personalized email with the attached report. 7. Google Sheet Status Update Marks the student’s row as “Generated” in N8NAgent column. Prerequisites Self-hosted n8n with Community Nodes enabled Local or Docker-hosted Ollama with LLaMA3.2 or equivalent model Activated LangChain and Gemini Search Tool nodes APITemplate.io API Key Connected Google Sheets account SMTP setup or Gmail node for email delivery Customization Tips Replace the LLM prompt in the LangChain node with your own tone/style Modify the PDF template on APITemplate.io to reflect your institution branding Update the email copy for formal or informal tones Add new filters (e.g., minimum CGPA, branch) for student selection

n8n

How to import this n8n workflow

  1. 1

    Download the workflow JSON file after purchase.

  2. 2

    Open n8n → click the menu → Import from File.

  3. 3

    Select the downloaded JSON and import.

  4. 4

    Set up credentials for each node that requires them.

  5. 5

    Click Execute Workflow to test, then activate.

Setup guide

Setup guide included

Purchase to unlock the full step-by-step guide

Related N8n workflows

Create new Google Sheets row from Airtable records when triggered by a Webhook

Every time a custom webhook is triggered, Make will automatically retrieve a record from Airtable using the output of the webhook. It will validate the email from the Airtable record. If the status of the email is "valid" it will add a new row to a Google Sheet. The webhook should have a field "id" otherwise the scenario will not be triggered.

Free

Create a task in Teamwork from an e-mail in Gmail, attach attachment zipped by CloudConvert

In specified intervals, Make check if there is a new e-mail in Gmail account. If so, a new task in a specified project is created in Teamwork Projects. If the e-mail contains an attachment, it is zipped by CloudConvert and uploaded at the same time as the creation of the task.

Free

Send crypto price alerts, daily digests and /price replies with CoinGecko, Telegram and Sheets

Quick overview This workflow tracks a configurable crypto watchlist using the CoinGecko API, sends Telegram alerts when price, % change, or volume-spike conditions are met (with optional RSI filtering), optionally logs triggered alerts to Google Sheets, and also provides a daily Telegram digest plus a /price command bot. How it works 1. Runs every hour on a schedule, loads your watchlist, and loops through each configured asset. 2. Fetches current price, 24h change, 24h volume, and market cap fr

Free

Move an email to a specific Gmail folder if the sender's email address is found in a Microsoft 365 Excel worksheet

In this template, Make will be looking for senders' email addresses in a Microsoft 365 Excel worksheet and if it finds a match, it will move the email to a specific Gmail folder. Your Microsoft 365 Excel worksheet has to contain headers. The template uses [this worksheet](https://1drv.ms/x/s!AjJKBs6vWrtygQ3YJnn626GROruV?e=B3LnqG).

Free

Send a new client in Harvest as a new row to Google Sheets

When a new client is created in Harvest, a new row with their credentials is added in Google Sheets.

Free

Watch new rows in Google Sheets and add them automatically to your database

Automatically sync new Google Sheets rows to your database. Monitor changes in Google Sheets and instantly update your database with new entries.

Free

Altcoin news to LinkedIn posts with DeepSeek AI & Google Sheets

Altcoin News to LinkedIn Posts with DeepSeek AI & Google Sheets Automate your daily crypto content creation and publishing using this n8n workflow. This automation fetches the latest altcoin news from an RSS feed, rewrites it into LinkedIn-style posts using DeepSeek AI, stores it in Google Sheets, and schedules it for publishing—completely hands-free. <h3🔧 Prerequisites</h3 n8n instance (cloud or self-hosted) DeepSeek AI or OpenAI API key Google account with Sheets API enabled RSS feed URL of yo

Free

Create playlists and control your Spotify player with GPT-4

This n8n template provides a powerful AI-powered chatbot that acts as your personal Spotify DJ. Simply tell the chatbot what kind of music you're in the mood for, and it will intelligently create a custom playlist, give it a fitting name, and populate it with relevant tracks directly in your Spotify account. The workflow is built to be flexible, allowing you to easily change the underlying AI model to your preferred provider, making it a versatile starting point for any AI-driven project. W

Free

Reviews

No reviews yet

Be the first to buy and share your experience.

Leave a review

Sign in to share your experience with this workflow.

Log in to review
Free
No ratings yet

Create a free account to purchase workflows.

  • JSON blueprint — instant download
  • Setup guide PDF included
  • 5 downloads · valid 30 days
  • Works with n8n

Need help setting this up?

Book a 3-hour live setup session with an Agility consultant.

₹2,499/ session
3 hrs · video call
  • Configure live on Google Meet / Zoom
  • Free follow-up if workflow has defects
  • Platform expert assigned to you
Book installation session
Free