googleworkspace avatar

Recipe Create Events From Sheet

Takes rows from a Google Sheets spreadsheet and turns each one into a Google Calendar event, assuming your columns contain event details like title, start time, end time, and attendees. Perfect when you're planning conferences, team events, or recurring meetings and want to bulk-create calendar entries instead of clicking through the UI dozens of times. The real win is for event coordinators who maintain master schedules in spreadsheets but need everyone to have proper calendar invites. Does require setting up the prerequisite Google Workspace skills first, but once configured it's a straightforward two-step process of reading the sheet data then looping through to create each event.

skills.sh installs
30.7K
GitHub stars
32.2K
last updated
Aug 21, 2026

Install

$ npx -y skills add googleworkspace/cli --skill recipe-create-events-from-sheet --agent claude-code

Installs into .claude/skills of the current project.

Files

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

Sponsors

Details

Repository
github.com/googleworkspace/cli
Categories
CLI & Terminal, Office & Documents

More from googleworkspace/cli

All 113
1googleworkspace avatarrecipe-create-vacation-respondergoogleworkspace/cliEnable a Gmail out-of-office auto-reply with a custom message and date range.30.7Kskills.sh installs
2googleworkspace avatarrecipe-share-folder-with-teamgoogleworkspace/cliShare a Google Drive folder and all its contents with a list of collaborators.30.7Kskills.sh installs
3googleworkspace avatarpersona-customer-supportgoogleworkspace/cliManage customer support — track tickets, respond, escalate issues.30.7Kskills.sh installs
4googleworkspace avatarrecipe-forward-labeled-emailsgoogleworkspace/cliFind Gmail messages with a specific label and forward them to another address.30.7Kskills.sh installs
5googleworkspace avatarpersona-event-coordinatorgoogleworkspace/cliPlan and manage events — scheduling, invitations, and logistics.30.6Kskills.sh installs
6googleworkspace avatargws-modelarmorgoogleworkspace/cliGoogle Model Armor: Filter user-generated content for safety.30.6Kskills.sh installs