---
title: "Bulk create Google Calendar events with optional Google Meet from a Google Sheet"
author: "Phil Bainbridge"
date: 2021-02-16T16:19:40+00:00
modified: 2021-02-16T16:19:44+00:00
canonical_url: https://pulse.appsscript.info/p/2021/02/bulk-create-google-calendar-events-with-optional-google-meet-from-a-google-sheet/
markdown_url: https://pulse.appsscript.info/p/2021/02/bulk-create-google-calendar-events-with-optional-google-meet-from-a-google-sheet.md
categories:
  - "Beginner"
  - "Calendar"
  - "Meet"
  - "Solutions"
  - "Video Tutorial"
tags:
  - "pbainbridge.co.uk"
featured_image: https://pulse.appsscript.info/files/2021/02/CreateGoogleCalendarevents.png
description: "The following Google Apps Script tool is designed to bulk create Google Calendar events with optional video conferencing (ie Google Meet). The tool is run entirely from a Google Sheet and the details of each event is added per row, from which the tool plugs in to Google Calendar and bulk creates the events for you. The outcome is the standard Calendar event item that can then be edited just like any other."
---

# Bulk create Google Calendar events with optional Google Meet from a Google Sheet

![Bulk create Google Calendar events with optional Google Meet from a Google Sheet](https://pulse.appsscript.info/files/2021/02/CreateGoogleCalendarevents.png)

> Bulk create Google Calendar events with optional video conferencing (Google Meet) all from a Google Sheet.
> [https://www.pbainbridge.co.uk/2021/02/bulk-create-google-calendar-events-with_16.html](https://www.pbainbridge.co.uk/2021/02/bulk-create-google-calendar-events-with_16.html)Google Sheet columns allow for event details to be added

Features of the tool

- Performs an initial check that you have access to the provided Calendar to create events on.
- Allows for events to be created on another Calendar that you have suitable access to (not just your own).
- Uses toast popups to inform you of the progress as each creates each event per row.
- Fast and efficient for creating a large number of events in one go.
- Will not duplicate events if re-run, so you can continue to append further if you wish.
- Provides a direct link to the created event from within the Google Sheet for easy access.
- Performs a check of any missing ‘required’ information and informs the user via a popup so they can resolve this.
- Includes ‘Log’ sheet to help output any error messages.
- Has a ‘Reset’ option in the menu bar to remove all entered data and start from scratch.
- Replicates 90%+ of the settings you can adjust when directly creating an event in Google Calendar.

Source: *[The Gift of Script: Bulk create Google Calendar events with optional Google Meet*](https://www.pbainbridge.co.uk/2021/02/bulk-create-google-calendar-events-with_16.html)

---

*Published by [Phil Bainbridge](https://pulse.appsscript.info/p/author/phillipbainbridge/) on [Pulse](https://pulse.appsscript.info/). Original article: [https://pulse.appsscript.info/p/2021/02/bulk-create-google-calendar-events-with-optional-google-meet-from-a-google-sheet/](https://pulse.appsscript.info/p/2021/02/bulk-create-google-calendar-events-with-optional-google-meet-from-a-google-sheet/)*