• Home

  • Automation with Zapier

  • Zapier tutorials

Zapier tutorials

5 min read

How to create Google Calendar events from a Google Sheets spreadsheet

By Krystina Martinez · October 3, 2024
The Google Sheets and Google Calendar logos

It's a pain to create calendar events in bulk, but for things such as event planning or tracking your team's out-of-office time, it's a job that has to be done.

You can save yourself time by using Zapier to automatically create Google Calendar events from a Google Sheet. This is especially handy when you need to add events to Google Calendar in bulk or teammates are adding events to your calendar or a shared one.

With a single Zap—what we call Zapier's automated workflows—you can automatically create Google Calendar events whenever a new row is added to a Google Sheet.

We'll walk you through how to automatically create Google Calendar events from Google Sheets with a Zap—our word for an automated workflow. Click the button below, and follow along with the steps to set it up.

Generate Google Calendar events from new Google Sheets rows

Generate Google Calendar events from new Google Sheets rows
  • Google Sheets logo
  • Google Calendar logo
Google Sheets + Google Calendar

Here's how to set it up:

  1. Create your spreadsheet in Google Sheets (and make sure to sign up for Zapier if you haven't already). 

  2. Connect your Google Sheets account and customize your trigger.

  3. Connect your Google Calendar account and customize your calendar event.

  4. Test your Zap and begin using it.

Zapier is a no-code automation tool that lets you connect your apps into automated workflows, so that every person and every business can move forward at growth speed. Learn more about how it works.

Before you begin

If you don't have a spreadsheet already created, make one in Google Sheets and be sure to label your columns. This will be important when you set up your Zap. Be sure to have separate columns for the Start date & time and the End date & time. Populate your spreadsheet with a few rows of information if it's empty—you'll use that data in Zapier to test your Zap. 

If you don't have real information to use, you can enter a sample submission using information you will easily recognize. For example, instead of typing in random characters, use fictional characters so you don't confuse your test with a real submission. For our example, we're going to be collecting time off requests to create a shared calendar of our team members' time out of the office.

Connect Google Sheets

Click on the button above to get started, which will take you directly to the Zap editor. This is where you create and customize your automated workflows.

You'll need a Zapier account to use the workflows in this piece. If you don't have an account yet, it's free to get started.

First, set up your trigger step—the event that starts your Zap. Search for and select Google Sheets for your trigger app and New spreadsheet row for your trigger event. If you're using the Zap template, these will be selected for you. Next, sign in with your Google Sheets account, if you haven’t already, then click Continue.

A trigger step in the Zap editor with Google Sheets selected for the trigger app and New Spreadsheet Row selected for the trigger event.

For each app you connect, Zapier will ask for a general set of permissions which allows you to be flexible with your Zaps. The only actions Zapier takes on your app accounts are those a given Zap needs to accomplish what you've set up.

Customize your trigger

Next, you need to tell Zapier which spreadsheet and worksheet, if applicable, you want to trigger your Zap. 

Under the Spreadsheet field, click on the dropdown to select your Google Sheets file. Then, click on the dropdown under the Worksheet field to select a specific Worksheet. If you don't have multiple worksheets within a single file, it will usually be Sheet1.

Alt text: A screenshot of the Google Sheets step in the Zap editor. The dropdown menu under the Worksheet field only shows one sheet.

Click Continue.

Test your trigger

Now it's time to test our trigger. Zapier will find an existing row from your Google Sheet to use as sample data. This information will be used in later steps to finish building the rest of our Zap. Click the Test trigger button

A screenshot of sample Google sheet information in the Zap editor. Information matching the row from our spreadsheet is shown..

If your test information looks correct, click Continue with selected record. If something doesn't look right, or if Zapier can't find a row in your sheet, go back to the previous step and double-check that everything is correct.

Connect and customize Google Calendar 

Next, we'll customize the action step. An action is an event a Zap performs after it is triggered.

We'll use Google Calendar for our action app and Create Detailed Calendar Event as our action event, which will be selected for you if you're using the Zap template. Then, connect your Google Calendar account, if you haven’t already, and click Continue.

A screenshot of the action step in the Zap editor. Google Calendar is selected as the app and Create Detailed Event is selected as the action event.

Customize your calendar event

Next, we'll customize how we want our Google Calendar event to appear. 

Click on the dropdown under Calendar to select the specific calendar you want Zapier to create an event in. For example, if you have a team calendar separate from your personal calendar.

The Summary field is the main calendar text that appears in any Google Calendar event. Click on Enter text or insert data. If you'd like to use row information from your Google Sheet, select a Google Sheet field from the dropdown menu. You can also type in text, which will appear the same every time your Zap runs.

In this example, we're going to use both the name from our Google Sheet and some text to indicate that this calendar event represents an employee's vacation time.

A GIF illustrating how to add text and map fields from Google Sheets in Zapier. Fields from your spreadsheet appear in a dropdown menu so that you can choose which ones to feature as you set up your calendar event.

This process is called field mapping. When you map a piece of data—such as a contact name—what you see in the editor is a placeholder. This placeholder data will only be used by our Zap when we test it. Once the Zap is running, real data from Google Sheets (or any app you select) will be used when your Zap runs.

Learn more about field mapping in our Zapier quick-start guide.

Next, fill out the Description field with any text or Google Sheets fields you'd like. In this example, we'll just use some text.

A screenshot of text and a field from Google Sheets mapped in the Description field. It reads "OOO -" and then shows an oval shape with the Google Sheets logo and information pulled from the spreadsheet.

Under Start Date & Time, select the fields you'd like to use from your Google Sheet from the dropdown menu. You can select more than one option. Do the same for the End Date & Time field.

Note: This step is where formatting really matters—especially if you need to create calendar events that are shorter than a whole day or that start or end at really specific times. We found it easiest to list dates and times in one cell in our Google Sheet—e.g., 10/09/2024 9:00—rather than listing dates and times in separate cells.

A screenshare of field mapping multiple Google Sheets options in one field. This example shows selecting the start date and start time.

Customize the remaining options how you like—for example, if you want custom reminders or to use a specific color for events this Zap creates on your calendar. You can also specify whether the event should show up as an all-day event by selecting Yes in the All Day field dropdown.

A field titled "All day" with yes selected.

When you're finished, click Continue.

Test your Zap and begin using it

Now it's time to test our Zap to make sure it works. When you click Test step, Zapier will create a Google Calendar event using information from our Google Sheet. 

You can skip this test if you'd like by clicking the Skip test button located at the bottom right corner. However, you should test your Zap to make sure your calendar event is created correctly.

If the test was successful, you'll see a message like this.

A successful text message in the Zap editor. The preview window shows the calendar information that was created.

Open up Google Calendar and find your calendar event to ensure it looks correct. If it's an all-day event, it'll look like this:

A Google Calendar all day event for Nicole Redbrook's OOO.

And if the event isn't an all-day event, it'll look like this:

A Google Calendar event.

Once everything is set up correctly, you're ready to begin using your Zap.

Related reading:

  • How to create Microsoft Outlook calendar events from a Google Sheet

  • Popular ways to automate Google Sheets

  • How to power up your Google apps using automation

  • How to add new Google Calendar events to a Notion database

This piece was originally published in September 2017, with previous updates by Hannah Herman. It was most recently updated in October 2024 by Khamosh Pathak.

Get productivity tips delivered straight to your inbox

We’ll email you 1-3 times per week—and never share your information.

tags

Related articles

Improve your productivity automatically. Use Zapier to get your apps working together.

Sign up
See how Zapier works
A Zap with the trigger 'When I get a new lead from Facebook,' and the action 'Notify my team in Slack'