recipe-create-events-from-sheet
Installation
Summary
Bulk-create Google Calendar events from spreadsheet rows using a two-step workflow.
- Reads event data directly from Google Sheets ranges, extracting summary, start time, end time, and attendee information
- Creates calendar entries via the
gws-calendarskill with support for multiple attendees and custom time ranges - Requires both
gws-sheetsandgws-calendarskills to be loaded before execution
SKILL.md
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
- Read event data:
gws sheets +read --spreadsheet SHEET_ID --range "Events!A2:D" - 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
Related skills
More from googleworkspace/cli
gws-gmail
Gmail: Send, read, and manage email.
26.2Kgws-docs
Read and write Google Docs.
26.1Kgws-drive
Google Drive: Manage files, folders, and shared drives.
26.0Kgws-sheets
Google Sheets: Read and write spreadsheets.
24.7Kgws-calendar
Google Calendar: Manage calendars and events.
24.6Kgws-docs-write
Google Docs: Append text to a document.
21.8K