Google Calendar + Google Sheets
Find and update existing Google Calendar events when Google Sheets rows are added or updated
This Zap automatically finds existing Google Calendar events and updates them with new data that you add to a row in a specified Google Sheets spreadsheet. If the event you're looking for doesn't yet exist, it will be created. That way, if an event is changed, your calendar will automatically reflect the change with no added clicks or keystrokes.
This Zap automatically finds existing Google Calendar events and updates them with new data that you add to a row in a specified Google Sheets spreadsheet. If the event you're looking for doesn't yet exist, it will be created. That way, if an event is changed, your calendar will automatically reflect the change with no added clicks or keystrokes.
- When this happens...
New or Updated Spreadsheet RowTriggered when a new row is added or modified in a spreadsheet.
TriggerInstantThis event starts a Zap instantly. - automatically do this!
Update EventUpdates an event. Only filled fields are updated.
ActionWriteCreate a new record or update an existing record in your app.
- Free forever for core features
- 14 day trial for premium features & apps
Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNo Team Drive
SpreadsheetRequired
WorksheetRequired
Trigger Column
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Drive
SpreadsheetRequired
WorksheetRequired
Column NameRequired
Index
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TitleRequired
Spreadsheet to Copy
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Api Docs Info
HTTP MethodRequired
URLRequired
Query String Parameters
Headers
Additional Request Headers
Body
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Lookup ColumnRequired
Lookup ValueRequired
Supporting Lookup Column
Supporting Lookup Value
Search from last row
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Lookup ColumnRequired
Lookup ValueRequired
Supporting Lookup Column
Supporting Lookup Value
Search from last row
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundCalendarRequired
Time Before
Time Before (Unit)
Search Term
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planCalendarRequired
EventRequired
Attendee/sRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.CalendarRequired
EventRequired
Notify Attendees?
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.CalendarRequired
Describe EventRequired
Attendees
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.HTTP MethodRequired
URLRequired
Query String Parameters
Headers
Additional Request Headers
Body
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.CalendarRequired
Search Term
Start Time Before
End Time After
Sort Order
Summary
Description
Location
Add Conferencing?
Start Date & TimeRequired
End Date & TimeRequired
Repeat Frequency
Repeat Until
Repeat How Many Times?
All day
Color
Attendees
Visibility
Use Default Reminders?
Reminders
Minutes Before Reminders
Show me as Free or Busy
Guests Can Modify Event
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
No Team Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Drive
SpreadsheetRequired
WorksheetRequired
Trigger Column
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planDrive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
Spreadsheet Containing the Worksheet to CopyRequired
Worksheet to CopyRequired
Copy Worksheet Destination
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
Headers
Overwrite existing worksheets
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
Background Color
Text Color
Text Bold
Text Italic
Text Strikethrough
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Lookup ColumnRequired
Lookup ValueRequired
Supporting Lookup Column
Supporting Lookup Value
Search from last row
Row Count
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
ColumnsRequired
Row CountRequired
First Row
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
TitleRequired
Headers
Overwrite existing worksheets
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
New Calendar
Triggers when a calendar is created.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planCalendarRequired
Search Term
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planCalendarRequired
Expand Recurring Events
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.CalendarRequired
Search TermRequired
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNameRequired
Description
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.CalendarRequired
Summary
Description
Location
Add Conferencing?
Start Date & TimeRequired
End Date & TimeRequired
Repeat Frequency
Repeat Until
Repeat How Many Times?
All day
Color
Attendees
Visibility
Use Default Reminders?
Reminders
Minutes Before Reminders
Show me as Free or Busy
Guests Can Modify Event
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.CalendarRequired
EventRequired
Summary
Description
Location
Start Date & Time
End Date & Time
Repeat Frequency
Repeat Until
Repeat How Many Times?
All day
Color
Attendees
Visibility
Use Default Reminders?
Reminders
Minutes Before Reminders
Show me as Free or Busy
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.CalendarRequired
Search Term
Start Time Before
End Time After
Sort Order
ActionThis is an event a Zap performs.SearchFind existing data in your app
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.
About Google Sheets
Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.
Related categories
Related Zap Templates
- Generate Google Calendar events from new Google Sheets rows
- Create new Google Sheets row from a new Google Calendar event
- Log new Google Calendar events in Google Sheets rows
- Create Google Calendar events from new Google Sheets rows
- Add tasks to Trello and Google Calendar from a Google Sheets spreadsheet
- Create Google Sheets spreadsheet rows from new or updated Google Calendar events
- Create new Google Calendar events for updated rows in Google Sheets
- Create Google Sheet rows for new Google Calendar events that end
- Create Google Sheet row(s) for new Google Calendar events
- Delete Google Sheets rows when Google Calendar events are cancelled
- Create Google Sheet row(s) for new or updated Google Calendar events
- Delete Google Calendar events with new updates to Google Sheets rows
- Create new Google Calendar events from new Google Sheets rows (parsed)
- Add attendees to Google Calendar events for new rows in a Google Sheet
- Add new emails that match a Gmail search to a new row on Google Sheets
- Add OmniFocus tasks and Google Calendar events from new rows in a Google Sheet
- Create detailed Google Calendar events with new or updated rows in Google Sheets
- Create detailed Google Calendar events with new or updated Google Sheets rows in Team Drive
- Create Google Calendar events from new Google Sheets spreadsheet rows
- Create detailed Google Calendar events from new or updated Google Sheets rows in Team Drive
- Create Google Sheet rows for new cancelled Google Calendar events
- Create Google Calendar quick add events for new or updated Google Sheets (team Drive)
- Update Google Sheet rows for new event starts in Google Calendar
- Add attendees to events in Google Calendar for new or updated spreadsheet rows in Google Sheets
- Create calendars Google Calendar from new or updated spreadsheet rows in Google Sheets
- Generate calendars in Google Calendar from new Google Sheets rows
- Create calendars in Google Calendar from new Google Sheets spreadsheets
- Quick add Google Calendar events with new Google Sheets spreadsheets
- Create Google Sheets rows for new Google Calendar events.
- Create spreadsheet rows for new Google Calendar events.
- Create spreadsheet columns in Google Sheets for new or updated Google Calendar events
- Add attendees to Google Calendar events from new Google Sheets rows on team drive
- Create calendars in Google Calendar for new worksheets in Google Sheets
- Create multiple spreadsheet rows in Google Sheets for new Google Calendar event starts
- Update Google Sheets rows when Google Calendar events end
- Copy worksheets in Google Sheets for new or updated events in Google Calendar
- Update Google Sheets rows for new or updated Google Calendar events
- Create new Google Sheets spreadsheets for each Google Calendar event
- Update Google Calendar events based on new or updated Google Sheets spreadsheet rows on team drive
- Add attendees to Google Calendar events from new Google Sheets spreadsheets
- Add new Google Sheets spreadsheet rows to Google Calendar as events
- Update Google Sheets rows with new Google Calendar events matching search criteria
- Create spreadsheets in Google Sheets for new Google Calendar events
- Create worksheets in Google Sheets for new or updated Google Calendar events
- Create spreadsheets in Google Sheets for new or updated Google Calendar events
- Create Google Calendar events from new or updated Google Sheets rows on team drive
- Create worksheets in Google Sheets for new Google Calendar events
- Create columns in Google Sheets for new Google Calendar events
- Update Google Sheets rows when new Google Calendar events start
- Create detailed events in Google Calendar from new spreadsheets in Google Sheets
- Create worksheets in Google Sheets for new Google Calendar events
- Update Google Calendar events with new Google Sheets rows
- Create detailed events in Google Calendar from new worksheets in Google Sheets
- Create new worksheets in Google Sheets from new Google Calendar events
- Create Google Calendar events from new Google Sheets spreadsheet rows on team drive
- Create new Google Sheets worksheets when Google Calendar events are added
- Create new Google Sheets worksheets for new Google Calendar events
- Create spreadsheets in Google Sheets for new Google Calendar events
- Create updated Google Calendar events from new Google Sheets worksheets
- Update spreadsheet rows in Google Sheets when new calendars are created in Google Calendar
- Update Google Sheets rows for new Google Calendar events
- Update rows in Google Sheets when new matching events occur in Google Calendar
- Add attendees to Google Calendar events from new or updated rows in Google Sheets team drive
- Update spreadsheet rows in Google Sheets when new events occur in Google Calendar
- Create multiple spreadsheet rows in Google Sheets when events are cancelled in Google Calendar
- Create multiple Google Sheets rows every time an event ends in Google Calendar
- Update spreadsheet rows in Google Sheets for new or updated events in Google Calendar
- Update Google Sheets rows when events end in Google Calendar
- "update Google Sheets rows when events are cancelled in Google Calendar"
- Format new Google Calendar events into rows in Google Sheets
- Create custom actions in Google Sheets for new calendar events from Google Calendar
- Manage new Google Calendar events by initiating custom actions in Google Sheets
- Update actions in Google Sheets when events are cancelled in Google Calendar
- Create events in Google Calendar from new worksheets in Google Sheets
- Format spreadsheet rows in Google Sheets for new or updated events in Google Calendar
- Track Google Calendar event endings by creating spreadsheets in Google Sheets
- Update Google Calendar events when new rows are added in Google Sheets team drive
- Update Google Sheets rows for new Google Calendar events
- Create worksheets in Google Sheets when events end in Google Calendar
- Create copies of worksheets in Google Sheets for new events in Google Calendar
- Create spreadsheets in Google Sheets for new events matching search in Google Calendar
- Create new Google Calendar events from new rows in Google Sheets
- Copy worksheets in Google Sheets when events end in Google Calendar
- Copy worksheets in Google Sheets when events are cancelled in Google Calendar
- Create spreadsheet columns in Google Sheets for new calendars in Google Calendar
- Create spreadsheets in Google Sheets when events are cancelled in Google Calendar
- Update Google Sheets with new or updated events from Google Calendar
- Update Google Sheets with new or updated events from Google Calendar
- Create new Google Sheets columns when Google Calendar events end
- Clear Google Sheets rows when Google Calendar events end
- Create new rows in Google Sheets for every newly added Google Calendar event
- Create new Google Sheets worksheets when Google Calendar events start
Related Zap Templates
- Generate Google Calendar events from new Google Sheets rows
- Create Google Calendar events from new Google Sheets rows
- Create new Google Calendar events for updated rows in Google Sheets
- Delete Google Sheets rows when Google Calendar events are cancelled
- Create new Google Calendar events from new Google Sheets rows (parsed)
- Add OmniFocus tasks and Google Calendar events from new rows in a Google Sheet
- Create Google Calendar events from new Google Sheets spreadsheet rows
- Create Google Calendar quick add events for new or updated Google Sheets (team Drive)
- Create calendars Google Calendar from new or updated spreadsheet rows in Google Sheets
- Quick add Google Calendar events with new Google Sheets spreadsheets
- Create spreadsheet columns in Google Sheets for new or updated Google Calendar events
- Create multiple spreadsheet rows in Google Sheets for new Google Calendar event starts
- Update Google Sheets rows for new or updated Google Calendar events
- Add attendees to Google Calendar events from new Google Sheets spreadsheets
- Create spreadsheets in Google Sheets for new Google Calendar events
- Create Google Calendar events from new or updated Google Sheets rows on team drive
- Update Google Sheets rows when new Google Calendar events start
- Update Google Calendar events with new Google Sheets rows
- Create Google Calendar events from new Google Sheets spreadsheet rows on team drive
- Create spreadsheets in Google Sheets for new Google Calendar events
- Update Google Sheets rows for new Google Calendar events
- Update spreadsheet rows in Google Sheets when new events occur in Google Calendar
- Update spreadsheet rows in Google Sheets for new or updated events in Google Calendar
- Format new Google Calendar events into rows in Google Sheets
- Update actions in Google Sheets when events are cancelled in Google Calendar
- Track Google Calendar event endings by creating spreadsheets in Google Sheets
- Create worksheets in Google Sheets when events end in Google Calendar
- Create new Google Calendar events from new rows in Google Sheets
- Create spreadsheet columns in Google Sheets for new calendars in Google Calendar
- Update Google Sheets with new or updated events from Google Calendar
- Create new rows in Google Sheets for every newly added Google Calendar event
- Create new Google Sheets row from a new Google Calendar event
- Add tasks to Trello and Google Calendar from a Google Sheets spreadsheet
- Create Google Sheet rows for new Google Calendar events that end
- Create Google Sheet row(s) for new or updated Google Calendar events
- Add attendees to Google Calendar events for new rows in a Google Sheet
- Create detailed Google Calendar events with new or updated rows in Google Sheets
- Create detailed Google Calendar events from new or updated Google Sheets rows in Team Drive
- Update Google Sheet rows for new event starts in Google Calendar
- Generate calendars in Google Calendar from new Google Sheets rows
- Create Google Sheets rows for new Google Calendar events.
- Add attendees to Google Calendar events from new Google Sheets rows on team drive
- Update Google Sheets rows when Google Calendar events end
- Create new Google Sheets spreadsheets for each Google Calendar event
- Add new Google Sheets spreadsheet rows to Google Calendar as events
- Create worksheets in Google Sheets for new or updated Google Calendar events
- Create worksheets in Google Sheets for new Google Calendar events
- Create detailed events in Google Calendar from new spreadsheets in Google Sheets
- Create detailed events in Google Calendar from new worksheets in Google Sheets
- Create new Google Sheets worksheets when Google Calendar events are added
- Create updated Google Calendar events from new Google Sheets worksheets
- Update rows in Google Sheets when new matching events occur in Google Calendar
- Create multiple spreadsheet rows in Google Sheets when events are cancelled in Google Calendar
- Update Google Sheets rows when events end in Google Calendar
- Create custom actions in Google Sheets for new calendar events from Google Calendar
- Create events in Google Calendar from new worksheets in Google Sheets
- Update Google Calendar events when new rows are added in Google Sheets team drive
- Create copies of worksheets in Google Sheets for new events in Google Calendar
- Copy worksheets in Google Sheets when events end in Google Calendar
- Create spreadsheets in Google Sheets when events are cancelled in Google Calendar
- Create new Google Sheets columns when Google Calendar events end
- Create new Google Sheets worksheets when Google Calendar events start
- Log new Google Calendar events in Google Sheets rows
- Create Google Sheets spreadsheet rows from new or updated Google Calendar events
- Create Google Sheet row(s) for new Google Calendar events
- Delete Google Calendar events with new updates to Google Sheets rows
- Add new emails that match a Gmail search to a new row on Google Sheets
- Create detailed Google Calendar events with new or updated Google Sheets rows in Team Drive
- Create Google Sheet rows for new cancelled Google Calendar events
- Add attendees to events in Google Calendar for new or updated spreadsheet rows in Google Sheets
- Create calendars in Google Calendar from new Google Sheets spreadsheets
- Create spreadsheet rows for new Google Calendar events.
- Create calendars in Google Calendar for new worksheets in Google Sheets
- Copy worksheets in Google Sheets for new or updated events in Google Calendar
- Update Google Calendar events based on new or updated Google Sheets spreadsheet rows on team drive
- Update Google Sheets rows with new Google Calendar events matching search criteria
- Create spreadsheets in Google Sheets for new or updated Google Calendar events
- Create columns in Google Sheets for new Google Calendar events
- Create worksheets in Google Sheets for new Google Calendar events
- Create new worksheets in Google Sheets from new Google Calendar events
- Create new Google Sheets worksheets for new Google Calendar events
- Update spreadsheet rows in Google Sheets when new calendars are created in Google Calendar
- Add attendees to Google Calendar events from new or updated rows in Google Sheets team drive
- Create multiple Google Sheets rows every time an event ends in Google Calendar
- "update Google Sheets rows when events are cancelled in Google Calendar"
- Manage new Google Calendar events by initiating custom actions in Google Sheets
- Format spreadsheet rows in Google Sheets for new or updated events in Google Calendar
- Update Google Sheets rows for new Google Calendar events
- Create spreadsheets in Google Sheets for new events matching search in Google Calendar
- Copy worksheets in Google Sheets when events are cancelled in Google Calendar
- Update Google Sheets with new or updated events from Google Calendar
- Clear Google Sheets rows when Google Calendar events end