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.
How It Works
- A new Google Calendar event is created.
- Zapier adds that event in Google Sheets as a new row.
What You Need
- Google account
Why Zapier?
Get started for free—14 day trial of premium features and apps.
No coding required—automate any of 1,500+ apps in minutes.
Enterprise-level security—connect mission-critical apps.
Generate Google Calendar events from new Google Sheets rows
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.
Note: Use this Zap template only if you're adding all the information to the row at once (from a form, for instance.) If not you'll want to use this Zap so it only triggers on updates to specific columns.
Create Google Calendar events from new Google Form entries
This Zapier integration connects a Google Form to a Google Calendar account, automating the creation of new events.
How It Works
- Zapier watches your Google Form's associated Google Sheet for new responses
- When a new response is received, Zapier creates a Google Calendar event
What You Need
- The Google Sheet of a Google Form (where you results are compiling)
- Google Calendar account
Find and update existing Google Calendar events when Google Sheets rows are updated
Plans often change, so your calendar events should too. This integration automatically finds existing Google Calendar events and updates them with new information from Google Sheets. 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.
How this Google Sheets-Google Calendar integration works
- A row is updated in Google Sheets
- Zapier finds an existing Google Calendar event (or creates one if it doesn't already exist)
- Zapier updates the existing Google Calendar event
Apps involved
- Google Sheets
- Google Calendar
Create new Google Calendar events for updated rows on Google Sheets.
So you need to store event information in a spreadsheet and eventually add it to a calendar. Forget about doing it yourself when the time comes—use this Google Sheets-Google Calendar integration instead! It will trigger every time you update a row on Google Sheets, sending the details over to Google Calendar so a new event can be parsed from the text and created for you with a simple change of a cell!
How It Works
- A row is updated on Google Sheets
- Zapier automatically creates a new quick event on Google Calendar
What You Need
- Google Sheets account
- Google Calendar account
Log Google Calendar events into a Google Sheets spreadsheet
If you are an avid user of Google and use it for your business, this automation is a perfect fit. Once set up, every time a new Google Calendar event starts, Zapier will add a new row to a selected Google Sheets spreadsheet. Keep track of every event automatically with this integration.
How It Works
- An event starts in Google Calendar
- Zapier adds a new row to a selected Google Sheets spreadsheet
What You Need
- Google account
Add tasks to Trello and Google Calendar from a Google Sheets spreadsheet
Want to organize your tasks on a kanban board and list them based on their due date in a calendar? This Zapier workflow will do that for you. Just list your tasks in a Google Sheets spreadsheet, and Zapier will create a new Trello card for each task and also list each tasks on your Google Calendar. It's a great way to turn your tasks into a complete agenda.
Learn more about how to use this workflow with our SMART workflow guide (https://zapier.com/blog/smart-goals/).
How this Google Sheets-Trello-Google Calendar integration works
- A new row is added to your Google Sheets spreadsheet
- Zapier adds the info as a new card to your Trello board
- Zapier also adds the task as an event to your Google Calendar schedule
Apps involved
- Google Sheets
- Trello
- Google Calendar
Delete Google Calendar events when Google Sheets row are updated
Creating events in spreadsheets and using Zapier to create related events in Google Calendar is a great way to mass-manage event lists. If events are canceled or have concluded, you can delete them from Google Calendar automatically. Use this Zap to automatically delete Google Calendar events whenever Google Sheets rows are updated. That way, all event attendees are notified and your Google Calendar is updated without you ever leaving Google Sheets.
How this Google Sheets-Google Calendar integration works
- A row is updated in Google Sheets
- Zapier deletes a Google Calendar event
Apps involved
- Google Sheets
- Google Calendar
Create new Google Calendar events from new Google Sheets rows (parsed)
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
- A new row is added to Google Sheets
- Zapier automation creates a new Google Calendar event with the Quick Add Event function
What You Need
- Google account
Add tasks to Wunderlist and Google Calendar from a Google Sheets spreadsheet
Spreadsheets are a great way to quickly list your agenda for the week, and with Zapier, you can turn those lists into tasks and events automatically. Just set up this workflow, and whenever you add a new row to your Google Sheets spreadsheet, Zapier will add a new task to your Wunderlist to-do list and add the task as an event to your Google Calendar so you won't forget about it.
Learn more about how to use this workflow with our SMART workflow guide (https://zapier.com/blog/smart-goals/).
How this Google Sheets-Wunderlist-Google Calendar integration works
- A new row is added to your Google Sheets spreadsheet
- Zapier adds the info as a new task to Wunderlist
- Zapier also adds the task as an event to your Google Calendar schedule
Apps involved
- Google Sheets
- Wunderlist
- Google Calendar
Add new emails that match a Gmail search to a new row on Google Sheets
Get a little help sifting through all that junk-mail with this Google Calendar-Google Sheets integration. Activate it to have Zapier watch your calendar for matches to your search; any we find will be sent to Google Sheets automatically where a new row will be added to your spreadsheet for each event.
How It Works
- A new event matches a search on Google Calendar
- Zapier automatically creates a new row on Google Sheets
What You Need
- Google Calendar account
- Google Sheets account
Add tasks to OmniFocus and Google Calendar from a Google Sheets spreadsheet
Need a simple way to add your agenda to your to-do list app and calendar? Zapier can help. With this Zap, you can plan your schedule in a Google Sheets spreadsheet, and Zapier will add each row in the spreadsheet as a new task in OmniFocus and as a new event in your Google Calendar so you'll never forget about anything that needs done.
Learn more about how to use this workflow with our SMART workflow guide (https://zapier.com/blog/smart-goals/).
How this Google Sheets-OmniFocus-Google Calendar integration works
- A new row is added to your Google Sheets spreadsheet
- Zapier adds the info as a new task to OmniFocus
- Zapier also adds the task as an event to your Google Calendar schedule
Apps involved
- Google Sheets
- OmniFocus
- Google Calendar
It's easy to connect Google Calendar + Google Sheets and requires absolutely zero coding experience—the only limit is your own imagination.
Triggers when an event is created.
Create an event by defining each field.
Triggers when an event is created that matches a search.
Create an event from a piece of text. Google parses the text for date, time, and description info.
Triggers a specified time before an event starts.
Updates an event. Only filled fields are updated.
Triggered when a new row is added to the bottom of a spreadsheet.
Create a blank worksheet with a title. Optionally, provide headers.
Triggered when a new row is added or modified in a spreadsheet.
Create a new row in a specific spreadsheet.
Use our free platform to build a single Zapier integration and instantly connect your app with 1,500+ others.
Become a Zapier Integration Partner