360 Secure SkillHub
360 安全技能中心

Recipe Create Events From Sheet

核心功能为对接谷歌表格与谷歌日历，读取指定表格区域的活动数据，为每一行批量创建对应日历事件。典型场景如批量生成团队会议、活动日程，替代手动录入提效。需依赖gws工具及gws-sheets、gws-calendar技能，输入需指定表格ID和数据范围，输出为创建好的日历事件。

googleworkspace-bot
googleworkspace-bot
热度 75.06
最近更新 2026-05-11 17:29:28
分类：自动化依赖：第三方 API应用场景：自动化脚本 / 任务管理 / 工作流

安装技能

复制下面的话术发给你的 Agent，它会通过 secure-skills 检索并安装该技能。

执行命令安装此 skill： npx secure-skills-cli add recipe-create-events-from-sheet
Metadata
name
recipe-create-events-from-sheet
description
Read event data from a Google Sheets spreadsheet and create Google Calendar entries for each row.
metadata
{"version":"0.22.5","openclaw":{"category":"recipe","domain":"productivity","requires":{"bins":["gws"],"skills":["gws-sheets","gws-calendar"]}}}

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