Building an n8n job tracker

// Function (multi-item)
// Output: item.json.subject, item.json.date (ISO), item.json.body_text, item.json.from.text (if available)
function clean(s=""){ return String(s).replace(/\s+/g," ").trim(); }
for (const item of items) {
  const j = item.json || {};
  const subject = clean(j.Subject || j.subject || "");
  const ms = Number(j.internalDate || 0);
  const dateIso = (isNaN(ms) || !ms) ? new Date().toISOString() : new Date(ms).toISOString();
  const body_text = clean(j.body_text || j.snippet || "");
  const fromText = clean(j.From || j.from || "");
  item.json = { ...j, subject, date: dateIso, body_text, from: { text: fromText } };
}
return items;

// Function (multi-item) — “Slim unnecessary fields”
function clean(s=""){ return String(s).replace(/\s+/g," ").trim(); }
function pickSentences(text=""){
  const sents = text.split(/(?<=[.!?])\s+/);
  const re = /(thank you|application|applied|submitted|assessment|challenge|test|game|interview|schedule|invite|availability|under review|offer|congratulations|unfortunately|not selected|reject|decline|regret)/i;
  const kept = sents.filter(x => re.test(x)).slice(0, 12).join(" ");
  return kept || text.slice(0, 2000);
}
function domainOf(fromText=""){
  const m = (fromText || "").match(/@([A-Za-z0-9.-]+\.[A-Za-z]{2,})/);
  return m ? m[1].toLowerCase() : "";
}

for (const item of items) {
  const j = item.json || {};
  const subject = clean(j.subject || "");
  const dateISO = j.date || new Date().toISOString();
  const body_text = clean(j.body_text || "");
  const body_compact = pickSentences(body_text);
  const links = (body_text.match(/https?:\/\/[^\s"'>)]+/g) || []).slice(0, 30);
  const links_str = links.join(" ");
  const from_domain = domainOf(j.from?.text || "");

  item.json = { subject, date: dateISO, body_compact, links_str, from_domain };
}
return items;

// Function (multi-item) — “Filter out non-job”
function has(re, s) { return re.test(s || ""); }

const POS_STATUS = /(application (received|submitted)|thank you for applying|under review|assessment|interview|offer|unfortunately|not selected|reject)/i;
const NEG_MARKETING = /(newsletter|digest|apply now|new jobs posted|career site|talent community|upcoming deadlines|webinar|subscribe|unsubscribe)/i;
const NEG_SECURITY  = /(security alert|2-step verification|password|authenticator|sign[- ]?in|login|account activity)/i;
const ATS_POS = /(boards\.greenhouse\.io|jobs\.lever\.co|smartrecruiters\.com|icims\.com|oraclecloud\.com|taleo|successfactors\.com|myworkday|myworkdayjobs|\.wd\d*\.)/i;

for (const item of items) {
  const j = item.json || {};
  const subject = (j.subject || "").toLowerCase();
  const body    = (j.body_compact || "").toLowerCase();
  const links   = (j.links_str || "").toLowerCase();
  const domain  = (j.from_domain || "").toLowerCase();

  let score = 0;
  if (has(POS_STATUS, subject) || has(POS_STATUS, body)) score += 3;
  if (has(ATS_POS, links) || has(ATS_POS, domain))     score += 3;
  if (has(NEG_MARKETING, subject) || has(NEG_MARKETING, body)) score -= 3;
  if (has(NEG_SECURITY, subject)  || has(NEG_SECURITY, body))  score -= 4;

  item.json.gate_is_status = score >= 2;
  item.json.gate_score = score;
}
return items;

You are an extraction engine. Output ONLY a single JSON object matching the schema.
Use empty string for unknowns. No commentary.

Schema:
{
  "company": string,
  "role": string,
  "current_status": "Applied"|"Complete Assessment"|"Interview"|"Under Review"|"Offer"|"Rejected"|"Update",
  "exact_subject_line": string,
  "date_applied": "YYYY-MM-DD"
}

subject: {{$json["subject"] || ""}}
date: {{$json["date"] || ""}}
body: {{$json["body_compact"] || ""}}
links: {{$json["links_str"] || ""}}
from_domain: {{$json["from_domain"] || ""}}

{
  "company": "Chobani",
  "role": "Manufacturing Engineering Intern",
  "current_status": "Rejected",
  "exact_subject_line": "Manufacturing Engineering Intern at Chobani",
  "date_applied": "2025-09-23"
}

// Function (multi-item) — “Finalize for Sheets (minimal)”
function parseObj(x){ try { return (typeof x === 'string') ? JSON.parse(x) : x || {}; } catch { return {}; } }
function toYMD(d){
  if (!d) return new Date().toISOString().slice(0,10);
  const t = Date.parse(d);
  return isNaN(t) ? String(d).slice(0,10) : new Date(t).toISOString().slice(0,10);
}
function clampStatus(s){
  const ok = new Set(["Applied","Complete Assessment","Interview","Under Review","Offer","Rejected","Update"]);
  if (ok.has(s)) return s;
  const l = (s||"").toLowerCase();
  if (/thank you|received|submitted/.test(l)) return "Applied";
  if (/assessment|challenge|test|game/.test(l)) return "Complete Assessment";
  if (/interview|schedule|invite|availability/.test(l)) return "Interview";
  if (/under review|in review|being reviewed/.test(l)) return "Under Review";
  if (/offer|congratulations/.test(l)) return "Offer";
  if (/unfortunately|not selected|reject|decline|regret/.test(l)) return "Rejected";
  return "Update";
}

return items.map(it => {
  // Handle agent outputs that put JSON inside a string property
  const src = it.json || {};
  const ai = parseObj(src.output ?? src.content ?? src.message?.content ?? src);
  const company = (ai.company || "").trim();
  const role = (ai.role || "").trim();
  const dateApplied = toYMD(ai.date_applied || src.date);
  const status = clampStatus((ai.current_status || "").trim());
  const subject = (ai.exact_subject_line || src.subject || "").trim();
  const tracking_key = `${company}|${role}`;

  return {
    json: {
      Company: company,
      Role: role,
      "Date Applied": dateApplied,
      "Current Status": status,
      "Last updated": new Date().toISOString(),
      "Exact subject line": subject,
      tracking_key
    }
  };
});

const key = $items(0,1,0).json.tracking_key; // current item from Finalize node (2nd input)
const rows = items[0].json; // rows from Read (1st input)
let rowNumber = -1;

// detect header
const hasHeader = Array.isArray(rows?.[0]) && rows[0][6] === 'tracking_key';

for (let i = 0; i < rows.length; i++) {
  if (hasHeader && i === 0) continue;
  if ((rows[i]?.[6] || "") === key) { rowNumber = i + 1; break; } // 1-based
}
return [{ json: { rowNumber } }];

={{ "A" + $json.rowNumber + ":F" + $json.rowNumber }}