Connect Google Calendar with Google Sheets
Connect Google Calendar with Google Sheets to scale and automate your operations.
Explore automation templates
Automate Google Calendar and Google Sheets with Pluga integrations
For each new created event on Google Calendar, add data to a new row on a Google Sheets spreadsheet
For each cancelled event (deleted) on Google Calendar, add data to a new row on a Google Sheets spreadsheet
For each ended event on Google Calendar, add data to a new row on a Google Sheets spreadsheet
When a new row is created on Google Sheets, create an event on Google Calendar
For each new created event on Google Calendar, update or add data in a new row of a Google Sheets spreadsheet
For each cancelled event (deleted) on Google Calendar, update or add data in a new row of a Google Sheets spreadsheet
For each ended event on Google Calendar, update or add data in a new row of a Google Sheets spreadsheet
For each row created or updated in Google Sheets, create an event on Google Calendar
Didn't find the template you wanted? Build the integration your own way. ;)
Trusted by over 10.000 amazing companies
Google Calendar and Google Sheets
your way
Check out the available triggers and actions in the automation of apps Google Calendar + Google Sheets
Ended event
For each ended event on Google Calendar
Event title
Description
Event's place
Event start date and time
Event start date and time with time zone
Event start date
Event start time
Event end date and time
Event end date and time with time zone
Event end date
Event end time
Event creator email
Event creator name
Event link
Event duration (Hours)
Event duration (Minutes)
Event creation date and time
Event update date and time
Participant names
Participants' email
Event ID
Event status
Hangout link
New added row
When a new row is added on Google Sheets
Line No.
Cancelled event (deleted)
For each cancelled event (deleted) on Google Calendar
Event title
Description
Event's place
Event start date and time
Event start date and time with time zone
Event start date
Event start time
Event end date and time
Event end date and time with time zone
Event end date
Event end time
Event creator email
Event creator name
Event link
Event duration (Hours)
Event duration (Minutes)
Event creation date and time
Event update date and time
Participant names
Participants' email
Event ID
Event status
Hangout link
For each row created/updated
For each row created or updated in Google Sheets
Nº da linha
Event created
For each new created event on Google Calendar
Event title
Description
Event's place
Event start date and time
Event start date and time with time zone
Event start date
Event start time
Event end date and time
Event end date and time with time zone
Event end date
Event end time
Event creator email
Event creator name
Event link
Event duration (Hours)
Event duration (Minutes)
Event creation date and time
Event update date and time
Participant names
Participants' email
Event ID
Event status
Hangout link
Create event
create an event on Google Calendar
All day event
Event start date and time Required
Event end date and time Required
Event title
Description
Event's place
Select repeat frequency
Repeat until the established date
Participants' email
Video conference via Google Meet
Default notification
Event color
Insert row in spreadsheet
add data to a new row on a Google Sheets spreadsheet
Columns
Insert/update row in spreadsheet
add or update data in Google Sheets spreadsheet's row(s)
Search event
Search events in Google Calendar
Define recurring events
Order of captured events
Search term
Events that end before
Events that started after
Event types
Insert multiple rows in spreadsheet (only for multiple items)
add the data to multiple rows in a Google Sheets spreadsheet
Delete event
Delete event in Google Calendar
Event ID Required
Delete recurring events
Send deletion notification
Guests who will receive notifications about the event deletion.
Search rows in a spreadsheet
Search rows in a spreadsheet in Google Sheets
Search Column Required
Condition
Search value
Additional filters
Result limit
No rows found?
Boost this flow in your workflow
With Pluga, you connect Google Calendar + Google Sheets to build anything from the simplest integration to the most advanced flows, with several layers of logic.
- Basic 1
Pick the source app and the trigger
Choose which app starts the automation and which event works as the trigger. For example, "For each cancelled event (deleted) on Google Calendar".
- Basic 2
Set the destinations and the actions
Select the apps that make up the flow with Google Sheets and what Pluga should run automatically at each step. Example: "add data to a new row on a Google Sheets spreadsheet"
- Basic 3
Map the information
Point out, visually, which data from the source app should fill in each field of the destination action.
- Intermediate
Only move forward when it makes sense
Set "AND" or "OR" conditions so the automation only runs in the cases that matter
- Intermediate
Pause the flow for as long as you need
Set the automation to wait minutes, hours or days and resume the next action on its own
- Intermediate
Standardize data across apps
Adjust dates, numbers and characters to the format the next app expects to receive
- Advanced
Send data in several directions
Route each piece of data down the right path within a single flow, according to specific conditions
- Advanced
Add a code block
Run JavaScript or Python in the middle of the automation to transform data before the next step
- Advanced
Create loops
Take lists of items, go through each row and run the same action for every one of them
- Advanced
Use generative AI
Send data to an AI assistant or agent and use the response in the next step
- Advanced
Connect to (almost) any app
Send and receive data through a dedicated URL, and connect to apps that are not integrated with Pluga
- Advanced
Requests to external APIs
Query or send data to any external API inside your automation
Google Calendar
CalendarConnect Google Calendar to 133+ apps with Pluga and turn your work into a productive machine. Create events automatically, sync appointments across apps and let your team know about every booking.
Google Sheets
SpreadsheetConnect Google Sheets to 133+ apps with Pluga and turn your work into a productive machine. Centralize data from several apps in a single spreadsheet, keep your reports updated in real time and use the spreadsheet as a bridge between the apps you already work with.
