Save events from Google Calendar in Google Spreadsheet
Start today
Popular Google Calendar and Google Sheets workflows and automations
22- Track your work hours16
- Google Calendar Events to Spreadsheet
281 - Track certain events in Sheets
8 - Log Gcal events as they end in a Gsheet.6
- Calendar to Google Sheets447
- Track every GCal event you're invited to in a Google spreadsheet 18
- ADP Calendar55
- Calender Entry as Spreadsheet Row32
Useful Google Calendar and Google Sheets integrations
Triggers (If this)
- New event addedThis 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 folderThis 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 addedThis 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 spreadsheetThis trigger fires when a new worksheet is added to a spreadsheet you specify.
- Any event startsThis 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 spreadsheetThis trigger fires when a new row is added to a spreadsheet you specify.
- Event from search startsThis 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 spreadsheetThis trigger fires when a particular cell is updated within the spreadsheet you specify.
- Any event endsThis 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 endsThis 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 inviteThe 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 CalendarsThis query returns your calendars.
- Current values of a rowThis query returns the current values in a given row. Values from columns A-Z are available as ingredients.
- Search EventsSearch events of a calendar
- Current value of a cellThis query returns the current value of a single cell in your spreadsheet.
- List AttendeesGet a list of event attendees
- History of rows added to spreadsheetThis query returns a list of when a new row is added to a spreadsheet you specify.
- List Busy WindowsList time windows when someone is busy.
- History of when Cell was updated in spreadsheetThis query returns a list of when a particular cell was updated within the spreadsheet you specify.
- List Events For a DateThis query returns a list events for a specific day.
- History of spreadsheets added to folderThis 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 RangeThis query lists events for a specific date range.
- History of worksheets in spreadsheetThis 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 addedThis 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 endedThis 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 endingsThis query returns a list of event ending times on your Google Calendar.
- History of event from search startsThis 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 addedThis query returns a list of every time a new event is added to your Google Calendar.
- History of calendar event beginningsThis query returns a list of event starting times on your Google Calendar.
Actions (Then that)
- Add row to spreadsheetThis 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.
- Quick add eventThis Action will add an event to your Google Calendar. Simply include a detailed description of when and what.
- Update cell in spreadsheetThis 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.
- Create a detailed eventThis action will create a detailed event in your Google Calendar.
Google Calendar and Google Sheets resources
What is a CRM in real estate?
CRM's are extremely important for real estate agents. Click to learn what a CRM is in Real Estate.
How to use Calendly (Easiest Guide)
New to Calendly? Click to read how to use Calendly quickly and easily. IFTTT connects Calendly with 750+ digital tools. Join IFTTT today!
5 best cloud storage apps to access docs easily
Find the best cloud storage apps for accessing your content easily and learn how IFTTT can help you integrate your cloud storage with other tools you love.
How to get more followers on TikTok in 2024
Discover effective strategies to boost your TikTok follower count in 2024! Learn tips and tricks to enhance your content, engage with your audience, and grow your TikTok presence with IFTTT.
How to export Trello to Google Sheets
Learn how to export your Trello boards to Google Sheets automatically. Set up this integration in minutes with IFTTT.
7 repetitive tasks that small businesses should automate in 2024
Looking to improve your small business? Consider automating some of your tasks. IFTT will help you explore the benefits of automation and recommend some popular apps to use. Small Busines Automation
IFTTT helps all your apps and devices work better together