Apply to 100+ Jobs in Minutes Using AI (Indeed, LinkedIn, ZipRecruiter)

Key Concepts

• N8N: A free, open-source workflow automation tool used to connect various applications and automate tasks.
• Apify: A web scraping and data extraction platform that provides "actors" (pre-built web scrapers) for various websites, including job boards.
• OpenAI API: An application programming interface for accessing OpenAI's AI models (like GPT-3.5) for tasks such as text generation and analysis.
• Web Scraping: The automated extraction of data from websites.
• AI-Powered Job Scoring: Using AI to evaluate job listings based on predefined criteria and a candidate's resume, assigning a score (e.g., 1-10).
• AI-Powered Cover Letter Generation: Using AI to create customized cover letters for specific job applications based on the job description and the candidate's resume.
• Google Sheets Integration: Using Google Sheets as a centralized database to store scraped job data, scores, and generated cover letters.
• Workflow Automation: The process of designing and implementing automated sequences of tasks or processes.
• JSON (JavaScript Object Notation): A lightweight data-interchange format used for structuring data, often for transmitting data between a server and web application.
• Trigger: An event that initiates a workflow in N8N (e.g., a daily schedule).
• Actor: A pre-built web scraper or automation tool available on Apify.

---

Automated Job Application Workflow Overview

This video details a comprehensive, free, and automated workflow built using N8N to streamline the job application process, eliminating the need for manual searching and application across multiple job boards. The system automatically pulls job listings, scores them based on user-defined criteria, generates personalized cover letters using AI, and compiles all information into a Google Sheet database. This allows users to focus only on highly relevant jobs and apply quickly.

Setting Up the Automation Environment

1. N8N Account Setup: The first step involves signing up for a free N8N account. A new "personal" workflow is created to begin building the automation.
2. Workflow Trigger (Schedule Node): The workflow is initiated by a "Schedule" node, configured to run daily at a specific time (e.g., 8 AM). This ensures a fresh list of jobs is available each morning.
3. Apify Account Setup: A free Apify account is required for web scraping. Apify provides $5 in free credits monthly, typically sufficient to scrape around 1,000 job listings. Users can create new email accounts for additional free credits if needed.
4. OpenAI API Key Setup: An API key from platform.openai.com is necessary for AI functionalities (job scoring and cover letter generation). New OpenAI accounts often receive free tokens, but an API key can be generated under "Settings" > "API keys."

Automated Job Scraping with Apify

1. Selecting an Apify Actor: Within the Apify store, a specific "actor" (web scraper) is chosen, such as "Indeed Job Scraper PPR." The video notes that actors may change over time, but alternatives are usually available.
2. Saving the Actor: The selected actor is saved in Apify to make it accessible within N8N.
3. Integrating Apify into N8N: An "Apify" node is added to the N8N workflow.
   • Credentials: A new credential is created to connect N8N to the Apify account.
   • Actor Selection: The saved "Indeed Job Scraper PPR" actor is selected.
   • Input JSON: Job search parameters (e.g., query: "SEO", country: "US", maxItems: 10 for testing) are defined in JSON format. The input is initially set manually, then copied to the JSON view.
   • Wait for Finish: A 60-second "Wait for finish" setting is crucial. This ensures N8N waits for Apify to complete the scraping process and return results before proceeding to subsequent steps.
4. Retrieving Scraped Data (Get Dataset Items): After the "Run Actor" node, another "Apify" node, "Get Dataset Items," is added. This node retrieves the actual job data from Apify's default dataset ID, as the "Run Actor" node only provides the run status.
5. Limiter Node (for Testing): A "Limiter" node is temporarily added to restrict the number of processed jobs to one during testing. This speeds up the testing process and conserves API credits. It can be removed once the workflow is finalized.

AI-Powered Job Scoring with OpenAI

1. OpenAI Message Model Node: An "OpenAI" node (specifically a "Message Model") is used to score jobs.
   • Credentials: The previously created OpenAI API key credential is selected.
   • Model: GPT-3.5 mini is recommended for its balance of cost-effectiveness and speed.
   • Messages (System, User, Assistant):
     • System Message (Instructions): Defines the AI's role and scoring criteria. Example criteria include:
       • 4 points if the resume is an amazing fit.
       • 2 points if the resume is mostly matching.
       • 3 points if the job pays over $25/hour, $4,000/month, or $350,000/year.
       • 1 point if it's a remote position.
       • 1 point if it offers benefits.
       • 1 point if it's full-time.
     • User Message (Input): Contains the job description, salary, remote status, benefits, and crucially, the user's sample resume. This allows the AI to compare the job requirements with the candidate's qualifications.
     • Assistant Message (Output Format): Specifies the desired output format, requesting the score (out of 10) and the reasoning in JSON format (e.g., {"score": 10, "reasoning": "..."}).
2. Output Content as JSON: The OpenAI node is configured to output content as JSON to separate the score and reasoning into distinct fields.

AI-Powered Cover Letter Generation

1. Duplicating OpenAI Node: The previous OpenAI node is duplicated to create a new one for cover letter generation.
2. Updated Messages:
   • System Message (Instructions): "You're an intelligent bot perfect at creating cover letters for a job. Please take the candidate's resume and create a customized cover letter for this job."
   • User Message (Input): Includes job details (title, description, company name, location) and the user's sample resume, similar to the scoring step.
   • Assistant Message (Output Format): Simply defines the output as a "cover letter" field, where the AI will generate the full letter.

Centralized Job Database with Google Sheets

1. Google Sheets Node: A "Google Sheets" node is added to the workflow.
   • Operation: "Append or update row" is selected. This adds new jobs or updates existing ones if they've already been scraped.
   • Sheet Selection: The target Google Sheet (provided as a template in the video description) and the specific tab (e.g., "Sheet1") are chosen.
   • Column to Match On: The "Job URL" is selected as the unique identifier to prevent duplicate entries and enable updates. The job URL is chosen because it is a permanent identifier.
   • Data Mapping: Various data points from the scraped jobs, AI score, and generated cover letter are mapped to corresponding columns in the Google Sheet (e.g., Job Description, Title, Platform, Company Name, Cover Letter, Salary, City, Remote Status, Rating, Date Published, Job URL).

Scaling and Expanding the Workflow

1. Duplicating Workflows for Different Queries: To search for different job types (e.g., "Digital Marketing" instead of "SEO"), the entire N8N workflow can be duplicated, and only the query parameter in the Apify "Input JSON" needs to be changed.
2. Duplicating Workflows for Different Platforms: The process can be reiterated for other job platforms (e.g., LinkedIn, ZipRecruiter, Google Jobs, Simply Hired) by selecting different Apify actors or creating new scraping configurations for each platform.
3. Consolidated Database: The ultimate goal is to merge all scraped jobs from various platforms and queries into a single Google Sheet database. This provides a unified dashboard where users can view pre-vetted, pre-rated jobs with ready-to-use cover letters, significantly reducing manual effort and application time.

Conclusion/Main Takeaways

This automated job application workflow leverages N8N, Apify, and OpenAI to transform the tedious job search process into an efficient, personalized, and time-saving operation. By automating scraping, scoring, and cover letter generation, users can focus their valuable time on applying to the most relevant and high-value jobs, potentially saving hours daily. The system provides a centralized, intelligent database of job opportunities, making the application process significantly more strategic and less burdensome.

Additional Resources

The video creator also offers a "school community" for those interested in learning more about AI and automation, including how to apply these skills to save time, earn money, create an AI automation agency, or automate up to 80% of a business using provided blueprints and templates.