Create Calendar Events from Google Sheet

Automatically add events to Google Calendar whenever rows are added to a Google Sheet.

This Google Apps Script tracks meeting information that is entered into a Google Sheet. The script creates Google Calendar event for every row, and populates the invite with customizable title, description, guests, and more.

Track Sheet updates

The script tracks a Google Sheet that aggregates meeting requests. Every row in the sheet captures a single event.

Information for each event includes name, email, and company of the requester, as well as desired date, start time, and end time.

After creating a calendar event, the script adds an event ID to the sheet that can be used to track the event.

Requests
Config

Easy to use

Business users can customize the operation of the script on their own directly in the sheet. A configuration tab captures the name of the calendar to use, the default title of the event, the description of the event, and guests.

The script reads this information every time it needs to create new events.

Calendar events

The final result of the script is a new Google Calendar event. The event includes all the information from the sheet registration row and the configuration tab.

The script uses the event ID to prevent duplication of events.

Calendar
Technologies and libraries in project
Google Apps Script
GAS Triggers
Google Spreadsheet Service
Google Calendar Service

BUY THIS PRODUCT

$45

The price is a one-time fee for the purchase of a script.

  • Spreadsheet-bound Google Apps Script
  • Unlimited script use
  • Fully customizable
  • Implementation instructions
  • Free email support for 30 days
pay with stripe

More information

What do I receive after I complete the purchase? +
You will receive a link to copy the Google Sheet that contains the script, and add it to your Google Drive.
What if I need technical support? +
Please use the contact form to submit your issue. You will receive a response within 24 hours Mon-Fri 9am-5pm PT. Please note that support does not include any customizations or new features.
What if I need to customize this script? +
You have two options here: You can either customize the script on your own, or hire me to customize it for you. Please use the contact form to describe your customization needs. I'll provide you with the amount of hours you'll need to prepay, and the hourly rate.
What are the requirements for using this script? +
You need to have a Gmail account or a Google Workspace account.
What is your refund policy? +
At this time there is no refund, unless you experience a technical problem that I am unable to resolve.
Why are calendar events off by an hour or more? +
Make sure that your Google Sheet and its Apps Script are set to the same time zone as your calendar is. To set up the sheet, click File > Settings > General > Time zone. To set up the script, click on Project Settings > Time zone.
Are calendar events removed if I delete them from the sheet? +
No, the script only pushes new events to the calendar. You can either add this functionality on your own, or hire me to customize it for you. Please use the contact form to describe your customization needs. I'll provide you with the amount of hours you'll need to prepay, and the hourly rate.