?>

Google Sheets + Google Calendar Integrations

Appy Pie Connect allows you to automate multiple workflows between Google Sheets and Google Calendar

  • No code
  • No Credit Card
  • Lightning Fast Setup
About Google Sheets

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.

About Google Calendar

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 Integrations
Google Calendar Alternatives

Looking for the Google Calendar Alternatives? Here is the list of top Google Calendar Alternatives

  • Microsoft Outlook Microsoft Outlook
  • Calendly Calendly

Best ways to Integrate Google Sheets + Google Calendar

  • Google Sheets Google Calendar

    Google Sheets + Google Calendar

    Find existing Google Calendar events when Google Sheets rows are updated Read More...
    Close
    When this happens...
    Google Sheets New or Updated Spreadsheet Row
     
    Then do this...
    Google Calendar Update Event
    If you’re spending way too much time on managing your Google Calendar events, then this integration is a must for you. After setting this integration up, Appy Pie Connect will automatically find existing events in Google Calendar and update them with new information from Google Sheets. Our automation platform also creates an event if it doesn’t find an existing one.
    How This Integration Works
    • Triggers when a row is updated in Google Sheets
    • Appy Pie Connect finds an existing Google Calendar event and updates it with the new information
    • Appy Pie Connect creates an event if it doesn’t find an existing one
    What You Need
    • A Google account with access to Google Sheets
    • A Google account with access to Google Calendar
  • Google Sheets Google Calendar

    Google Sheets + Google Calendar

    Create Google Calendar events from new Google Sheets spreadsheet rows Read More...
    Close
    When this happens...
    Google Sheets New Spreadsheet Row
     
    Then do this...
    Google Calendar Create Detailed Event
    Manage Google Calendar events right from your Google Sheets Spreadsheet. Set up this Connect, and we will create Google Calendar events directly from the new rows in a Google Spreadsheet. Hence, you can stay on top of your schedule by viewing all appointments or upcoming events in Google Calendar Events.
    How This Integration Works
    • Triggers when a new row is added to Google Spreadsheet
    • Appy Pie Connect picks information from that row and creates events in your Google Calendar.
    What You Need
    • A Google Spreadsheet
    • Google Calendar
  • Google Sheets Google Calendar

    Google Sheets + Google Calendar

    Create new Google Calendar events for updated rows on Google Sheets. Read More...
    Close
    When this happens...
    Google Sheets New or Updated Spreadsheet Row
     
    Then do this...
    Google Calendar Quick Add Event
    Use this Connect to automatically create Google Calendar events for every new row on Google Sheets. Once you have activated it, we will automatically create an event in Google calendar whenever you update a Google Sheets spreadsheet row. Appy Pie Connect picks the detailed information from the updated rows and creates a new Google calendar event accordingly.
    How This Integration Works
    • Triggers every time a row is updated on Google Sheets
    • Appy Pie Connect automatically creates a new event on Google Calendar
    What You Need
    • A Google Sheets account
    • A Google Calendar account
  • Google Sheets Google Calendar

    Google Sheets + Google Calendar

    Delete Google Calendar events when Google Sheets row are updated Read More...
    Close
    When this happens...
    Google Sheets New or Updated Spreadsheet Row
     
    Then do this...
    Google Calendar Delete Event
    Google Calendar is a great tool to keep track of all the important events in one place. Once you’ve set it up, Appy Pie Connect will automatically update the respective Google Calendar events when Google Sheets rows are updated. Moreover, when an event in Google calendar is deleted, all attendees will be notified automatically.
    How It Works
    • Triggers when a row is updated in Google Sheets
    • Appy Pie Connect automatically updates a Google Calendar event
    What You Need
    • A Google account with Google Sheets access
    • A Google account with Google Calendar access
  • Google Sheets Google Calendar

    Google Sheets + Google Calendar

    Create Google Calendar Events from New Rows on Google Sheets Spreadsheet Read More...
    Close
    When this happens...
    Google Sheets New Spreadsheet Row
     
    Then do this...
    Google Calendar Quick Add Event
    Manage Google Calendar events right from your Google Sheets Spreadsheet. Set up this Connect, and we will create Google Calendar events directly from the new rows in a Google Spreadsheet. Hence, you can stay on top of your schedule by viewing all appointments or upcoming events in Google Calendar Events.
    How This Integration Works
    • Triggers when a new row is added to Google Spreadsheet
    • Appy Pie Connect picks information from that row and creates events in your Google Calendar.
    What You Need
    • A Google Spreadsheet
    • A Google Calendar
  • Google Sheets {{item.actionAppName}}

    Google Sheets + {{item.actionAppName}}

    {{item.message}} Read More...
    Close
    When this happens...
    {{item.triggerAppName}} {{item.triggerTitle}}
     
    Then do this...
    {{item.actionAppName}} {{item.actionTitle}}
Connect Google Sheets + Google Calendar in easier way

It's easy to connect Google Sheets + Google Calendar without coding knowledge. Start creating your own business flow.

    Triggers
  • New Spreadsheet

    Triggers once a new spreadsheet is created.

  • New Spreadsheet Row

    Triggered when a new row is added to the bottom of a spreadsheet.

  • New or Updated Spreadsheet Row

    Trigger when a new row is added or modified in a spreadsheet.

  • Event Start

    Triggers a specified time before an event starts.

  • New Event

    Triggers when an event is created.

  • New Event Matching Search

    Triggers every time an event matching a search is created.

    Actions
  • Create Spreadsheet Row

    Insert a new row in the specified spreadsheet.

  • Share Sheet

    Share Google Sheet.

  • Update Spreadsheet Row

    Update a row in a specified spreadsheet.

  • Create Detailed Event

    Add a new event on Google Calendar, defining each field.

  • Quick Add Event

    Create an event from incoming text sections. Google screens the text content for date, time, and description details.

  • Update Event

    Update an event. Updates only the fields that are filled.

How Google Sheets & Google Calendar Integrations Work

  1. Step 1: Choose Google Sheets as a trigger app and authenticate it on Appy Pie Connect.

    (30 seconds)

  2. Step 2: Select "Trigger" from the Triggers List.

    (10 seconds)

  3. Step 3: Pick Google Calendar as an action app and authenticate.

    (30 seconds)

  4. Step 4: Select a resulting action from the Action List.

    (10 seconds)

  5. Step 5: Select the data you want to send from Google Sheets to Google Calendar.

    (2 minutes)

  6. Your Connect is ready! It's time to start enjoying the benefits of workflow automation.

Integration of Google Sheets and Google Calendar

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.