Aashit Sharma This workflow corresponds to n8n.io template #4761 — we link there as the canonical source.
This workflow follows the Agent → Emailsend recipe pattern — see all workflows that pair these two integrations.
The workflow JSON
Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →
{
"meta": {
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "560190c8-819d-47f0-9dc2-6d3ae8a2307e",
"name": "Merge",
"type": "n8n-nodes-base.merge",
"position": [
220,
20
],
"parameters": {},
"typeVersion": 3.1
},
{
"id": "6ec524e2-79ea-4b78-8898-f77466983039",
"name": "Ollama Chat Model",
"type": "@n8n/n8n-nodes-langchain.lmChatOllama",
"position": [
860,
180
],
"parameters": {},
"typeVersion": 1
},
{
"id": "1ccf58c5-d386-4b6f-b783-baeb2fa0a62e",
"name": "Merge1",
"type": "n8n-nodes-base.merge",
"position": [
1660,
20
],
"parameters": {},
"typeVersion": 3.1
},
{
"id": "2286cab3-f9cc-446a-b679-8f30bc0b9d95",
"name": "Ollama Chat Model1",
"type": "@n8n/n8n-nodes-langchain.lmChatOllama",
"position": [
1140,
-100
],
"parameters": {},
"typeVersion": 1
},
{
"id": "f79fd009-809a-4402-bd02-4c917b6d96db",
"name": "Gemini Search Tool",
"type": "n8n-nodes-gemini-search.geminiSearchToolTool",
"position": [
1000,
200
],
"parameters": {},
"typeVersion": 1
},
{
"id": "d3d80933-7175-40fb-a241-1528011657aa",
"name": "Merge2",
"type": "n8n-nodes-base.merge",
"position": [
1660,
-100
],
"parameters": {},
"typeVersion": 3.1
},
{
"id": "c000c8e3-eb04-47b6-8faa-be77d67a931c",
"name": "Merge3",
"type": "n8n-nodes-base.merge",
"position": [
1900,
-20
],
"parameters": {},
"typeVersion": 3.1
},
{
"id": "780f7857-ceb9-4838-b57e-420c2025bfa6",
"name": "Parse Uploaded CSV of Candidates",
"type": "n8n-nodes-base.formTrigger",
"position": [
-420,
20
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "bd8a55e4-a326-4eb6-96a0-8ec079fa1552",
"name": "create a sheet in google spreadsheet",
"type": "n8n-nodes-base.googleSheets",
"position": [
0,
-80
],
"parameters": {},
"typeVersion": 4.6,
"alwaysOutputData": true
},
{
"id": "ada077d0-98b8-4a60-b27d-00dd07e42e4c",
"name": "extract csv data",
"type": "n8n-nodes-base.extractFromFile",
"position": [
-60,
120
],
"parameters": {},
"typeVersion": 1
},
{
"id": "8419db80-d996-4adc-bac1-92bbf3c06ac2",
"name": "Add csv data to google spreadsheet",
"type": "n8n-nodes-base.googleSheets",
"position": [
440,
0
],
"parameters": {},
"executeOnce": false,
"retryOnFail": false,
"typeVersion": 4.6,
"alwaysOutputData": false,
"waitBetweenTries": 2000
},
{
"id": "bf878d70-ef89-498f-88a4-eb7cbfd3362d",
"name": "Select first row based on selected column",
"type": "n8n-nodes-base.googleSheets",
"position": [
660,
0
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "7fc67f04-72bd-410b-a31e-001421769a9f",
"name": "Job Interview Preparation Agent",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
840,
0
],
"parameters": {},
"executeOnce": true,
"typeVersion": 2,
"alwaysOutputData": true
},
{
"id": "4cddb198-e2f9-40ab-919e-9c4e0f8e49d6",
"name": "change item name to markdown",
"type": "n8n-nodes-base.code",
"position": [
1180,
60
],
"parameters": {},
"typeVersion": 2
},
{
"id": "d1ed328c-cd29-4333-bbfe-b836db04b10d",
"name": "Create PDF files",
"type": "n8n-nodes-base.apiTemplateIo",
"position": [
1360,
20
],
"parameters": {},
"typeVersion": 1
},
{
"id": "38b1c4c0-0fc8-410c-915e-84fb74653688",
"name": "Email prompt Agent",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
860,
-220
],
"parameters": {},
"executeOnce": true,
"typeVersion": 2,
"alwaysOutputData": true
},
{
"id": "7691b5db-1ed0-47cb-9d1e-d92d71bbdc10",
"name": "Send Email with PDF",
"type": "n8n-nodes-base.emailSend",
"position": [
1600,
200
],
"parameters": {},
"typeVersion": 2.1
},
{
"id": "6e1fa2e2-c749-42ce-a50d-0780badb59c9",
"name": "Update the selected column to spreadsheet",
"type": "n8n-nodes-base.googleSheets",
"position": [
1760,
200
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "7e1dcf30-6dfc-4587-abb1-1380c7c8ac0b",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
-480,
-240
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "53d1fd01-ae33-4639-9f75-6a5e0ba92d37",
"name": "Sticky Note1",
"type": "n8n-nodes-base.stickyNote",
"position": [
800,
-240
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "45353064-233f-42d3-939c-2835b3abfb92",
"name": "Sticky Note2",
"type": "n8n-nodes-base.stickyNote",
"position": [
1480,
-240
],
"parameters": {
"content": ""
},
"typeVersion": 1
}
],
"connections": {
"Merge": {
"main": [
[
{
"node": "Add csv data to google spreadsheet",
"type": "main",
"index": 0
}
]
]
},
"Merge1": {
"main": [
[
{
"node": "Merge3",
"type": "main",
"index": 1
}
]
]
},
"Merge2": {
"main": [
[
{
"node": "Merge3",
"type": "main",
"index": 0
}
]
]
},
"Merge3": {
"main": [
[
{
"node": "Send Email with PDF",
"type": "main",
"index": 0
}
]
]
},
"Create PDF files": {
"main": [
[
{
"node": "Merge1",
"type": "main",
"index": 1
},
{
"node": "Merge2",
"type": "main",
"index": 1
}
]
]
},
"extract csv data": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 1
}
]
]
},
"Ollama Chat Model": {
"ai_languageModel": [
[
{
"node": "Job Interview Preparation Agent",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Email prompt Agent": {
"main": [
[
{
"node": "Merge1",
"type": "main",
"index": 0
},
{
"node": "Merge2",
"type": "main",
"index": 0
}
]
]
},
"Gemini Search Tool": {
"ai_tool": [
[
{
"node": "Job Interview Preparation Agent",
"type": "ai_tool",
"index": 0
}
]
]
},
"Ollama Chat Model1": {
"ai_languageModel": [
[
{
"node": "Email prompt Agent",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Send Email with PDF": {
"main": [
[
{
"node": "Update the selected column to spreadsheet",
"type": "main",
"index": 0
}
]
]
},
"change item name to markdown": {
"main": [
[
{
"node": "Create PDF files",
"type": "main",
"index": 0
}
]
]
},
"Job Interview Preparation Agent": {
"main": [
[
{
"node": "change item name to markdown",
"type": "main",
"index": 0
}
]
]
},
"Parse Uploaded CSV of Candidates": {
"main": [
[
{
"node": "extract csv data",
"type": "main",
"index": 0
},
{
"node": "create a sheet in google spreadsheet",
"type": "main",
"index": 0
}
]
]
},
"Add csv data to google spreadsheet": {
"main": [
[
{
"node": "Select first row based on selected column",
"type": "main",
"index": 0
}
]
]
},
"create a sheet in google spreadsheet": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 0
}
]
]
},
"Select first row based on selected column": {
"main": [
[
{
"node": "Job Interview Preparation Agent",
"type": "main",
"index": 0
},
{
"node": "Email prompt Agent",
"type": "main",
"index": 0
}
]
]
},
"Update the selected column to spreadsheet": {
"main": [
[
{
"node": "Select first row based on selected column",
"type": "main",
"index": 0
}
]
]
}
}
}
Pro
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
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…
Source: https://n8n.io/workflows/4761/ — original creator credit. Request a take-down →
Related workflows
Workflows that share integrations, category, or trigger type with this one. All free to copy and import.
This workflow is designed for marketers, content creators, agencies, and solo founders who want to publish long‑form posts with visuals on autopilot using n8n and AI agents.
Tool Http Request, Agent, HTTP Request +27
Streamline your recruitment process with AI-powered resume analysis that goes beyond keyword matching.
Form Trigger, Google Drive, Google Gemini Chat +7
[](https://youtu.be/-KHze-bRpqQ)
Form Trigger, Output Parser Structured, OpenAI Chat +5
This automation flow is designed to generate professional, research-backed LinkedIn posts based on a user-submitted topic and audience, enhance it with a visually aligned image prompt, and then automa
Agent, Form Trigger, HTTP Request +4
Door-to-door HVAC companies seeking automated lead capture and appointment scheduling.
Form Trigger, Google Sheets, Agent +7