Automate Job Search with LinkedIn, Google Sheets & AI

This n8n workflow automates the process of finding new job postings on LinkedIn, extracting key information, enriching it with AI, and storing it in a Google Sheet for easy tracking and management. It streamlines your job search by regularly checking for new opportunities and organizing them efficiently.

What it does

This workflow performs the following steps:

1. Triggers on a Schedule: The workflow runs periodically (e.g., daily) to check for new job postings.
2. Fetches Job Postings from Google Sheets: It reads a list of LinkedIn job URLs from a specified Google Sheet.
3. Loops Through Job URLs: For each URL, it processes the job posting individually.
4. Extracts Job Posting HTML: It makes an HTTP request to the LinkedIn job URL to get the raw HTML content.
5. Extracts Relevant Information from HTML: It uses an HTML node to parse the HTML and extract specific details like job title, company, location, and description.
6. Enriches Data with AI: It sends the extracted job description to a Google Gemini Chat Model (AI Agent) to summarize the job, identify key skills, or perform other relevant data enrichment.
7. Stores Enriched Data in Google Sheets: The original job details, along with the AI-generated insights, are appended to a Google Sheet for tracking.
8. Uploads Job Description to Google Drive: It saves the full job description as a file in Google Drive.
9. Sends Email Notification: It sends an email notification (e.g., to the job seeker) with the details of the new job posting.

Prerequisites/Requirements

To use this workflow, you will need:

• n8n Instance: A running instance of n8n.
• Google Sheets Account: To store and manage job URLs and extracted job data.
• Google Drive Account: To store full job descriptions.
• Gmail Account: To send email notifications.
• Google Gemini API Key: For the AI Agent to process and enrich job descriptions.
• LinkedIn Account (Optional): While the workflow scrapes public LinkedIn pages, a LinkedIn account might be beneficial for accessing certain job details or if LinkedIn changes its public access policies.

Setup/Usage

1. Import the Workflow: Download the provided JSON and import it into your n8n instance.
2. Configure Credentials:
   • Google Sheets: Set up a Google Sheets credential to access your job tracking spreadsheet.
   • Google Drive: Set up a Google Drive credential to save job descriptions.
   • Gmail: Set up a Gmail credential for sending notifications.
   • Google Gemini Chat Model (AI Agent): Configure your Google Gemini API key.
3. Prepare Google Sheets:
   • Create a Google Sheet with a column for "LinkedIn Job URL" (or similar) where you will list the job postings you want to monitor.
   • Create another Google Sheet to store the extracted and enriched job data (e.g., columns for Job Title, Company, Location, Summary, Key Skills, Link, Drive Link).
4. Configure Nodes:
   • Schedule Trigger: Adjust the schedule to your desired frequency (e.g., once a day, every few hours).
   • Google Sheets (Read): Specify the spreadsheet and sheet name where your job URLs are listed.
   • HTTP Request: Ensure the URL is correctly configured to fetch LinkedIn job pages. You might need to adjust headers if LinkedIn blocks direct scraping.
   • HTML: Configure the CSS selectors to accurately extract job title, company, location, and description from LinkedIn job pages. This may require some inspection of LinkedIn's HTML structure.
   • AI Agent (Google Gemini Chat Model): Customize the prompt to get the desired summarization or skill extraction from the job description.
   • Google Sheets (Write): Specify the spreadsheet and sheet name where the enriched job data will be stored. Map the incoming data fields to your sheet columns.
   • Google Drive: Specify the folder where job descriptions will be saved.
   • Gmail: Configure the recipient email address, subject, and body for your job notification emails.
5. Activate the Workflow: Once configured, activate the workflow to start automating your job search!