Sheets2GCal Sync Logo Sheets2GCal Sync
Google Workspace Add-on

Sync Sheets to Google Calendar Instantly

Sheets2GCal Sync is a secure Google Workspace Add-on that converts your Google Sheets rows into Google Calendar events. Create, update, and manage calendar events directly from your spreadsheet with full control.

📅 Sheets2GCal Sync Sidebar Connected
✅ 3 row(s) selected based on 'Sync' checkboxes. Ready to sync.
Title Column: Title
Date Column: Date

Purpose & Integration Details

What data we access, how we use it, and why we integrate with Google Workspace.

Connecting Sheets & Calendar

Sheets2GCal Sync is built to resolve a common manual challenge: updating calendars from organized team lists, event trackers, or client onboarding sheets. By creating a direct bridge, our add-on accesses:

  • Google Sheets (Active File): Reads user-designated row data (Title, Date, description, and guest emails) to build calendar events. Writes back a unique Calendar Event ID to avoid duplicate events.
  • Google Calendar: Creates or updates events on calendars that you own or have access to, and adds guests silently or via standard invites per your instructions.

🔒 Strictly Local & Temporary: All operations run inside the Google Apps Script environment of your Google Account. Data is sent directly between Google Sheets and Google Calendar. No sheet data or calendar contents are ever transmitted to or stored on any external servers.

AI Features & Third-Party APIs

If you enable the optional AI Tools feature in Settings, the add-on connects to the Google Gemini API to generate structured meeting agendas or event descriptions from sheet cell inputs.

  • Uses the developer-configured or user-configured Gemini API Key.
  • Sends only the specific row content necessary to render the description prompt template.
  • Google API Service data sent to Gemini is governed by privacy guidelines preventing it from being used for generalized model training.

How Sheets2GCal Sync Works

A simple, controlled process to convert and update schedule events without automatic spam.

1

Select Rows with Checkboxes

The add-on creates a Sync column in your sheet. Simply check the box for the rows you want to convert into calendar events.

2

Map the Columns

Open the sidebar and map your sheet headers (e.g. Title, Date, Time, Description) to Google Calendar fields.

3

Preview & Synchronize

Click Preview to double-check formatting, then click Sync. Only checked rows are processed, writing calendar events instantly.

Core Features

Powerful sync tools built directly into Google Sheets.

☑️

Checkbox Selection (Sync)

Complete manual control. Only rows where the first-column checkbox is checked (TRUE) are created or updated.

AI Descriptions & Agendas

Optionally generate event descriptions or agendas from event titles using Google Gemini AI, written directly back to sheets.

📋

Sample Templates

No headers? No problem. Open on an empty sheet and click one button to generate a beautifully pre-formatted sample layout.

Frequently Asked Questions

Clear answers about permissions, security, and operation.

Does the add-on store my spreadsheet or calendar data? +
No. Sheets2GCal Sync is a client-side integration built on Google Apps Script. All data reads from Google Sheets and writes to Google Calendar occur within your browser's Google Session. No data is sent to external databases or stored by the developer.
What scopes does the add-on require? +
We require minimal marketplace permissions: access to the active spreadsheet file (currentonly), read/write access to Google Calendar events, and network access (script.external_request) only if using optional Gemini API calls.
Can I sync event updates from Sheets to Google Calendar? +
Yes. When rows are synced, a unique Google Calendar Event ID is saved in a designated Event ID column. If you edit a row and sync again, the add-on detects the ID and updates the existing event instead of creating duplicates.