ConditionalVisibility

new-products-promo

how-to-create-calendar-events-from-spreadsheet-tutorial-12-new

how-to-create-calendar-events-from-spreadsheet-tutorial-03-selecting-sheet

how-to-create-calendar-events-from-spreadsheet-tutorial-05-trigger-test-result

how-to-create-calendar-events-from-spreadsheet-tutorial-06-action-step

how-to-create-calendar-events-from-spreadsheet-tutorial-07-mapping-fields

how-to-create-calendar-events-from-spreadsheet-tutorial-08-set-up-event

how-to-create-calendar-events-from-spreadsheet-tutorial-09-mapping-multiple-fields

how-to-create-calendar-events-from-spreadsheet-tutorial-13-new

how-to-create-calendar-events-from-spreadsheet-tutorial-11-test-success

how-to-create-calendar-events-from-spreadsheet-tutorial-09-new

how-to-create-calendar-events-from-spreadsheet-tutorial-10-new

Zapier tutorials

zapier-tuturial-00-google-sheets-google-calendar

Google Calendar

Google Sheets

Google Calendar events keep you and your team organized and on track. But creating events on Google Calendar can be tedious when you do it repeatedly. Not to mention, manually entering dates and times can make for human error and inaccurate calendars.

How to create Google Calendar events from a Google Sheets spreadsheet

Set up your spreadsheet

In your spreadsheet, create and label columns for the event name, start date, start time, end date, and end time. Add in a few rows of information if it's empty. This will help when you test your Zap. Be sure to name your spreadsheet.

Set up your Google Sheets trigger

In Zapier, choose Google Sheets as your trigger app and select a trigger event. Then, choose your previously created spreadsheet as the source, and run a test to find sample data. If you've never used Zapier before, you'll need to create an account. You'll also need to connect your Google Sheets account.

Set up your Google Calendar action

In Zapier, choose Google Calendar as the action app and select an action event. You'll need to connect your Google Calendar account and select the calendar where you'd like the events to be created. Using sample data from your trigger test, you'll tell Zapier what information from the spreadsheet row to use in creating your calendar event.

Test your Zap

When you've finished your action setup, test your Zap. Make sure the event in Google Calendar looks the way you expect. If it doesn't, tweak your steps until it looks right. Then, turn on your Zap.

Ever need to create calendar events in bulk? Or let others easily add calendar events for you? Or perhaps you just find it easier to manage your calendar in a spreadsheet. If so, this integration makes it easy: it will create new Google Calendar events straight from new rows whenever they're added to a Google Sheet, so you don't have to worry about adding them twice.

Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.

Triggers when a new row is added to the bottom of a Google Team Drive spreadsheet.

New Spreadsheet Row (Team Drive)

Triggers when a new row is added to the bottom of a spreadsheet.

New Spreadsheet Row

Triggers when a new spreadsheet is created.

New Spreadsheet

Triggers when a new row is added or modified in a spreadsheet - works best with Team Drives.

New or Updated Spreadsheet Row (Team Drive)

Triggers when a new row is added or modified in a spreadsheet.

New or Updated Spreadsheet Row

Triggers when a worksheet is created in a spreadsheet.

New Worksheet

Find up to 500 rows based on a column and value as line items.

Lookup Spreadsheet Rows (Advanced)

Find Worksheet

Return up to 500 rows as a single JSON value or as line items.

Get Many Spreadsheet Rows (Advanced)

Find a specific spreadsheet row based on a column and value. If found, it returns the entire row. Optionally, create a new row if no match is found.

Lookup Spreadsheet Row

Finds or creates a specific find worksheet.

Find or Create Worksheet

Find or Create Row

Create a new column in a specific spreadsheet.

Create Spreadsheet Column

Create a new row in a specific spreadsheet.

Create Spreadsheet Row

Create one or more new rows in a specific spreadsheet (with line item support).

Create Multiple Spreadsheet Rows

Creates a new worksheet by copying an existing worksheet.

Copy Worksheet

Creates a new spreadsheet. Choose from a blank spreadsheet, a copy of an existing one, or one with headers.

Create Spreadsheet

Creates a new worksheet in a Google Sheet.

Create Worksheet

Permanently deletes all data in a selected row. This action cannot be undone. 

Clear Spreadsheet Row

Format Spreadsheet Row

Update Spreadsheet Row

Update one or more rows in a specific spreadsheet (with line item support).

Update Spreadsheet Row(s)

Custom Actions (Beta)

This is an advanced action which makes a raw HTTP request that includes this integration's authentication.

API Request (Beta)

Google Calendar lets you organize your schedule and share events with co-workers and friends. With Google's free online calendar, it's easy to keep track of your daily schedule.

New Calendar

Triggers when an event is cancelled or deleted.

Event Cancelled

Event Ended

Triggers when a specified amount of time before an event starts.

Event Start

Triggers when an event is created or updated (except when it's cancelled).

New or Updated Event

New Event

Triggers when an event is created that matches a search.

New Event Matching Search

Find Event

Finds a specific event by its ID in your calendar.

Retrieve Event by ID

Finds multiple events in your calendar as line items.

Find Multiple Events

Find or Create Event

Invites one or more person to an existing event.

Add Attendee(s) to Event

Create Calendar

Delete Event

Create Detailed Event

Create an event from a piece of text. Google parses the text for date, time, and description info.

Quick Add Event

Updates an event. Only filled fields are updated.

How to create Google Calendar events from a Google Sheets spreadsheet

Related articles

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