Help & Support
Send Feedback
Calendar Event Automator
Turn Google Form submissions into calendar events.
formapprovals.com
145,038 users
Works with
Install
Overview
Designed for use with Google Forms, the Calendar Event Automator add-on will create a new calendar event each time a form submission is received or certain conditions are met. 

Within minutes you'll be able to: 
* Create a form to capture information that is required for the calendar event
* Include routing conditions (e.g only create an event if certain conditions are met); and
* Automatically create the calendar event.

Ideal for time-off / annual leave requests. This add-on complements the Form Approvals add-on. Turn Google Form submissions into approval requests with Form Approvals, then allow Calendar Event Automator to create a calendar event once approvals are received.

By installing this add-on you are agreeing to our Terms of Service & Privacy Policy: https://calendareventautomator.com/terms/
Reviews
A User of Calendar Event Automator
October 22, 2019
Best Calendar Event Automator! Really! As a suggestion you can make an attachment column to add file into calendar event. Thanks!
Submit reply
Cancel
Daniel Rivera
August 12, 2019
Can't seem to find a way to run it manually (without waiting 1 hour or submitting a form). Also, is there a way to set the duration of an event without manually putting in an end time? Should be a way to have it automatically create 1 hour or 30 minute events.
Submit reply
Cancel
A user of Calendar Event Automator
January 21, 2020
Second this. Having it run manually or in faster intervals is really necessary during development of the system.
A User of Calendar Event Automator
June 20, 2019
Hi Developer, I realised that my event was created but disappeared from the calendar afterwards?
Submit reply
Cancel
A User of Calendar Event Automator
April 4, 2019
Good, simple, no fuss add-on
Submit reply
Cancel
A User of Calendar Event Automator
September 19, 2018
This is a great tool that we use at work to automatically put approved time off/out of office requests on our shared google calendar. Used in combination with a google form and the Form Approvals add-on allowed us to easily set up a process for employees to request time off or training, route their request to their supervisor for approval, send a copy of info to our admin if there was a cost associated with a training, AND automatically add it to our calendar. Very good stuff! I gave a presentation about this and other tools that help automate workflows with low/no cost software at my annual professional trade group.
Submit reply
Cancel
A user of Calendar Event Automator
January 16, 2019
Hi, I am using this add-on to create an event onto the calendar. Somehow I am getting a "invalid start time" error. The columns are listed below: 17/01/2019 01:31:57 Name --> Title of event 21:30 - 22:30 17/01/2019 --> Date 21:30 --> Start time 22:30 --> End time Does this add-on expect the start time in specific format?
Rene Vincent Torralba Jr.
August 10, 2018
Using it to automate sending "Approved" requests from Forms and posting to our admin calendar. You can customize the calendar entry by selecting which fields from the Sheet/Row will appear in the Event title, description, start/end date, etc. It takes some work to setup (as with most worthwhile things), but then it's on auto-mode the whole time after. So essentially, you can set it to check if a certain field equals the value you set (in my case, "Approved"), before it actually does anything. So that field can be "In Process", "Waiting", or what-not and Calendar Event Automator won't do anything. The developer, Robert, is quite responsive to support requests. Thanks for this add-on!
Submit reply
Cancel
A user of Calendar Event Automator
September 8, 2018
Thank you Vincent, glad you are finding it useful.
A User of Calendar Event Automator
April 15, 2018
Completely useless, not automated at all, you must input the event details into the addon yourself before it will show up on the calendar. Try to define fields it should AUTOMATICALLY pull from just results in it putting up an event with what you put in the fields. No user guide, no documentation, help link leads to an unrelated addon site. Don't bother with this.
Submit reply
Cancel
A user of Calendar Event Automator
September 25, 2018
Hi David, to include information from your sheet into the calendar, simply include the column name within << and >> markers. For example, if you want the email address of the user included in the event title, you would add <<Email Address>>. Note, it is case sensitive so make sure the column name is exactly as it shows in row 1 of your spreadsheet. The question mark is in the bottom left corner of the add-on. This will take you to a detailed help guide explaining how to use the add-on.
A user of Calendar Event Automator
June 18, 2018
Hi developer, I cannot find the question mark? Also the info from sheets does not go into the calendar...im using the format for columns like this <<B>> <<C>> <<D>> but that does not help to put the sheet info into the calendar. I think this is the same problem Seth is referring to.
A user of Calendar Event Automator
April 16, 2018
Thanks Seth for your passionate review. A user guide is available by clicking the question mark icon in the bottom left corner of the add-on. Support is available 24/7 if you have any questions.
Oscar Lopez
March 21, 2018
Semi-Works for what I'm trying to do but still great.
Submit reply
Cancel
1-8 of 8
Additional information
Search
Clear search
Close search
Google apps
Main menu