Update author and site lookup rows for content before publish

Your new content links land in a raw sheet, causing missing author and domain matches and delayed publishing decisions. Keep author and domain tracking accurate so editors have resolved records before the next publish run.