recipe-create-events-from-sheet

$npx mdskill add googleworkspace/cli/recipe-create-events-from-sheet

Read event data from a sheet and create Google Calendar entries.

  • Automates bulk creation of calendar events from spreadsheet rows.
  • Depends on gws-sheets and gws-calendar skills.
  • Reads rows from a specified sheet range and maps them to events.
  • Inserts each row as a new event in Google Calendar.

SKILL.md

.github/skills/recipe-create-events-from-sheetView on GitHub ↗
---
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 [email protected] --attendee [email protected]`

More from googleworkspace/cli

SkillDescription
gws-admin-reportsGoogle Workspace Admin SDK: Audit logs and usage reports.
gws-calendarGoogle Calendar: Manage calendars and events.
gws-calendar-agendaGoogle Calendar: Show upcoming events across all calendars.
gws-calendar-insertGoogle Calendar: Create a new event.
gws-chatGoogle Chat: Manage Chat spaces and messages.
gws-chat-sendGoogle Chat: Send a message to a space.
gws-classroomGoogle Classroom: Manage classes, rosters, and coursework.
gws-docsRead and write Google Docs.
gws-docs-writeGoogle Docs: Append text to a document.
gws-driveGoogle Drive: Manage files, folders, and shared drives.