Track every GCal event you're invited to in a Google spreadsheet
Connect top workflows
Quickly and easily enable Applets using Google Calendar and Google Sheets.-
16
-
-
ADP Calendar
64
-
-
Track your work hours
19
-
-
Calender Entry as Spreadsheet Row
28
-
-
Log Gcal events as they end in a Gsheet.
5
-
-
Track certain events in Sheets
10
-
-
Save events from Google Calendar in Google Spreadsheet
16
-
-
Google Calendar Events to Spreadsheet
277
-
-
Calendar to Google Sheets
465
-
Build your own Google Calendar and Google Sheets automations
Triggers (If this)
-
New event added
This Trigger fires every time a new event is added to your Google Calendar. Note: The time in the ingredient will be based on the timezone set in Google Calendar.
-
New spreadsheet added to folder
This trigger fires when a new spreadsheet is added to a Google Drive folder you specify. Note: only works for spreadsheets created after the Applet turned on.
-
New event from search added
This Trigger fires every time a new event from search is added to your Google Calendar that contains a specific keyword or phrase. The search looks at the event’s Title, Description, and Location. Ingredient will be based on the timezone set in Google
-
New worksheet in spreadsheet
This trigger fires when a new worksheet is added to a spreadsheet you specify.
-
Any event starts
This Trigger fires a set number of minutes before the starting time of any event on your Google Calendar. Note: The time in the ingredient will be based on the timezone set in Google Calendar.
-
New row added to spreadsheet
This trigger fires when a new row is added to a spreadsheet you specify.
-
Event from search starts
This Trigger fires a set number of minutes before the starting time of an event on your Calendar that contains a specific keyword or phrase in the event’s Title, Description, or Location. Ingredient will be based on the zone set in Google.
-
Cell updated in spreadsheet
This trigger fires when a particular cell is updated within the spreadsheet you specify.
-
Any event ends
This Trigger fires within 15 minutes of the ending time of an event on your Google Calendar. Note: The time in the ingredient will be based on the timezone set in Google Calendar.
-
New event from search ends
This Trigger fires within 15 minutes of the ending time of an event on your Google Calendar that contains a specific keyword or phrase. The search looks at the event’s Title, Description, and Location. Ingredient will be based on the zone set in Google.
-
You respond to an event invite
The trigger fires every time you respond to an event you're invited to. Note: The time in the ingredient will be based on the timezone set in Google Calendar.
New event added
This Trigger fires every time a new event is added to your Google Calendar. Note: The time in the ingredient will be based on the timezone set in Google Calendar.
New spreadsheet added to folder
This trigger fires when a new spreadsheet is added to a Google Drive folder you specify. Note: only works for spreadsheets created after the Applet turned on.
New event from search added
This Trigger fires every time a new event from search is added to your Google Calendar that contains a specific keyword or phrase. The search looks at the event’s Title, Description, and Location. Ingredient will be based on the timezone set in Google
New worksheet in spreadsheet
This trigger fires when a new worksheet is added to a spreadsheet you specify.
Any event starts
This Trigger fires a set number of minutes before the starting time of any event on your Google Calendar. Note: The time in the ingredient will be based on the timezone set in Google Calendar.
New row added to spreadsheet
This trigger fires when a new row is added to a spreadsheet you specify.
Event from search starts
This Trigger fires a set number of minutes before the starting time of an event on your Calendar that contains a specific keyword or phrase in the event’s Title, Description, or Location. Ingredient will be based on the zone set in Google.
Cell updated in spreadsheet
This trigger fires when a particular cell is updated within the spreadsheet you specify.
Any event ends
This Trigger fires within 15 minutes of the ending time of an event on your Google Calendar. Note: The time in the ingredient will be based on the timezone set in Google Calendar.
New event from search ends
This Trigger fires within 15 minutes of the ending time of an event on your Google Calendar that contains a specific keyword or phrase. The search looks at the event’s Title, Description, and Location. Ingredient will be based on the zone set in Google.
You respond to an event invite
The trigger fires every time you respond to an event you're invited to. Note: The time in the ingredient will be based on the timezone set in Google Calendar.
Queries (With)
-
List Calendars
This query returns your calendars.
-
Current values of a row
This query returns the current values in a given row. Values from columns A-Z are available as ingredients.
-
Search Events
Search events of a calendar
-
Current value of a cell
This query returns the current value of a single cell in your spreadsheet.
-
List Attendees
Get a list of event attendees
-
History of rows added to spreadsheet
This query returns a list of when a new row is added to a spreadsheet you specify.
-
List Busy Windows
List time windows when someone is busy.
-
History of when Cell was updated in spreadsheet
This query returns a list of when a particular cell was updated within the spreadsheet you specify.
-
List Events For a Date
This query returns a list events for a specific day.
-
History of spreadsheets added to folder
This query returns a list of when a new spreadsheet is added to a Google Drive folder you specify. Note: only works for spreadsheets created after the Applet turned on.
-
List Events For a Date Range
This query lists events for a specific date range.
-
History of worksheets in spreadsheet
This query returns a list of when a new worksheet is added to a spreadsheet you specify.
-
History of times you responded to a calendar invite.
The query returns a list of when you responded to an event you're invited to.
-
History of events from search added
This query returns a list of every time a new event from search is added to your Google Calendar that contains a specific keyword or phrase. The search looks at the event’s Title, Description, and Location.
-
History of events from search ended
This query returns a list of ending time (within 15 minutes) of events on your Google Calendar that contains a specific keyword or phrase. The search looks at the event’s Title, Description, and Location.
-
History of calendar event endings
This query returns a list of event ending times on your Google Calendar.
-
History of event from search starts
This query returns a list of a set number of minutes before the starting time of an event on your Google Calendar that contains a specific keyword or phrase. The search looks at the event’s Title, Description, and Location.
-
History of events added
This query returns a list of every time a new event is added to your Google Calendar.
-
History of calendar event beginnings
This query returns a list of event starting times on your Google Calendar.
List Calendars
This query returns your calendars.
Current values of a row
This query returns the current values in a given row. Values from columns A-Z are available as ingredients.
Search Events
Search events of a calendar
Current value of a cell
This query returns the current value of a single cell in your spreadsheet.
List Attendees
Get a list of event attendees
History of rows added to spreadsheet
This query returns a list of when a new row is added to a spreadsheet you specify.
List Busy Windows
List time windows when someone is busy.
History of when Cell was updated in spreadsheet
This query returns a list of when a particular cell was updated within the spreadsheet you specify.
List Events For a Date
This query returns a list events for a specific day.
History of spreadsheets added to folder
This query returns a list of when a new spreadsheet is added to a Google Drive folder you specify. Note: only works for spreadsheets created after the Applet turned on.
List Events For a Date Range
This query lists events for a specific date range.
History of worksheets in spreadsheet
This query returns a list of when a new worksheet is added to a spreadsheet you specify.
History of times you responded to a calendar invite.
The query returns a list of when you responded to an event you're invited to.
History of events from search added
This query returns a list of every time a new event from search is added to your Google Calendar that contains a specific keyword or phrase. The search looks at the event’s Title, Description, and Location.
History of events from search ended
This query returns a list of ending time (within 15 minutes) of events on your Google Calendar that contains a specific keyword or phrase. The search looks at the event’s Title, Description, and Location.
History of calendar event endings
This query returns a list of event ending times on your Google Calendar.
History of event from search starts
This query returns a list of a set number of minutes before the starting time of an event on your Google Calendar that contains a specific keyword or phrase. The search looks at the event’s Title, Description, and Location.
History of events added
This query returns a list of every time a new event is added to your Google Calendar.
History of calendar event beginnings
This query returns a list of event starting times on your Google Calendar.
Actions (Then that)
-
Update cell in spreadsheet
This action will update a single cell in the first worksheet of a spreadsheet you specify. Note: a new spreadsheet is created if the file doesn't exist.
-
Quick add event
This Action will add an event to your Google Calendar. Simply include a detailed description of when and what.
-
Add row to spreadsheet
This action will add a single row to the bottom of the first worksheet of a spreadsheet you specify. Note: a new spreadsheet is created after 2000 rows.
-
Create a detailed event
This action will create a detailed event in your Google Calendar.
Update cell in spreadsheet
This action will update a single cell in the first worksheet of a spreadsheet you specify. Note: a new spreadsheet is created if the file doesn't exist.
Quick add event
This Action will add an event to your Google Calendar. Simply include a detailed description of when and what.
Add row to spreadsheet
This action will add a single row to the bottom of the first worksheet of a spreadsheet you specify. Note: a new spreadsheet is created after 2000 rows.
Create a detailed event
This action will create a detailed event in your Google Calendar.
How to connect Google Calendar and Google Sheets
Find or create an Applet
Start by discovering an automation to connect or customizing your own. It's quick and easy.Connect IFTTT to your accounts
Securely connect your Google Calendar and Google Sheets accounts.Finalize and customize your Applet
Review your trigger and action settings. Your Applet is ready to go!Top integration tips, tools, and resources
-
Productivity
10 best productivity apps for 2025
-
Productivity
Guide to organizing and saving articles
-
Business
How to automate scheduling tasks to improve productivity
-
Popular
How an IFTTTer is automating their project management
-
Popular
How to connect your first Applet
-
Popular
How a freelancer automations their tutoring business with IFTTT
IFTTT helps all your apps and devices work better together