Step 2: Connect Google Sheets

These nodes read existing jobs and append new ones to your sheet to avoid duplicates.

1. Open Retrieve Sheet Jobs and set Document ID to ={{ $('Form Submission Trigger').first().json["Link to your Google Sheet (jobs will be added here)"] }}.
2. Set Sheet Name to Jobs Tracker.
3. In Options → Data Location on Sheet, set Range to C:C and Range Definition to specifyRangeA1.
4. Open Append Jobs to Sheet and set Document ID to ={{ $('Form Submission Trigger').first().json["Link to your Google Sheet (jobs will be added here)"] }}.
5. Confirm Operation is append and the column mappings include fields like id, Score, Job Title, and Company Name.
6. Credential Required: Connect your googleSheetsOAuth2Api credentials in Append Jobs to Sheet.

Step 3: Set Up Query Building and LinkedIn Request

This section turns form inputs into API parameters and requests job listings.

1. Open Assemble Query Params and keep the JavaScript logic as-is to map the form values into API parameters and row limits.
2. In Request LinkedIn Listings, set URL to https://api.apify.com/v2/acts/BHzefUZlZRKWxkTck/run-sync-get-dataset-items and Method to POST.
3. Set JSON Body to ={{ $json }}, and enable Send Body and Send Headers.
4. In Header Parameters, set Accept to application/json and Authorization to =Bearer [CONFIGURE_YOUR_TOKEN].

Step 4: Configure Job Cleansing, Scoring, and Parallel Paths

These nodes clean the dataset, score jobs with AI, and branch into parallel enrichment and validation flows.

1. Open Cleanse Job Listings and keep the JavaScript to deduplicate, filter blacklisted companies, and remove jobs without companyUrl.
2. Ensure Cleanse Job Listings outputs to both Check For Listings and Merge Job Details in parallel.
3. Open Score Jobs with AI and set Model to gpt-4o-mini, and keep JSON Output enabled.
4. Verify the system prompt in Score Jobs with AI includes resume and preferences using expressions like {{ $('Form Submission Trigger').first().json['Your Resume'] }} and {{ $('Form Submission Trigger').first().json["Your Job Instructions/Preferences"] }}.
5. Open Filter Scored Results and keep the logic that filters by Target Relevancy Score(out of 100).
6. Confirm Verify Scored Output outputs to both Retrieve Sheet Jobs and Merge Job Details in parallel.

Step 5: Configure Merge, Validation, and Output

This path merges job details, removes existing records, validates, and appends to the sheet.

1. Open Merge Job Details and keep Mode as combine, Join Mode as enrichInput1, and Fields to Match as id.
2. Open Exclude Existing Records and keep Join Mode as keepNonMatches with Fields to Match set to id.
3. Confirm Exclude Existing Records receives input from both Retrieve Sheet Jobs and Merge Job Details.
4. In Validate New Records, keep the not-empty condition on ={{ $json }} so only valid rows proceed.
5. Ensure Validate New Records outputs to Append Jobs to Sheet.

Step 6: Test and Activate Your Workflow

Run a full test to ensure the form, API request, AI scoring, and sheet updates work end-to-end.

1. Click Execute Workflow and submit the Form Submission Trigger form with realistic job preferences and a valid Google Sheet URL.
2. Verify Request LinkedIn Listings returns items and Cleanse Job Listings outputs non-duplicate jobs.
3. Confirm Score Jobs with AI outputs JSON with id and relevancy_score, and Filter Scored Results filters by your target score.
4. Check the Google Sheet: new rows should appear in Jobs Tracker with mapped columns like Job Title, Company Name, and Score.
5. When everything looks correct, toggle the workflow to Active to enable production use.