Update lead enquiry dates from sheet rows nightly

Your spreadsheet lead dates are often unformatted, leaving reps without reliable enquiry timestamps. It corrects and writes dates to lead records so reps see accurate timestamps same day.

Overview

Run this nightly job to pull daily sheet rows, normalize enquiry datetimes, and push corrected timestamps into lead records so your reps start each day with reliable context. That reduces morning prep friction and ensures follow-ups are prioritized by the next business day.