AutomationMart
Home/Browse/Turn your portfolio into an AI assistant with OpenAI, Claude, Pinecone and Gmail
n8n

Turn your portfolio into an AI assistant with OpenAI, Claude, Pinecone and Gmail

n8nn8n25 modulesv1.0
GmailSlackOpenAIGoogle Drive

Deploy a personal AI assistant that answers recruiter questions about your skills and projects, then automatically emails your CV as a PDF attachment when requested. Upload your portfolio documents (resume, project writeups, case studies) to a Google Drive folder — the workflow chunks them into 600-character segments, embeds them with OpenAI, and stores them in Pinecone. A webhook-powered AI Agent (Claude Sonnet 4.5) retrieves the most relevant evidence using Pinecone + Cohere reranking, detects

At a glance

Turn your portfolio into an AI assistant with OpenAI, Claude, Pinecone and Gmail is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Gmail, Slack, OpenAI, Google Drive. It's free to download. Follow the 5-step import below to go live in minutes.

Platform
n8n
Connects
Gmail, Slack, OpenAI, Google Drive
Modules
25
Price
Free
Version
v1.0
Turn your portfolio into an AI assistant with OpenAI, Claude, Pinecone and Gmail workflow diagram

About this workflow

Deploy a personal AI assistant that answers recruiter questions about your skills and projects, then automatically emails your CV as a PDF attachment when requested. Upload your portfolio documents (resume, project writeups, case studies) to a Google Drive folder — the workflow chunks them into 600-character segments, embeds them with OpenAI, and stores them in Pinecone. A webhook-powered AI Agent (Claude Sonnet 4.5) retrieves the most relevant evidence using Pinecone + Cohere reranking, detects CV requests via structured output parsing, and sends your resume file via Gmail — all without any manual intervention. How it works Ingestion pipeline: 1. Two Google Drive poll triggers fire every minute, detecting newly created or updated files in your monitored portfolio folder 2. Files are downloaded and enriched with metadata (source filename and upload timestamp) 3. The Default Data Loader extracts text from the binary file, the Recursive Character Text Splitter chunks it at 600 characters with 100-character overlap, and OpenAI text-embedding-3-small produces 1536-dimension vectors 4. Vectors are upserted into the portfolio-docs Pinecone index Chat agent pipeline: 1. A webhook at POST /webhook/portfolio-query receives { "chatInput": "...", "sessionId": "...", "email": "..." } 2. Claude Sonnet 4.5 is instructed to call the portfolioknowledge tool (a Vector Store Tool backed by Pinecone) before answering — every response is grounded in retrieved evidence 3. Cohere rerank-v3.5 reranks the top-5 Pinecone results to top-3 before they reach the LLM 4. A Structured Output Parser enforces { "answer": "...", "cvRequested": false } — the cvRequested boolean is set by the LLM when it detects recruiter intent 5. An IF node branches on cvRequested: true → download CV PDF from Drive → Gmail attachment → respond { answer, cvSent: true }; false → respond { answer, cvSent: false } immediately 6. Buffer Window Memory retains the last 10 messages per sessionId for multi-turn conversations Error handling: An Error Trigger catches any node failure and extracts errormessage, failednode, workflowname, and executionurl into a clean object — ready to forward to Slack, email, or any alerting webhook. Use cases - Job seekers & freelancers — A 24/7 recruiter-ready assistant that answers questions about your experience and sends your CV on request, even while you sleep - Portfolio websites — A backend API endpoint that powers intelligent Q&A on your personal site without building custom infrastructure - Consultants & agencies — Adapt the ingestion pipeline for a client-facing knowledge base; swap Gmail for any email or messaging node Setup Prerequisites - A Pinecone account with an index named portfolio-docs (dimension: 1536, metric: cosine, pod or serverless) - A Google Drive folder containing your portfolio documents (PDF, DOCX, or plain text) - Your CV stored as a PDF in Google Drive (note its file ID) - n8n instance with the six credentials below configured Step 1 — Configure credentials In n8n → Settings → Credentials, create one credential for each service: | Credential name | Service | |---|---| | Google Drive OAuth2 | Google Drive OAuth2 | | OpenAI API | OpenAI | | Pinecone API | Pinecone | | Anthropic API | Anthropic | | Cohere API | Cohere | | Gmail OAuth2 | Gmail OAuth2 | Step 2 — Set your Google Drive folder ID Open File Created Trigger and File Updated Trigger (do both). In the Folder to Watch field, switch to ID mode and paste your folder ID. > Find your folder ID in the Drive URL: Step 3 — Set your CV file ID Open Download CV PDF. In the File field, switch to ID mode and paste your CV file ID. > Find the file ID in: Step 4 — Personalize the system prompt Open Portfolio AI Agent and edit the system message: - Replace the generic role description with your name and specialization - Adjust the tone (formal/casual) to match how you want to present yourself - Update the call-to-action line to reference your actual contact details Step 5 — Ingest your documents Move or upload your portfolio files into the monitored Drive folder. The ingestion pipeline will trigger automatically within one minute and populate Pinecone. To verify ingestion: check your Pinecone index vector count — it should increase after each file is processed. Step 6 — Test the chat endpoint Send a POST request to your webhook URL: Expected response: To test CV delivery, include "email": "your@email.com" and ask: "Can you send me the CV?". Workflow details - Nodes: 25 functional nodes + 4 documentation sticky notes - Triggers: 4 (2 Google Drive poll triggers, 1 Webhook, 1 Error Trigger) - AI components: Claude Sonnet 4.5 (×2 — agent + retrieval), OpenAI text-embedding-3-small (×2 — ingest + retrieval), Cohere rerank-v3.5, Pinecone Vector Store (×2 — insert + retrieve), Structured Output Parser, Buffer Window Memory - Canvas layout: Three clearly labelled sections with grey sticky note backgrounds — Ingestion pipeline, AI Agent pipeline, Error Handling

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

Extract specific website data with form input, Gemini 2.5 flash and Gmail

What this workflow does This workflow creates an automated web scraper that accepts form submissions, extracts specific data from any website using AI, and emails the results back to you. Step by step: 1. Web Scraper Form Submission provides a web form interface where users submit a URL and specify what data to extract 2. Get HTML from Source URL fetches the complete HTML content from the provided website 3. HTML Extractor processes the raw HTML and extracts the body content

Free

Auto-generate Facebook posts from video insights using Dumpling AI + GPT-4o

What this workflow does This workflow automatically turns new technical video uploads into short, engaging Facebook post drafts—complete with a suggested image—and saves the results to Google Sheets for quick review or publishing. It’s designed to help you repurpose tutorial or demo videos into ready-to-use social content without any manual writing or design effort. What problem is this workflow solving? Manually writing Facebook posts for every new tutorial or product video takes time, espe

Free

🤖 Automate Lead Qualification & Multi-Channel Follow-up with AI (BANT)

How it works This workflow is your automated sales assistant, designed to intelligently qualify incoming leads and route them to the most appropriate follow-up channel. It uses the powerful BANT (Budget, Authority, Need, Timing) framework, powered by Google Gemini AI, to score leads as 'hot', 'mid', or 'cold', ensuring your sales team focuses on the most promising opportunities. Here's a step-by-step breakdown: 1. Lead Capture: A public Form Trigger collects essential lead information, including

Free

Create a new row in Google Sheets for every new lead from Facebook Lead Ads and send a message to Slack

Automatically log new Facebook Lead Ads leads in Google Sheets and notify your team via Slack. Streamline lead management and team communication effortlessly.

Free

Client nurture & testimonial auto-pilot for Gumroad with Notion and Email

Client Nurture & Testimonial Auto-Pilot (Gumroad → Notion → Email) TL;DR Every Gumroad sale becomes a gentle, on-brand experience: instant delivery 💌, a Day-3 check-in 🌷, and a Day-7 1-click testimonial ⭐ — all saved to Notion for your “Wall of Love.” Install in \15 minutes. --- Who It’s For Soft-tech creators, solopreneurs, women-led businesses, and busy homemakers who want kind, reliable automation without dev headaches. If you sell templates/courses on Gumroad and want hands-off onboarding +

Free

Index Google Drive files into a Supabase vector store with OpenAI embeddings

Full walkthrough video: Author: Cole Medin Who it's for This workflow is for developers, data engineers, and knowledge management teams who need to automatically ingest documents stored in Google Drive into a searchable vector database — supporting RAG (retrieval-augmented generation) pipelines or semantic search applications. How it works 1. One-time setup: A chat trigger runs SQL queries to create the required Postgres tables (documents, documentmetadata, documentrows) and the vector similari

Free

Manage Google Calendar via WhatsApp with GPT-4 virtual assistant

How it works • Allows users to manage their Google Calendar via WhatsApp using natural language • Handles event creation, updates, deletions, availability checks, and agenda overviews • AI agent interprets the user’s message and triggers the appropriate calendar action • Responses are sent back to the user via WhatsApp, with confirmation or schedule info Set up steps • Set up a WhatsApp Business Cloud account and configure your webhook • Connect your Google Calendar using n8n credentials • Depl

Free

Chinese translator via Line x OpenRouter (Text & Image)

This workflow template, "Chinese Translator via Line x OpenRouter (Text & Image)" is designed to provide seamless Chinese translation services directly within the LINE messaging platform. By integrating with OpenRouter.ai and advanced language models like Qwen, this workflow translates text or images containing Chinese characters into pinyin and English translations, making it an invaluable tool for language learners, travelers, and businesses operating in multilingual environments. This templat

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