When this happens...
Google SheetsNew Spreadsheet Row
Then do this...
Google CalendarQuick Add Event

Just because you don't have neat start and end dates doesn't mean you can't automate your scheduling. Once this Google Sheets-Google Calendar integration is set up, Zapier handle it by sending every new row you add on Google Sheets to Google Calendar. The text will then be parsed using the Quick Event function, creating a new event on your calendar from the message or text in your spreadsheet.

Note: this Zap is suitable for when you're trying to extract scheduling out of natural language. If you've already got start and end dates, use this Zap instead.

How It Works

  1. A new row is added to Google Sheets
  2. Zapier automation creates a new Google Calendar event with the Quick Add Event function

What You Need

  • Google account

Why Zapier?

Free

Get started for free—14 day trial of premium features and apps.

Easy

No coding required—automate any of 1,000+ apps in minutes.

Secure

Enterprise-level security—connect mission-critical apps.

It's easy to connect Google Calendar + Google Sheets and requires absolutely zero coding experience—the only limit is your own imagination.

When this happens...
then do this!
New Event

Triggers when an event is created.

Create Detailed Event

Create an event by defining each field.

New Event Matching Search

Triggers when an event is created that matches a search.

Quick Add Event

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

Event Start

Triggers a specified time before an event starts.

Update Event

Updates an event. Only filled fields are updated.

New or Updated Spreadsheet Row

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

Create Spreadsheet Row

Create a new row in a specific spreadsheet.

New Spreadsheet Row

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

Update Spreadsheet Row

Update a row in a specific spreadsheet.

Use our free platform to build a single Zapier integration and instantly connect your app with 1,000+ others.

Become a Zapier Integration Partner

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.

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

See Google Sheets Integrations