Google Forms event registration to Google Calendar and Gmail

Build me an agent that automatically confirms event registrations from a Google Form. Trigger on a new Google Forms response (poll for new submissions). The form is for a workshop, webinar, office hours session, or class signup.

When a new response comes in, the agent should do this end to end:

1) Read the response. Use Google Forms Get Response (or List Responses if working from a batch) to pull the new submission, and use Get Form once to map question IDs to human-readable fields. At minimum extract: attendee name, attendee email, the session or date they picked (if the form offers a choice), and any free-text notes like dietary needs, accessibility requirements, or a question for the host.

2) If the response is missing a valid email address, skip it, log a short reason, and stop. Never create an invite or send mail without an email.

3) Book them on Google Calendar. If the form pinned a specific session, use Google Calendar List Events to find the matching event on the right calendar by title and start time. If it exists, use Patch Event to add the attendee to the guests array (do not wipe existing guests). If it does not exist yet, use Create Event to create it on the configured calendar with the correct title, date, time, location or meeting link, and add the attendee as the first guest. Include the form notes (dietary, accessibility, host question) in the event description so the host has full context. Make sure Google sends the calendar invite to the guest so they get a native invite they can accept.

4) Send a personalized confirmation email with Gmail Send a Message. Greet them by name. Restate the date, time, and location or meeting link for the session they chose. Reference anything specific they wrote in the form (for example: "we saw you asked about pricing for nonprofits, we'll cover it during the Q&A" or "thanks for flagging the gluten-free request, we've passed it to the host"). Include a short line on how to reschedule or cancel. Keep the tone warm and human, not robotic.

Before you start, ask me for: (a) the Google Form to watch, (b) the Google Calendar where events live, (c) the default event title pattern and duration if you need to create a new event for a session, (d) the from address and signature for the confirmation email, and (e) the link or instructions for rescheduling.

Additional information

What does this prompt do?

Watches your Google Forms registration form and runs the moment a new attendee signs up.
Adds the attendee to the right Google Calendar event so they get a native invite they can accept on any device.
Sends a warm, personalized confirmation email from Gmail with the date, time, location or meeting link, and answers to anything specific they wrote in the form.
Handles forms where attendees pick from multiple sessions, matching each signup to the right event and creating it if it does not exist yet.

What do I need to use this?

A Google account connected to Google Forms, Google Calendar, and Gmail.
An event registration form in Google Forms that collects at least name, email, and (if you offer multiple sessions) which session they want.
A Google Calendar where the event lives or where you want it created.

How can I customize it?

Adjust the tone of the confirmation email so it sounds like you, your brand, or your host.
Change which fields from the form show up in the calendar event description (dietary needs, accessibility, questions for the host).
Add a reminder or follow-up step, like a Slack ping to the host or a reminder email the day before the session.

Frequently asked questions

Do attendees get a real calendar invite they can accept?

Yes. We add them as a guest on the Google Calendar event with their email address, so Google sends them a native invite. They can accept, decline, or add it to their own calendar in one click.

What happens if my form lets people choose between multiple sessions?

The agent reads the session they picked, finds the matching event on your calendar, and adds them as a guest. If the event does not exist yet, it creates a new one for that session and starts the guest list.

What if someone submits the form without an email address?

The agent skips that response and logs why, so you can follow up by hand. We never send a confirmation or create an invite without a valid email.

Will the confirmation email feel personal or generic?

Personal. The agent greets them by name, restates the session details they chose, and references things they wrote in the form, like a specific question or accessibility need, so the email reads like you wrote it yourself.

Can I use this for webinars, workshops, office hours, or classes?

Yes. Any Google Forms signup where you want a calendar invite and a confirmation email works. Webinars, workshops, office hours, classes, demos, and recurring sessions are all common uses.