Skip to content
Get packs

Create Calendar Events from a Sheet

Turn rows of a Google Sheet into Google Calendar events using the gws CLI

Source Download skill
Repository
googleworkspace/cli
Stars
32,059
Licence
Apache-2.0
Files
1 file

What it does

This skill gives an AI agent a step-by-step recipe for reading event details (such as titles, start and end times, and attendees) from a Google Sheets spreadsheet and creating a matching Google Calendar entry for each row. It relies on the gws command-line tool to read the sheet and add the events. Once installed, you can ask the agent to schedule everything listed in a spreadsheet instead of entering each event by hand.

Great for

  • Teams that keep event schedules, workshop lists, or meeting batches in a shared spreadsheet
  • Operations staff who need to load many calendar invitations at once
  • People already using gws, gws-sheets and gws-calendar with an agent

Skip it if

  • One-off events, where typing them directly is faster and avoids mistakes
  • Spreadsheets with messy or inconsistent date formats, since wrong times would be written to real calendars and invitations would be sent to attendees
  • Situations where you have not reviewed the rows first, because creating events and inviting people is hard to undo cleanly

Try asking

  • “Create a calendar event for every row in my Events sheet (columns A to D)”
  • “Read the workshop schedule from this spreadsheet and add each session to my calendar with the listed attendees”
  • “Add all the team standups in the sheet to the calendar for next week”
Step-by-step guide: how to use Create Calendar Events from a SheetInstall, first run, examples, tips and FAQs

Install in 3 steps

  1. 1

    Download the skill

    The ZIP contains the 1 original files, the Apache-2.0 licence and an attribution note.

    recipe-create-events-from-sheet.zip
  2. 2

    Add it to your agent

    Claude Code (all projects)

    mkdir -p ~/.claude/skills && unzip recipe-create-events-from-sheet.zip -d ~/.claude/skills/

    Claude Code / Agent SDK (this project only)

    mkdir -p .claude/skills && unzip recipe-create-events-from-sheet.zip -d .claude/skills/

    Claude apps (web/desktop): Settings → Capabilities → Skills → Upload skill, and choose the ZIP.

  3. 3

    Ask for the task

    No special command needed — the agent reads the skill's description and loads it when your request matches. Try one of the prompts above.

Get better results

  • Check the sheet's column layout and date format before running, and make the agent show you the events it plans to create first
  • Start with a single test row or a test calendar so you can confirm times and attendees are correct before processing the full sheet
  • Be aware that adding attendees may send invitation emails to real people

What's inside

  • SKILL.md

Redistributed unmodified from googleworkspace/cli under the Apache-2.0 licence. The assessment was drafted with AI from the skill's files on 2026-10-29. Skills can instruct your agent to run code — read SKILL.md and any scripts before installing.