AutomationMart
Home/Browse/Send AI interview briefs from resumes with GPT-4o-mini, Google Sheets and Gmail
n8n

Send AI interview briefs from resumes with GPT-4o-mini, Google Sheets and Gmail

n8nn8n13 modulesv1.0
GmailGoogle SheetsOpenAIGoogle Drive

Quick Overview This workflow runs every 15 minutes to read candidate rows from Google Sheets, download each resume PDF from Google Drive, extract text, generate an HTML interview brief using OpenAI GPT-4o-mini, email it via Gmail to the interviewer, and mark the row as Processed to avoid duplicates. How it works 1. Runs on a schedule trigger every 15 minutes. 2. Reads all candidate rows from the “Candidates” tab in Google Sheets and processes them one at a time. 3. Skips any rows where the Statu

At a glance

Send AI interview briefs from resumes with GPT-4o-mini, Google Sheets and Gmail is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Gmail, Google Sheets, OpenAI, Google Drive. It's free to download. Follow the 5-step import below to go live in minutes.

Platform
n8n
Connects
Gmail, Google Sheets, OpenAI, Google Drive
Modules
13
Price
Free
Version
v1.0
Send AI interview briefs from resumes with GPT-4o-mini, Google Sheets and Gmail workflow diagram

About this workflow

Quick Overview This workflow runs every 15 minutes to read candidate rows from Google Sheets, download each resume PDF from Google Drive, extract text, generate an HTML interview brief using OpenAI GPT-4o-mini, email it via Gmail to the interviewer, and mark the row as Processed to avoid duplicates. How it works 1. Runs on a schedule trigger every 15 minutes. 2. Reads all candidate rows from the “Candidates” tab in Google Sheets and processes them one at a time. 3. Skips any rows where the Status column is already set to “Processed.” 4. Extracts the Google Drive file ID from the resume link, downloads the PDF, and converts it to plain text. 5. Cleans and truncates the resume text and combines it with the candidate’s name, role, and email details. 6. Sends the resume text and metadata to OpenAI (GPT-4o-mini) to generate a styled HTML interviewer brief. 7. Emails the HTML brief to the interviewer via Gmail and updates the candidate row in Google Sheets to “Processed,” then waits 5 seconds before moving to the next candidate. Setup 1. Add Google Sheets OAuth credentials and replace YOURCANDIDATESSHEETID, then create a “Candidates” sheet with columns Name, Email, Job Role, Resume Drive Link, Interviewer Email, and Status. 2. Add Google Drive OAuth credentials and ensure each resume PDF is accessible to the workflow (for example, shared so the connected account can view it). 3. Add an OpenAI API credential and keep the model set to GPT-4o-mini. 4. Add Gmail OAuth credentials and confirm the sender name and subject line meet your email requirements. 5. Adjust the schedule interval if you want the workflow to check for new candidates more or less frequently.

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

AI-powered email to Jira ticket creation with Llama 3.2

This AI-powered workflow reads emails, understands the request using an LLM, and creates structured Jira issues. Key Insights - Poll for new emails every 5 minutes; ensure Gmail/IMAP is properly configured. - AI analysis requires a reliable LLM model (e.g., Chat Model or AI Tool). Workflow Process - Trigger the workflow with the Check for New Emails Gmail Trigger node. - Fetch full email content using the Fetch Full Email Content get message node. - Analyze email content with the Analyze Emai

Free

Capture LinkedIn leads and sync them with Google Sheets, HubSpot or Salesforce

This n8n workflow automatically captures LinkedIn leads from multiple sources (new connections, post engagements), enriches the data with AI-powered scoring, eliminates duplicates, syncs to Google Sheets and your CRM (HubSpot or Salesforce), and sends instant notifications to your sales team for high-quality leads. No more manual copy-pasting or lost opportunities—every LinkedIn interaction becomes a tracked, qualified lead ready for follow-up. Benefits Zero Manual Data Entry: Eliminates tediou

Free

Extract valuable data from unstructured Google Drive files using ComPDF AI and save it as structured JSON

Extracting valuable data from unstructured documents can be challenging—especially when these files are stored in cloud platforms like Google Drive. With ComIDP on Make, you can fully automate this process without writing a single line of code. This template retrieves unstructured files from Google Drive, processes them with ComIDP to extract meaningful text or key information, and converts the results into structured JSON data. Whether you are working with contracts, reports, or other unstruct

Free

Generate images and send photos to Telegram from new articles using OpenAI and HTML text extraction

Use this template to convert new RSS feed articles to text, generate images and captions with ChatGPT, and send them to Telegram for instant sharing.

Free

AI-powered knowledge assistant using Google Sheets, OpenAI, and Supabase Vector Search

Description An intelligent conversational AI system that provides contextual responses by combining chat history, vector database knowledge retrieval, and web search capabilities. How it Works (High-level steps) Message Detection: Google Sheets trigger monitors for new user messages and filters out already-processed entries Context Preparation: Extracts user message, retrieves chat history, and formats conversation context with system prompt Knowledge Retrieval: AI agent searches vector database

Free

Generate 5-level AI explanations for different audiences from Telegram to Google Docs with GPT-4.1-mini

Description Ask any question and get five different answers instantly. Each answer is written for a different audience—from kids to business executives. Your Telegram bot delivers all five explanations in under 10 seconds and saves them to Google Docs automatically. Perfect for teachers, writers, and anyone who needs to explain things to different people. Who's It For • Educators creating multi-grade curriculum content • Content creators generating material for diverse audi

Free

LinkedIn scraping, structuring, and messaging using PhantomBuster and GPT-4

Description This template automates the end-to-end process of extracting professional data from LinkedIn and converting it into a usable format—ideal for recruiters, SDRs, marketers, and growth teams. With a few simple configurations, you’ll be able to trigger the flow, scrape profiles, and use AI to extract name, headline, company, role, industry, and more—without writing a single line of code. Key Features 🔗 Launch PhantomBuster Agent using a profile URL ⏳ Wait 45 seconds for Phanto

Free

Generate AI videos from text or images with Sora 2/Pro & GPT-5 enhancement

Harness OpenAI's Sora 2 for instant video creation from text or images using fal.ai's API—powered by GPT-5 for refined prompts that ensure cinematic quality. This template processes form submissions, intelligently routes to text-to-video (with mandatory prompt enhancement) or image-to-video modes, and polls for completion before redirecting to your generated clip. 📋 What This Template Does Users submit prompts, aspect ratios (9:16 or 16:9), models (sora-2 or pro), durations (4s, 8s, or 12s),

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