Automated Custom Cover Letter and Resume AI Agent in N8N using Indeed API

"Head Hunter" AI Agent Workflow Setup Guide

Workflow Overview

This workflow creates a job search assistant that finds relevant positions, retrieves your professional experience, and generates tailored cover letters and resumes.

Key Tools

• job_search: Searches job listings based on criteria such as "finance jobs in Dallas" and retrieves detailed job information.
• experience: Retrieves your professional background from a vector database.
• Google Drive to Database: Automatically imports resumes into your experience database.

Setup Instructions

Initial Setup

• Download and import the workflow package into your n8n instance.
• Configure the required credentials:RapidAPI credentials for Indeed API access.Supabase credentials for the vector database. Google Drive API credentials for document monitoring.OpenAI credentials and ensure you have credits in your account.

Configuring the AI Agent

• Open the AI Agent node.
• Verify the system prompt is correctly configured to utilize both tools.
• Ensure the tools are linked to the correct workflows named "Head Hunter" and "job_search."

Setting Up Google Drive Integration

• Configure the Google Drive Trigger node to monitor your designated "resumes" folder. If you don’t have one, create it.
• Test the connection by uploading a sample resume to the monitored folder.

How It Works

job_search Tool Operation

• The AI Agent calls the job_search tool with job title and location parameters.
• Extracts search parameters from user input.
• Queries the Indeed API for relevant job listings.
• Processes job results in batches of three with two-second delays.
• Retrieves detailed information for each job listing.
• Merges all job listings into a single response object.
• Sends comprehensive job data back to the AI Agent.

experience Tool Operation

• The AI Agent calls the experience tool.
• Retrieves resume and professional background from Supabase Vector Store Database.
• Sends experience data back to the AI Agent.

Google Drive to Database Workflow

• Watches the designated Google Drive folder for new resume uploads.
• Extracts text from uploaded documents.
• Generates vector embeddings of resume content.
• Stores resume data in the vector database for future retrieval.
• Does not handle updates to the same file and will add duplicates. Ideally, you maintain one resume and upload new cover letters as needed.

Troubleshooting Tips

• If HTTP requests fail, check API rate limits and add delays between requests.
• For Supabase connection issues, verify the database schema and API keys.
• If the AI Agent doesn’t receive all job results, ensure the Merge node is correctly configured.

Optimization Recommendations

• Make sure you are using different workflow pages in N8N for each .json file
• Make sure the names are consistent of your workflow pages. If not you will need to adjust accordingly

• Set the batch size to three for job detail requests.
• Add a two-second delay between batches.
• Implement error handling for API failures.
• Add a "Wait" node between HTTP requests to respect API rate limits.

Watch the full setup guide here: https://www.youtube.com/watch?v=rxppBxZ6qxg&t=336s

Let me know if you have any trouble or need any help!