Google Form Event Registration Automation

I need an automated system to handle event registrations via Google Forms.

Requirements:
- Create a Google Form for event registrations.
- Capture registrant's name and contact information.
- Automatically record submissions in a Google Sheet.
- Send confirmation emails to registrants upon submission.

Ideal Skills:
- Experience with Google Forms and Google Sheets
- Knowledge of Google Apps Script for automation
- Email integration skills

Looking forward to your bids!