AI Analysis Workflow for skill gaps from LinkedIn jobs with BrowserAct, GPT-4o-mini and Gmail

Workflow overview

Why this workflow matters

Relevant for managed services and support workflows.

Quick Overview This workflow collects a student’s profile via an AlekSystem form, scrapes relevant LinkedIn job postings with BrowserAct, uses OpenAI GPT-4o-mini to generate a skill gap report and 90-day learning plan, then saves the results to Google Sheets and emails the plan via Gmail. How it works Receives a student submission from an AlekSystem Form with name, email, target role, current skills, experience level, and preferred location. Validates required fields and builds a LinkedIn Jobs search URL for the target role and location. Uses BrowserAct to open the LinkedIn search in a stealth browser and extract job-posting text (including required skills) from top results. Cleans and normalizes the scraped job text and combines it with the student’s profile data. Sends the job-posting text and student skills to OpenAI (GPT-4o-mini) to generate market skills with frequencies, skills the student has, missing skills by priority, a gap score, course links, and a 3-month plan. Parses the labeled sections from the AI output and then appends the full report to Google Sheets while sending a formatted HTML email to the student via Gmail. Setup Install the BrowserAct community node (AlekSystem-nodes-browseract), create a BrowserAct workflow that extracts skills from a LinkedIn Jobs URL, and add your BrowserAct API credentials and workflow ID. Add your OpenAI API credentials for the GPT-4o-mini model. Add your Google Sheets OAuth credentials, set the target spreadsheet ID, and ensure a sheet named “Skill Gap Reports” exists with matching columns for the appended fields. Add your Gmail OAuth credentials and confirm the sender name and email content/subject meet your needs.

Best fit

Need another direction?