recipe-create-events-from-sheet

Compare original and translation side by side

🇺🇸

Original

English

🇨🇳

Chinese

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.

前提条件： 加载以下技能以执行此方案：
gws-sheets
,
gws-calendar

从Google Sheets电子表格中读取活动数据，并为每一行创建Google Calendar日程条目。

Read event data:

gws sheets +read --spreadsheet-id SHEET_ID --range 'Events!A2:D'

For each row, create a calendar event:

gws calendar +insert --summary 'Team Standup' --start '2025-01-20T09:00' --duration 30 --attendees alice@company.com,bob@company.com

读取活动数据：

gws sheets +read --spreadsheet-id SHEET_ID --range 'Events!A2:D'

为每一行创建日历活动：

gws calendar +insert --summary 'Team Standup' --start '2025-01-20T09:00' --duration 30 --attendees alice@company.com,bob@company.com