Capture new form responses, log them in Google Sheets, and send confirmation email via Gmail

Capture new form responses from Wispform, log them into Google Sheets, and send a confirmation email via Gmail. This process ensures accurate data tracking and keeps users informed with case details and next steps.