Loading

Google Calendar + Google Sheets

Generate Google Calendar events from new Google Sheets rows

Ever need to create calendar events in bulk? Or let others easily add calendar events for you? Or perhaps you just find it easier to manage your calendar in a spreadsheet. If so, this integration makes it easy: it will create new Google Calendar events straight from new rows whenever they're added to a Google Sheet, so you don't have to worry about adding them twice.

Ever need to create calendar events in bulk? Or let others easily add calendar events for you? Or perhaps you just find it easier to manage your calendar in a spreadsheet. If so, this integration makes it easy: it will create new Google Calendar events straight from new rows whenever they're added to a Google Sheet, so you don't have to worry about adding them twice.

  1. When this happens...
    Google SheetsGoogle Sheets
    New Spreadsheet Row

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

    TriggerInstant
  2. automatically do this!
    Google CalendarGoogle Calendar
    Create Detailed Event

    Create an event by defining each field.

    ActionWrite
Try this template
  • Free forever for core features
  • 14 day trial for premium features & apps

Supported triggers and actions

What does this mean?
    • Drive

      The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.

    • SpreadsheetRequired

    • WorksheetRequired

      You must have column headers

    Trigger
    Scheduled
    Try It
    • Drive

      The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.

    Trigger
    Scheduled
    Try It
    • No Team Drive

      If you want to use this trigger with a Sheet that resides in your Google Team Drive, you have to workaround the issue using these steps.

    • SpreadsheetRequired

    • WorksheetRequired

      You must have column headers

    • Trigger Column

      Trigger on changes to cells in this column only. Leave this field blank if you want the Zap to trigger on changes to any cell within the row. Please note: All new rows will trigger the Zap even if the Trigger column is empty. Add a Filter step to stop the Zap from continuing if this column is empty in a new row.

    Trigger
    Instant
    Try It
    • Drive

      The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.

    • SpreadsheetRequired

    • WorksheetRequired

    • Column NameRequired

    • Index

      The column position (zero-based) to insert. If not set, append to the right by default.

    Action
    Write
    • No Team Drive

      If you want to use this trigger with a Sheet that resides in your Google Team Drive, you have to workaround the issue using these steps.

    • SpreadsheetRequired

    • WorksheetRequired

      You must have column headers

    Trigger
    Instant
    Try It
    • Drive

      The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.

    • SpreadsheetRequired

    • WorksheetRequired

      You must have column headers

    • Trigger Column

      Trigger on changes to cells in this column only. Leave this field blank if you want the Zap to trigger on changes to any cell within the row. Please note: All new rows will trigger the Zap even if the Trigger column is empty. Add a Filter step to stop the Zap from continuing if this column is empty in a new row.

    Trigger
    Scheduled
    Try It
    • Drive

      The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.

    • SpreadsheetRequired

    Trigger
    Scheduled
    Try It
    • Drive

      The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.

    • SpreadsheetRequired

    • WorksheetRequired

    Action
    Write
google-calendar logo
google-calendar logo

About Google Calendar

Google Calendar lets you organize your schedule and share events with co-workers and friends. With Google's free online calendar, it's easy to keep track of your daily schedule.
Learn more

Related categories

  • Calendar
  • Google

Similar apps

Appointlet integrations

Appointlet

Scheduling & Booking
Acuity Scheduling integrations

Acuity Scheduling

Scheduling & Booking
Microsoft Office 365 integrations

Microsoft Office 365

Email, Microsoft
google-sheets logo
google-sheets logo

About Google Sheets

Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.
Learn more

Related categories

Similar apps

Zoho Creator integrations

Zoho Creator

App Builder, Zoho
Smartsheet integrations

Smartsheet

Spreadsheets
Quip integrations

Quip

Documents

Get started for free

You can't add more hours to the day. Zapier is the next best thing.


OR

By signing up, you agree to Zapier's terms of service and privacy policy.