---
id: ssh2-recipe-create-events-from-sheet
name: "recipe-create-events-from-sheet"
url: https://skills.yangsir.net/skill/ssh2-recipe-create-events-from-sheet
author: googleworkspace
domain: automation
tags: ["google-sheets", "google-calendar", "event-creation", "data-driven-events", "workflow-automation"]
install_count: 14600
rating: 4.50 (144 reviews)
github: https://github.com/googleworkspace/cli
---

# recipe-create-events-from-sheet

> 从Google Sheets读取事件数据，并为每行创建Google Calendar条目。

**Stats**: 14,600 installs · 4.5/5 (144 reviews)

## Before / After 对比

### 批量创建日历事件，简化日程管理。

## Readme

# Create Google Calendar Events from a Sheet

> **PREREQUISITE:** Load the following skills to execute this recipe: `gws-sheets`, `gws-calendar`

Read event data from a Google Sheets spreadsheet and create Google Calendar entries for each row.

## Steps

1. Read event data: `gws sheets +read --spreadsheet SHEET_ID --range "Events!A2:D"`
2. For each row, create a calendar event: `gws calendar +insert --summary 'Team Standup' --start '2026-01-20T09:00:00' --end '2026-01-20T09:30:00' --attendee alice@company.com --attendee bob@company.com`



---
*Source: https://skills.yangsir.net/skill/ssh2-recipe-create-events-from-sheet*
*Markdown mirror: https://skills.yangsir.net/api/skill/ssh2-recipe-create-events-from-sheet/markdown*