Adds a timed event to a calendar.
class CalendarApp method .createEvent()
CalendarApp is the Apps Script service.
.createEvent() is the method name you will see after a dot in your code.
What it does
Why it's used
- Book a follow-up call when a form row says schedule demo.
- Block time on the calendar from a sheet-based workflow.
Common errors
- Forgetting parentheses on createEvent. Write CalendarApp.createEvent(), not CalendarApp.createEvent or createEvent by itself.
- Skipping dots between chained calls. Each step needs a dot, like CalendarApp.createEvent().
- Adding spaces where they do not belong. Write CalendarApp.createEvent(), not CalendarApp .createEvent(), CalendarApp.createEvent (), or CalendarApp . createEvent().
- Wrong capitalization. Use CalendarApp and createEvent, not calendarapp or createevent.
Explore
Related methods
-
.createAllDayEvent()
Adds an all-day event to a calendar.
-
.getEvents()
Returns events in a calendar between two dates.
-
.getCalendarById()
Opens a calendar by its ID.
-
.getEventsForDay()
Returns all events on a specific date.
-
.getDefaultCalendar()
Returns the user's primary Google Calendar.
More Apps Script
Better Sheets tutorials
No tagged tutorials yet. Fetch Apps Script from the harvest table and this page fills automatically.
Related blog posts
Written guides about CalendarApp.createEvent().
Event Calendar Template for a Year of Events in Google Sheets
Plan a full year of club, church, venue or PTA events in a Google Sheets event calendar: one events list, a one-page year view, and quick clash checks.
Read post →Google Sheets Calendar vs Google Calendar: When to Use Each
A Google Sheets calendar shows the whole year, prints, and takes notes. Google Calendar sends reminders. Here is when to use each, and how to run both.
Read post →