đź‘Ą Automated phone interview evaluation with Vapi, GPT-4o & Google Sheets

⚡ 1,662 views · 👥 HR & Recruitment

Description

This n8n workflow template automatically processes phone interview transcripts using AI to evaluate candidates against specific criteria and saves the results to Google Sheets. Perfect for HR departments, recruitment agencies, or any business conducting phone screenings.

What This Workflow Does

This automated workflow:

The workflow is specifically designed for driving job interviews but can be easily adapted for any position with custom evaluation criteria.

Tools & Services Used

Prerequisites

Before implementing this workflow, you’ll need:

  1. N8N Instance - Self-hosted or cloud version
  2. OpenAI API Account - For AI transcript processing
  3. Google Account - For Google Sheets integration
  4. Phone Interview System - That can send webhooks (like Vapi.ai)

Step-by-Step Setup Instructions

Step 1: Set Up OpenAI API Access

  1. Visit OpenAI’s API platform
  2. Create an account or log in
  3. Navigate to API Keys section
  4. Generate a new API key
  5. Copy and securely store your API key

Step 2: Create Your Google Sheet

Option 1: Use Our Pre-Made Template (Recommended)

  1. Copy our template: Driver Interview Results Template
  2. Click “File” → “Make a copy” to create your own version
  3. Rename it as desired
  4. Copy your new sheet’s URL - you’ll need this for the workflow

Option 2: Create From Scratch

  1. Go to Google Sheets
  2. Create a new spreadsheet
  3. Name it “Driver Interview Results” (or your preferred name)
  4. Set up the following column headers in row 1:
    • A1: name
    • B1: phone
    • C1: cityState
    • D1: qualifies
    • E1: reasoning
  5. Copy the Google Sheet URL - you’ll need this for the workflow

Step 3: Import and Configure the N8N Workflow

  1. Import the Workflow

    • Copy the workflow JSON from the template
    • In your N8N instance, go to Workflows → Import from JSON
    • Paste the JSON and import

  2. Configure OpenAI Credentials

    • Click on either “OpenAI Chat Model” node
    • Set up credentials using your OpenAI API key
    • Test the connection to ensure it works

  3. Configure Google Sheets Integration

    • Click on the “Save to Google Sheets” node
    • Set up Google Sheets OAuth2 credentials
    • Select your spreadsheet from the dropdown
    • Choose the correct sheet (usually “Sheet1”)

  4. Update the Webhook

    • Click on the “Webhook” node
    • Note the webhook URL that n8n generates
    • This URL will receive your transcript data

Step 4: Customize Evaluation Criteria

The workflow includes predefined criteria for a Massachusetts driving job. To customize for your needs:

  1. Click on the “Evaluate Candidate” node
  2. Modify the system message to include your specific requirements
  3. Update the evaluation criteria checklist
  4. Adjust the JSON output format if needed

Current Evaluation Criteria:

Step 5: Connect to Vapi.ai (Phone Interview System)

This workflow is specifically designed to work with Vapi.ai’s phone interview system. Here’s how to connect it:

Setting Up the Vapi Integration

  1. Copy Your N8N Webhook URL

    • In your n8n workflow, click on the “Webhook” node
    • Copy the webhook URL (it should look like: https://your-n8n-instance.com/webhook-test/351ffe7c-69f2-4657-b593-c848d59205c0)

  2. Configure Your Vapi Assistant

    • Log into your Vapi.ai dashboard
    • Create or edit your phone interview assistant
    • In the assistant settings, find the “Server” section
    • Set the Server URL to your n8n webhook URL
    • Set timeout to 20 seconds (as configured in the workflow)

  3. Configure Server Messages

    • In your Vapi assistant settings, enable these server messages:
      • end-of-call-report
      • transcript[transcriptType="final"]

  4. Set Up the Interview Script

    • Use the provided interview script in your Vapi assistant (found in the workflow’s system message)
    • This ensures consistent data collection for the AI evaluation

Expected Data Format from Vapi

The workflow expects Vapi to send data in this specific format:

{
  "body": {
    "message": {
      "artifact": {
        "transcript": "AI: Hi. Are you interested in driving for Bank of Transport?\nUser: Yes.\nAI: Great. Before we go further..."
      }
    }
  }
}

Vapi Configuration Checklist

Alternative Phone Systems

If you’re not using Vapi.ai, you can adapt this workflow for other phone systems by:

Step 6: Test the Workflow

  1. Test with Sample Data

    • Use the “Execute Workflow” button with test data
    • Verify that data appears correctly in your Google Sheet
    • Check that the AI evaluation logic works as expected

  2. End-to-End Testing

    • Send a test webhook with a real transcript
    • Monitor each step of the workflow
    • Confirm the final result is saved to Google Sheets

Workflow Node Breakdown

  1. Webhook - Receives transcript data from your phone system
  2. Edit Fields2 - Extracts the transcript from the incoming data
  3. Evaluate Candidate - AI analysis using GPT-4o-mini to assess qualification
  4. Convert to JSON - Ensures proper JSON formatting with structured output parser
  5. Save to Google Sheets - Automatically logs results to your spreadsheet

Customization Options

Modify Evaluation Criteria

Change Output Format

Add Additional Processing

Troubleshooting

Common Issues:

Usage Tips

Need Help with Implementation?

For professional setup, customization, or troubleshooting of this workflow, contact:

Robert - Ynteractive Solutions

Specializing in AI-powered workflow automation, business process optimization, and custom integration solutions.

đź”— Nodes Used

Google Sheets, Webhook, AI Agent, OpenAI Chat Model, Structured Output Parser

đź“Ą Import

Download workflow.json and import into n8n: Workflow menu → Import from File

📖 Importing guide · 🔑 Credential setup