Google Sheets + Google Calendar Integrations

Google Sheets

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

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.

Integration of Google Sheets and Google Calendar

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.