Loading
Loading
  • Home

  • Automation with Zapier

  • Zapier tutorials

Zapier tutorials

3 min read

How to add attendees to Google Calendar events from Google Forms

By Khamosh Pathak · October 23, 2023
Hero image of the Google Forms app logo connected to the Google Calendar app logo on a light purple background.

If you regularly schedule meetings, you know how easy it can be to let an attendee slip through the cracks, especially if you're inviting a lot of people or schedule a lot of meetings. 

With Zapier's automated workflows—called Zaps—you can automatically invite people to an existing Google Calendar event whenever trigger events happen in the other apps you use most. That means you'll no longer have to manually add new people to your event whenever someone makes a purchase in your eCommerce store, subscribes to a specific marketing list, or completes a form on your website.

In this example we'll walk through connecting a Google Form to your Google Calendar, but these same basic steps will work with almost any app where you collect event attendee info.

New to Zapier? It's workflow automation software that lets you focus on what matters. Combine user interfaces, data tables, and logic with 6,000+ apps to build and automate anything you can imagine. Sign up for free.

How to add attendees to Google Calendar events from Google Forms

Zapier lets you create automated workflows called Zaps, which send your information from one app to another. You can create your own Zap from scratch without any coding knowledge, but we also offer quick templates to get you started. 

If you'd like to start with a template, click on it below, and you'll be taken to the Zap editor. You'll need to create a Zapier account if you don't already have one. Then, follow the directions below to set up your Zap.

Add attendees to Google Calendar events for new responses in Google Forms spreadsheets

Add attendees to Google Calendar events for new responses in Google Forms spreadsheets
  • Google Forms logo
  • Google Calendar logo
Google Forms + Google Calendar

Set up your Google Forms trigger

Let's start with the trigger—the event that starts your Zap. If you're using the Zap template, this will be selected for you. Otherwise, search for and select Google Forms as the trigger app and New Form Response as the trigger event, then click Continue.

A trigger step in the Zap editor with Google Forms selected as the trigger app and New Form Response selected as the trigger event.

Then, sign in with your Google Forms account if you haven't already. Once your account is selected, click Continue.

Next, choose the form where you're gathering event attendees, and click Continue

A field to select a Google Forms form in a trigger step in the Zap editor.

Now it's time to test your trigger step. Click Test trigger, and Zapier will show you the three most recent responses to the form. If you've just created the form, we suggest you submit a sample form entry so you can properly test the Zap. 

Select a record from the list, and click Continue with selected record

A set of test data from a Google Forms response.

Now that you've successfully tested the Google Forms trigger, it's time to move on to your action step.

Set up your Google Calendar action

Now it's time to set up the action—the event your Zap will perform once it's triggered. If you're using the Zap template, these will already be selected for you. Otherwise, search for and select Google Calendar as your action app and Add Attendee/s to Event as your action event. Click Continue.

An action step in the Zap editor with Google Calendar selected as the action app and Add Attandee/s to Event selected as the action event.

Next, sign in with your Google Calendar account, if you haven't already, and click Continue.

Now, it's time to customize the action. 

First, select the appropriate calendar in the Calendar field. Next, select the event you've already created in the Event field. 

Lastly, you need to add the email address for your new event attendees to the Attendee/s field. Here, you can either choose the email address that attendees were logged into when they filled out the form (in case you don't want to create an email field in the form itself) or the email address entered in the form if you have an email field. Just click in the Attendee/s field and select the appropriate option from the dropdown

In our example, we've used the email address field from our form. 

Calendar details filled in for a Google Calendar action step in the Zap editor.

Once you're done customizing your step, click Continue.

Next, test your action step by clicking Test step. If your test is successful, you should see a new attendee added to your Google Calendar event. Here's what our updated event looked like for us.

A Google Calendar event for a weekend office mixer.

As you can see, the new guest has been added, and the invite for the calendar event will be sent to their inbox.

If everything looks right, your Zap is now ready to use. Now every time you get a new form submission, the person will be added automatically to a Google Calendar event.

Related reading:

Get productivity tips delivered straight to your inbox

We’ll email you 1-3 times per week—and never share your information.

tags

Related articles

Improve your productivity automatically. Use Zapier to get your apps working together.

Sign up
A Zap with the trigger 'When I get a new lead from Facebook,' and the action 'Notify my team in Slack'