Notify agent with lead details from Perspective, lookup in Google Sheets, format data, and send email via Gmail

Process new leads by triggering a notification when a lead is created in Perspective, look up agent details in Google Sheets, format the information, and send a detailed email via Gmail to ensure timely follow-up.