Recipe Create Events From Sheet
Bulk-create Google Calendar events from rows in a Google Sheet using the `gws` CLI without writing custom Apps Script.
Overview
recipe-create-events-from-sheet is an agent skill for the Build phase that reads Google Sheets rows and creates matching Google Calendar events via the `gws` CLI.
Install
npx skills add https://github.com/googleworkspace/cli --skill recipe-create-events-from-sheetWhat is this skill?
- Two-step recipe: read a range from Sheets then insert one Calendar event per row
- Depends on prerequisite skills `gws-sheets` and `gws-calendar` plus the `gws` binary
- Documents concrete CLI flags for summary, start/end ISO times, and multiple `--attendee` emails
- Example range `Events!A2:D` for tabular event columns
- Packaged as an OpenClaw recipe (metadata version 0.22.5) in the productivity domain
- 2 prerequisite skills: gws-sheets and gws-calendar
- 2 documented recipe steps (read sheet, insert events)
Adoption & trust: 15.4k installs on skills.sh; 26.9k GitHub stars; 2/3 security scanners passed (skills.sh audits).
What problem does it solve?
You maintain events in a Google Sheet but still create calendar invites one row at a time by hand.
Who is it for?
Indie operators who standardize on `gws` recipes and already model events as tabular Sheet data with stable IDs and ISO datetimes.
Skip if: Teams without the `gws` CLI, without `gws-sheets`/`gws-calendar` loaded, or who need bi-directional sync, recurrence rules, or conflict detection beyond this linear recipe.
When should I use this skill?
You need to read event data from a Google Sheets spreadsheet and create Google Calendar entries for each row using `gws`.
What do I get? / Deliverables
Each sheet row becomes a Calendar event created with documented `gws sheets +read` and `gws calendar +insert` commands after the Sheets and Calendar skills are loaded.
- Google Calendar events created per sheet row
- Agent-executed CLI command sequence documented in the recipe
Recommended Skills
Journey fit
This recipe wires two Google Workspace APIs together during product build when teams automate scheduling from spreadsheet source-of-truth data. Integrations subphase fits chained `gws sheets +read` and `gws calendar +insert` commands that connect Sheets to Calendar.
How it compares
Use this focused recipe instead of a one-off Apps Script when you want agent-executable, skill-chained CLI steps documented in SKILL.md.
Common Questions / FAQ
Who is recipe-create-events-from-sheet for?
Solo builders and small teams automating Google Workspace with the `gws` tool who store event metadata in Sheets and want agent-guided batch calendar creation.
When should I use recipe-create-events-from-sheet?
During Build integrations when a spreadsheet is the source of truth for sessions or meetings; after `gws-sheets` and `gws-calendar` are loaded and you have a spreadsheet ID and range like `Events!A2:D`.
Is recipe-create-events-from-sheet safe to install?
It orchestrates Google API access through your local `gws` setup; review the Security Audits panel on this page and scope OAuth tokens to the calendars and sheets you intend to modify.
Workflow Chain
Requires first: gws sheets, gws calendar
SKILL.md
READMESKILL.md - Recipe Create Events From Sheet
# 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`