Create lead record, log row and assign task

Paid social leads arrive with inconsistent fields, leaving campaign managers without contact details. It records each lead to a master sheet and creates an intake item so owners follow up same day.