Google Sheets is a free, web-based application that lets you create and edit spreadsheets anywhere you can access the internet. Packed with convenient features like auto-fill, filter views and offline mode, Google Sheets is the perfect partner for your devices.
Google Calendar is the time management and scheduling tool created by Google. It allows you to make appointments, organize your daily tasks, and more.
Google Calendar IntegrationsGoogle Sheets + Google Calendar
Find existing Google Calendar events when Google Sheets rows are updated Read More...Google Sheets + Google Calendar
Create Google Calendar events from new Google Sheets spreadsheet rows Read More...Google Sheets + Google Calendar
Create new Google Calendar events for updated rows on Google Sheets. Read More...Google Sheets + Google Calendar
Delete Google Calendar events when Google Sheets row are updated Read More...Google Sheets + Google Calendar
Create Google Calendar Events from New Rows on Google Sheets Spreadsheet Read More...It's easy to connect Google Sheets + Google Calendar without coding knowledge. Start creating your own business flow.
Triggers once a new spreadsheet is created.
Triggered when a new row is added to the bottom of a spreadsheet.
Trigger when a new row is added or modified in a spreadsheet.
Triggers a specified time before an event starts.
Triggers when an event is created.
Triggers every time an event matching a search is created.
Insert a new row in the specified spreadsheet.
Create a new spreadsheet row or Update an existing row.
Share Google Sheet.
Update a row in a specified spreadsheet.
Add a new event on Google Calendar, defining each field.
Create an event from incoming text sections. Google screens the text content for date, time, and description details.
Update an event. Updates only the fields that are filled.
(30 seconds)
(10 seconds)
(30 seconds)
(10 seconds)
(2 minutes)
Google Sheets is a web-based spreadsheet application developed by Google. It was announced on May 10, 2006, and the initial release occurred the same day. Google Sheets allows users to create and edit spreadsheets online while cplaborating with other users in real time.
Google Calendar is a time-management and scheduling calendar service developed by Google. It became available as a beta release on August 11, 2006, and it was released as a free service on April 13, 2007. In January 2010, Google added an interface for non-Google websites.
Google Sheets and Google Calendar can be integrated with each other through a Google Apps Script. This integration allows you to send data from a Google Sheets spreadsheet to a Google Calendar event. The process is simple and straightforward, as it requires only a few steps:
Create a new Google Docs script project.
Go to Tops > Script Editor > Resources > Libraries > CalendarEvents.
Then replace the code in your script with this code:
function calendarEvent(eventName, startTime, endTime. { // Find the Calendar object that the script is attached to var gCalendar = SpreadsheetApp.getActiveSpreadsheet(.getCalendar(); // Create an event var event = new gCalendar.Event(eventName); // Set the start and end times event.setStartTime(new Date(startTime)); event.setEndTime(new Date(endTime)); // Save the event. save({success. true}); } 1 2 3 4 5 6 7 8 9 function calendarEvent ( eventName , startTime , endTime . { // Find the Calendar object that the script is attached to var gCalendar = SpreadsheetApp . getActiveSpreadsheet ( . . getCalendar ( . ; // Create an event var event = new gCalendar . Event ( eventName . ; // Set the start and end times event . setStartTime ( new Date ( startTime . . ; event . setEndTime ( new Date ( endTime . . ; // Save the event. save ( { success . true } . ; } Open the script editor pane in your spreadsheet, go to File > Edit File > Advanced Settings... > Service Account. Click New Service Account Credentials. Name the credential [email protected], select “Furnish a new private key”, and click “Next”. Click “Browse” to locate the JSON file that was previously downloaded from the Google Developers Conspe. Click “Next” again. Click “Finish”. Click “OK” to close the advanced settings dialog box. Click “Save” to save your script changes. Click “Publish” to publish your script. Click “Close” to close the script editor pane in your spreadsheet. Click “Done” at the bottom of the left sidebar in your spreadsheet to close the sidebar pane if it appears. Click “Add-ons” in the top topbar of your spreadsheet. Click “Script Editor” in the Add-ons menu that appears. Click “Sheets” in the left sidebar in your spreadsheet. Click “Connect to add-on” in the top topbar of your spreadsheet. Click “Connect” in the Connect to add-on dialog box that appears. Select [email protected] in the list of available credentials and click “Connect” again. Click “Execute” in your main spreadsheet window (the one where you pasted code. A dialog will appear to let you know what command will be executed when you click “Run”; then click “Run” to execute this command. An alert box will appear after the command has been executed; then click “OK” to close this alert box. Go to Tops > Script Editor > Resources > Libraries > CalendarEvents again. Replace the code in your script with this code. function calendarEvent(eventName, startTime, endTime. { // Find the Calendar object that the script is attached to var gCalendar = SpreadsheetApp.getActiveSpreadsheet(.getCalendar(); // Create an event var event = new gCalendar.Event(eventName); // Get the date that corresponds with the current time var now = new Date(); // Get the date that corresponds with 20 minutes earlier than now var then = then = new Date(now - 20 * 60 * 1000); // Set the start and end times event.setStartTime(then); event.setEndTime(then); // Save the event. save({success. true}); } 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 function calendarEvent ( eventName , startTime , endTime . { // Find the Calendar object that the script is attached to var gCalendar = SpreadsheetApp . getActiveSpreadsheet ( . . getCalendar ( . ; // Create an event var event = new gCalendar . Event ( eventName . ; // Get the date that corresponds with the current time var now = new Date ( . ; // Get the date that corresponds with 20 minutes earlier than now var then = then = new Date ( now - 20 * 60 * 1000 . ; // Set the start and end times event . setStartTime ( then . ; event . setEndTime ( then . ; // Save the event. save ( { success . true } . ; } Now you have created a script that will add a calendar entry from a Google Sheets spreadsheet! Refresh your browser window, open your Google Sheets spreadsheet, and test out this script by adding a few more rows of data! You should see corresponding events added directly into your Google Calendar! To see how this works, open up your Google Calendar and check out all of these events that were created! If you want to try out this top yourself, fplow this link. https://scripteditor-test-googleapps-docs-com-documents/spreadsheets/d/1XV3uQ5oUs4jpyDqWU6Tf72oiX5qwXlLeLeXkWSggXVg/edit#gid=0
The process to integrate Google Sheets and Google Calendar may seem complicated and intimidating. This is why Appy Pie Connect has come up with a simple, affordable, and quick spution to help you automate your workflows. Click on the button below to begin.