Connect Google Calendar and Google Sheets integrations
Connect Google Calendar and Google Sheets with any of your favorite apps in just a few clicks. Design, build, and automate anything for your work by integrating apps like Google Calendar and Google Sheets to create visual automated workflows. Choose from thousands of ready-made apps or use our no-code toolkit to connect to apps not yet in our library.
Triggers when an event is created, updated, deleted, started or ended in a selected calendar.
Creates a new conditional format rule at the given index. All subsequent rules' indexes are incremented.
Appends a new row to the bottom of the table.
Adds a new sheet.
Appends multiple rows to the bottom of the table.
Updates multiple rows.
Clears a specific cell.
Clears values from a specific row.
Clears a specified range of values from a spreadsheet.
Copies a sheet to another spreadsheet.
Creates a new spreadsheet.
Creates a new spreadsheet from a template sheet.
Deletes a conditional format rule at the given index. All subsequent rules' indexes are decremented.
Deletes a specific row.
Deletes a specific sheet.
Gets a specific cell.
Performs an arbitrary authorized API call.
Returns processed data as a result of the MAKE_FUNCTION or INTEGROMAT function. Sheets Add-On required.
Renames a specific sheet.
Updates a specific cell.
Updates a row.
Returns a sheet’s content defined by range values.
Gets a list of all sheets in a spreadsheet.
Returns results matching the given criteria.
Returns results matching the given criteria. This module doesn't return a row number.
Trusted by thousands of fast-scaling organizations around the globe
Automate your work. Build something new.
Just drag and drop apps to automate existing workflows or build new complex processes. Solve problems across all areas and teams.
Build your Google Calendar and Google Sheets integrations.
Create custom Google Calendar and Google Sheets workflows by choosing triggers, actions, and searches. A trigger is an event that launches the workflow, an action is the event.
Creates a new conditional format rule at the given index. All subsequent rules' indexes are incremented.
Appends a new row to the bottom of the table.
Adds a new sheet.
Appends multiple rows to the bottom of the table.
Updates multiple rows.
Clears a specified range of values from a spreadsheet.
Clears a primary calendar. This operation deletes all events associated with the primary calendar of an account.
Clears a specific cell.
Clears values from a specific row.
Popular Google Calendar and Google Sheets workflows.
Looking to get more out of Google Calendar and Google Sheets? With Make you can visually integrate Google Calendar and Google Sheets into any workflow to save time and resources — no coding required. Try any of these templates in just a few clicks.
Create Google Calendar events from data on your Google Sheet
Managing your events on a spreadsheet but spending time creating them on your calendar? Let Make create the events in your Google Calendar for you. Your spreadsheet must contain the following columns: A)Name, B)Email, C)Date, D)End date
TRY IT ->Create Google Calendar events and log them in Google Sheets using a webhook
Automatically create Google Calendar events from webhook data and log details in Google Sheets. Streamline event management and record-keeping with this integration.
TRY IT ->Search Google Calendar events and add them as rows in Google Sheets
Automatically search Google Calendar events and add them as rows in Google Sheets. Streamline event tracking and data management with this integration.
TRY IT ->Create a Google Calendar event for every new row in Google Sheets
Automatically create a Google Calendar event for every new row added in Google Sheets, ensuring your schedule stays updated with the latest data entries.
TRY IT ->Watch Google Calendar events and create posts on Facebook Pages with Google Sheets content
Automatically post on Facebook Pages using Google Sheets content whenever a new event is detected in Google Calendar, streamlining your social media updates.
TRY IT ->
+1
Add or delete leaves from Google Calendar in Status Hero
When a new leave in shared Google calendar is added or the leave is prolonged, the dates of the leave are uploaded in Status Hero. Conversely, when a leave is deleted, the dates in Status Hero are cancelled. Please ensure that employees in case of shortening the length of their leave first delete all the leave and then upload updated shorter leave! Otherwise the deleted days will not be cancelled in Status Hero.
TRY IT ->+1
Add new Google Calendar events to a Google Sheets spreadsheet as new rows and email it to a specified email address
Every time a new event is created in a Google calendar, Make will automatically add that event to your Google Sheets spreadsheet as a new row. The spreadsheet will be then sent to a specified email address. The template uses this [example spreadsheet](https://goo.gl/mKm0cn).
TRY IT ->Generate ChatGPT Completions from Google Sheets Rows
Effortlessly enhance your content creation process by integrating ChatGPT with Google Sheets. This powerful template allows you to automatically generate relevant completions, ranging from SEO keywords to custom responses, boosting productivity and content quality with ease. [Learn more](https://community.make.com/t/getting-started-with-openai-gpt-3-and-make/7796?utm_source=make&utm_medium=in-app&utm_campaign=template)
TRY IT ->Add webhook data to a Google Sheet
Use this automation to instantly capture data from a webhook and automatically add it as a new row in a Google Sheet. This is ideal for real-time data logging, form submissions, or any event-driven updates that must be stored in a spreadsheet. [Learn more about webhooks!](https://www.make.com/en/help/tools/webhooks)
TRY IT ->
FAQ
How it works
Traditional no-code iPaaS platforms are linear and non-intuitive. Make allows you to visually create, build, and automate without limits.
Trusted by 200,000+ customers
"Make really helped us to scale our operations, take the friction out of our processes, reduce costs, and relieved our support team. It is difficult to not become a fan."
"Make drives unprecedented efficiency within our business in ways we never imagined. It’s having an extra employee (or 10) for a fraction of the cost."
"The simplicity, flexibility and ability to build real complex automations without any knowledge of programming makes it the best thing since sliced bread."
"True citizen development in the entire company. Make is present in every department, empowering the company to offer a unique customer experience."
