Google Calendar + Google Sheets

Create new Google Sheets row from a new Google Calendar event

There may be times when you need to catalog events from your calendar, and a spreadsheet can be a great way to do that. Zapier will automatically create a new Google Sheets row for every new event you create in Google Calendar.

When this happens...
New Event
Triggers when an event is created.
TriggerInstant
automatically do this!
Create Spreadsheet Row
Create a new row in a specific spreadsheet.
ActionWrite

Try this template

Supported triggers and actions

What does this mean?

New Calendar
Triggers when a calendar is created.
Trigger
Scheduled
Event Cancelled
Triggers when an event is cancelled or deleted.
Trigger
Scheduled
Event Ended
Triggers when an event ends.
Trigger
Scheduled
Event Start
Triggers a specified time before an event starts.
Trigger
Scheduled
New or Updated Event
Triggers when an event is created or updated (except when it's cancelled).
Trigger
Instant
New Event
Triggers when an event is created.
Trigger
Instant
New Event Matching Search
Triggers when an event is created that matches a search.
Trigger
Scheduled
Add Attendee/s to Event
Invites one or more person to an existing event.
Action
Write
Google Calendar
Creates a new calendar.
Scheduled
Action
Google Calendar
Deletes an event.
Scheduled
Action
Google Calendar
Create an event by defining each field.
Scheduled
Action
Google Calendar
Create an event from a piece of text. Google parses the text for date, time, and description info.
Scheduled
Action
Google Calendar
Updates an event. Only filled fields are updated.
Scheduled
Action
Google Calendar
Finds an event in your calendar.
Scheduled
Action
Google Calendar
Finds or creates a specific event.
Scheduled
Action
Google Sheets
Triggered when a new row is added to the bottom of a spreadsheet - works best with Team Drives.
Scheduled
Trigger
Google Sheets
Triggered when a new row is added to the bottom of a spreadsheet.
Instant
Trigger
Google Sheets
Triggered when you create a new spreadsheet.
Scheduled
Trigger
Google Sheets
Triggered when a new row is added or modified in a spreadsheet - works best with Team Drives.
Scheduled
Trigger
Google Sheets
Triggered when a new row is added or modified in a spreadsheet.
Instant
Trigger
Google Sheets
Triggered when you create a new worksheet in a spreadsheet.
Scheduled
Trigger
Google Sheets
Create a new column in a specific spreadsheet.
Scheduled
Action
Google Sheets
Create a new row in a specific spreadsheet.
Scheduled
Action
Google Sheets
Create one or more new rows in a specific spreadsheet (with line item support).
Scheduled
Action
Google Sheets
Create a new worksheet by copying an existing worksheet.
Scheduled
Action
Google Sheets
Create a blank spreadsheet or duplicate an existing spreadsheet. Optionally, provide headers.
Scheduled
Action
Google Sheets
Create a blank worksheet with a title. Optionally, provide headers.
Scheduled
Action
Google Sheets
Deletes the content of a row in a specific spreadsheet. Deleted rows will appear as blank rows in your spreadsheet. Please use with caution.
Scheduled
Action
Google Sheets
Update a row in a specific spreadsheet.
Scheduled
Action
Google Sheets
Finds many matched rows (10 max.) by a column and value.
Scheduled
Action
Google Sheets
Returns many rows (20 max.) as a single JSON value and flat rows (line items).
Scheduled
Action
Google Sheets
Finds a row by a column and value. Returns the entire row if one is found.
Scheduled
Action
Google Sheets
Finds or creates a specific lookup row.
Scheduled
Action

About Google Calendar

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.

Learn more