How to connect Google Calendar + Google Sheets
Zapier lets you send info between Google Calendar and Google Sheets automatically—no code required.
Top companies trust Zapier to automate work and free up time
Popular Google Calendar + Google Sheets workflows
- Generate Google Calendar events from new Google Sheets rows
Generate Google Calendar events from new Google Sheets rows
- Create Google Calendar events from new Google Sheets rows
Create Google Calendar events from new Google Sheets rows
- Create new Google Sheets row from a new Google Calendar event
Create new Google Sheets row from a new Google Calendar event
- Find and update existing Google Calendar events when Google Sheets rows are added or updated
Find and update existing Google Calendar events when Google Sheets rows are added or updated
- Create new Google Calendar events for updated rows in Google Sheets
Create new Google Calendar events for updated rows in Google Sheets
- Log new Google Calendar events in Google Sheets rows
Log new Google Calendar events in Google Sheets rows
- Add tasks to Trello and Google Calendar from a Google Sheets spreadsheet
Add tasks to Trello and Google Calendar from a Google Sheets spreadsheet
- Delete Google Calendar events with new updates to Google Sheets rows
Delete Google Calendar events with new updates to Google Sheets rows
Connect your apps and automate workflows
Easy automation for busy people. Zapier moves info between your web apps automatically, so you can focus on your most important work.


Do Even More with Google Calendar + Google Sheets
With Zapier, you can do more than just connect 2 apps—you can automate entire processes from beginning to end! Here are some popular ways users make their Google Calendar + Google Sheets workflows do more for them.
Zapier users love adding Trello to their workflows
Add tasks to Trello and Google Calendar from a Google Sheets spreadsheet
Add tasks to Trello and Google Calendar from a Google Sheets spreadsheetPremiumZapier users love adding OmniFocus to their workflows
Add OmniFocus tasks and Google Calendar events from new rows in a Google Sheet
Add OmniFocus tasks and Google Calendar events from new rows in a Google SheetPremium
- New CalendarTriggers when a calendar is created.Trigger
- Event CancelledTriggers when an event is cancelled or deleted.Trigger
- Event EndedTriggers when an event ends.Trigger
- Event StartTriggers a specified time before an event starts.Trigger
- New or Updated EventTriggers when an event is created or updated (except when it's cancelled).Trigger
- New EventTriggers when an event is created.Trigger
- New Event Matching SearchTriggers when an event is created that matches a search.Trigger
- Add Attendee/s to EventInvites one or more person to an existing event.Action
- 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
Format a row in a specific spreadsheet.
Scheduled
Action
- Google Sheets
Update a row in a specific spreadsheet.
Scheduled
Action
- Google Sheets
Update one or more new rows in a specific spreadsheet (with line item support).
Scheduled
Action
- Google Sheets
Finds many matched rows (500 max.) by a column and value.
Scheduled
Action
- Google Sheets
Finds a worksheet by title.
Scheduled
Action
- Google Sheets
Returns many rows (500 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 find worksheet.
Scheduled
Action
- Google Sheets
Finds or creates a specific lookup row.
Scheduled
Action
How Google Calendar + Google Sheets Integrations Work
- Step 1: Authenticate Google Calendar and Google Sheets.30 seconds
- Step 2: Pick one of the apps as a trigger, which will kick off your automation.15 seconds
- Step 3: Choose a resulting action from the other app.15 seconds
- Step 4: Select the data you want to send from one app to the other.2 minutes
- That’s it! More time to work on other things.
Google Calendar Tutorials
Google Sheets Tutorials
Related categories
Get started for free
You can't add more hours to the day. Zapier is the next best thing.