How to send Google Form responses to Google Calendar

By Jake Marsh · Updated

To turn Google Form responses into Google Calendar events, link the form to a Google Sheet, set that response tab up in Cellendar, and on the Automate tab tick When a Google Form adds a response to this tab, create its event right away. Each new response becomes an event on the calendar you chose, using the date and time questions from the form. Google Forms has no calendar option of its own.

Before you start

  • A Google Form with a Date question, and a Time question if events have a start time.
  • The form's responses going to a Google Sheet: in the form, open Responses and click Link to Sheets.
  • Cellendar installed in that spreadsheet.

Steps

  1. Open the response spreadsheet and choose Extensions > Cellendar > Open Cellendar.
  2. On Setup, pick the Form responses tab and set the calendar for the events ("primary", or another calendar's ID).
  3. Map the columns. Point Title at a question such as "Name" or "Event name", Start date (or date + time) at the date question, Start time at the time question, and set Default length (min) for events without an end time, for example 30.
  4. Map optional columns under Show optional columns: Location, Description, or Guests pointed at the respondent's email question.
  5. Click Save setup, then Preview changes and Sync now once to create events for responses already in the sheet.
  6. Open the Automate tab, tick the Google Form option and click Save automation. Cellendar asks you to pick this spreadsheet in a Google file picker, which lets it work while the sheet is closed.

Example: appointment requests

A form asks for Name, Email, Preferred date and Preferred time. With Title mapped to Name, Start date to Preferred date, Start time to Preferred time, Default length 45 minutes and Guests to Email, a response from Priya for March 4 at 2:00 PM becomes "Priya", 2:00 to 2:45 PM on March 4, with her email on the guest list.

Guests aren't emailed an invitation unless you turn invitations on. Leave them off to keep the calendar for your own planning, or turn them on to send the invite automatically.

Things to check

  • Time zone. The form records what the respondent typed. Cellendar reads it in the time zone you chose on Setup, so pick the zone your bookings are in.
  • Double bookings. Google Forms can't hide dates that are already taken, so two people can ask for the same slot. Both become events, and you see them side by side in Calendar.
  • Edits. Changing a response row in the sheet, such as a corrected time, updates its event on the next sync.

What it costs

Each event created is one change of the trial's 100 changes or 14 days. After that Cellendar is $7.99 a month or $59 a year. More on the Cellendar page.

Cellendar

Two-way sync between Google Sheets rows and Google Calendar events $7.99 a month or $59 a year per Google account.


Questions

Can Google Forms add events to Google Calendar without an add-on?

No. Forms only saves responses. Something has to read the responses and create the events, which is what Cellendar does.

How fast does the event appear?

Cellendar's form trigger runs when the response reaches the sheet and creates the event in that run, so you don't wait for the hourly sync.

Can different answers go to different calendars?

Yes. Map the Calendar (per row) column, and each row's event goes to the calendar whose ID is in that cell. A form can fill it from a dropdown whose choices are calendar IDs.

What if someone cancels?

Type delete in the Sync column of their row and run Sync now; the event is removed.


More Cellendar guides


More Google guides