How to use the Create Calendar Events from a Sheet agent skill

What is an agent skill and what does this one do?

An agent skill is a folder containing a SKILL.md file that gives an AI agent instructions for a specific task. When the agent sees a request that matches the skill, it follows the recipe written in that file.

This skill, recipe-create-events-from-sheet, gives the agent a two-step recipe. First it reads event data from a Google Sheets spreadsheet. Then, for each row, it creates a Google Calendar entry. The event details it works with include titles, start and end times, and attendees.

• Reads rows from a spreadsheet you specify by its sheet ID and range.
• Creates one calendar event per row, with a summary, start time, end time and attendee list.
• Relies on the gws command-line tool, plus the gws-sheets and gws-calendar skills, to do the actual reading and creating.

What do you need before you install it?

The skill depends on several pieces. Check that you have all of them before you start, because the recipe will not run without them.

The skill is licensed under Apache-2.0. It runs scripts and uses the network, so it needs access to your Google account.

• The gws command-line tool, which is the binary named gws.
• The gws-sheets skill, which gives Google Sheets access.
• The gws-calendar skill, which gives Google Calendar access.
• Google account authorization for Sheets and Calendar through gws.

How do you install the skill?

Download the ZIP file for this skill from our page and unzip it. The skill is delivered as a folder that contains SKILL.md. Place that folder in one of the following locations.

For a personal install that works across your projects, put it in ~/.claude/skills/. For a single project, put it in the project's .claude/skills/ folder.

You can also upload the ZIP in the Claude apps. Open Settings, go to Capabilities, then go to Skills and upload the file there.

• Personal install: unzip into ~/.claude/skills/
• Project install: unzip into the project's .claude/skills/ folder
• Claude apps: Settings → Capabilities → Skills, then upload the ZIP

How do you trigger the skill with a natural request?

You do not need to type a command to use the skill. Describe what you want in plain language and mention the spreadsheet and the calendar. The agent will match your request to this recipe.

Be specific about the spreadsheet and the range of rows. Name the columns that hold titles, times and attendees if your sheet does not follow a standard layout, so the agent does not have to guess.

• "Create calendar events for every row in the Events tab of my workshop spreadsheet."
• "Read the team meeting list in this Google Sheet and add each meeting to my calendar."
• "Schedule everything in rows 2 to 20 of the batch sheet, with the attendees in column D."

What does the agent actually run?

The recipe uses two gws commands. The first reads the spreadsheet. The second creates one event, and the agent repeats it for each row.

The example below comes from the skill's own instructions. It shows the read command with a sheet ID and a range, and the insert command with a summary, start and end times, and two attendees. Replace the placeholder values with your own.

What should you check for safety?

This skill runs scripts and uses the network, and it writes to real calendars. Creating events can send invitations to attendees, and the source describes this as hard to undo cleanly. Treat each run as a live action.

Review the rows before you run the skill. Confirm that the dates and times are in a consistent format, since the recipe writes the times it reads. Messy or inconsistent date formats can produce wrong times in real calendars.

• Read through every row first, including attendee email addresses.
• Check that all start and end times use one consistent format.
• Run a small range first, such as two or three rows, before a large batch.
• Do not use the skill for one-off events. Typing a single event directly is faster and avoids mistakes.

What tips help the skill work well?

Keep the spreadsheet simple. A clean layout with one event per row, a header row, and consistent columns makes the agent's job more reliable.

Use a range that excludes the header. The example reads from row 2 onward, which skips a typical header row.

• Use one event per row and keep column meanings the same throughout the sheet.
• Start with a limited range and expand once the results look correct.
• Make sure gws is installed and authorized for Sheets and Calendar before you ask for a batch.