FIX: name-matched writer (row-shift immune); reset+re-applied Strong Prospects 28 cos by name (0 mismatches)

f5ee3251e8a917b56f2c2d17745ab2df8c9d1e20 · 2026-08-13 10:30:13 -0700 · Steve Abrams

Files touched

A write_by_name.py

Diff

commit f5ee3251e8a917b56f2c2d17745ab2df8c9d1e20
Author: Steve Abrams <steve@designerwallcoverings.com>
Date:   Thu Aug 13 10:30:13 2026 -0700

    FIX: name-matched writer (row-shift immune); reset+re-applied Strong Prospects 28 cos by name (0 mismatches)
---
 write_by_name.py | 60 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 60 insertions(+)

diff --git a/write_by_name.py b/write_by_name.py
new file mode 100644
index 0000000..55ffd7d
--- /dev/null
+++ b/write_by_name.py
@@ -0,0 +1,60 @@
+#!/usr/bin/env python3
+"""
+write_by_name.py <gid> <results.json>
+
+NAME-MATCHED writer — immune to row shifts. Each result item carries a "company"; the
+writer finds the CURRENT row(s) whose company-column value matches (normalized) and writes
+there. Header-driven columns. Writes to EVERY matching row (a company can span multiple
+contact rows). Only fills empty cells; LinkedIn fields become =HYPERLINK. Reports unmatched.
+"""
+import sys, os, json, re
+sys.path.insert(0, os.path.dirname(__file__))
+import lib, enrich
+
+LABELS = {"website":"Website","company_li":"LinkedIn (Company)","contact_li":"LinkedIn (Contact)",
+          "mvp":"Marketing/VP Contact","updated_email":"Updated Email (found)","why":"Why (Marketing/VP)"}
+LINK_KEYS = {"company_li","contact_li"}
+def norm(s): return re.sub(r'[^a-z0-9]','',(s or '').lower())
+
+gid=int(sys.argv[1]); results=json.load(open(sys.argv[2]))
+cfg=enrich.TABS[gid]
+tok=lib.access_token(); meta=lib.get_meta(tok)
+title={s["properties"]["sheetId"]:s["properties"]["title"] for s in meta["sheets"]}[gid]
+rows=lib.read_tab(tok,title)
+# header row: locate by finding the LinkedIn (Company) label in first 4 rows
+hr=next((i for i in range(min(4,len(rows))) for j,v in enumerate(rows[i]) if v.strip()=="LinkedIn (Company)"), cfg["header_row"])
+hdr=rows[hr]
+def hidx(label): return next((i for i in range(len(hdr)) if (hdr[i] if i<len(hdr) else "").strip()==label), None)
+col={k:hidx(v) for k,v in LABELS.items()}
+rightmost=max((i for i,v in enumerate(hdr) if v.strip()), default=0)
+newh=[]; nxt=rightmost+1
+for k,v in LABELS.items():
+    if col[k] is None: col[k]=nxt; newh.append({"row0":hr,"col0":nxt,"value":v}); nxt+=1
+if newh: lib.batch_fill(tok,gid,newh)
+cc=cfg["company"]
+def cell(r,i): return (rows[r][i] if r<len(rows) and i<len(rows[r]) else "").strip()
+
+# index company-name -> list of row0 (only data rows below header)
+byname={}
+for r in range(hr+1,len(rows)):
+    c=norm(cell(r,cc))
+    if c: byname.setdefault(c,[]).append(r)
+
+cells=[]; unmatched=[]
+for it in results:
+    key=norm(it.get("company",""))
+    targets=byname.get(key)
+    if not targets:  # loose contains-match fallback
+        targets=[r for nm,rs in byname.items() if key and (key in nm or nm in key) for r in rs]
+    if not targets:
+        unmatched.append(it.get("company","")); continue
+    for r0 in targets:
+        for k in LABELS:
+            val=(it.get(k) or "").strip()
+            if not val or cell(r0,col[k]): continue
+            if k in LINK_KEYS:
+                cells.append({"row0":r0,"col0":col[k],"value":'=HYPERLINK("%s")'%val.replace('"',""),"formula":True})
+            else:
+                cells.append({"row0":r0,"col0":col[k],"value":val})
+res=lib.batch_fill(tok,gid,cells)
+print(json.dumps({"gid":gid,"matched":len(results)-len(unmatched),"unmatched":unmatched,"cells_written":res.get("totalUpdatedCells",0)}))

← 0c99341 header-driven writer + Why(Marketing/VP) rationale column; E · back to Rentv Sheet Enrich Refine · auto-data-snapshot: 2026-08-13T10:54:53 (51 data files) — AG 5357336 →