Skip to content
Skillpedia
Automations32k · #6313

recipe-create-events-from-sheet

Lets the agent read event data from a spreadsheet and create Google Calendar entries. Ideal for automatically managing appointments.

What it does

This tool reads event information from a Google Sheet and creates events in your Google Calendar. It's like copying and pasting events from a list into your calendar.

When to use it

  • ✓When you have a list of appointments in a spreadsheet.
  • ✓To add multiple events to your calendar at once.
  • ✓When organizing an event with multiple people and the details are in a table.

Example of what to ask your AI

“Create calendar events from the 'Weekly Events' sheet in the 'Appointments' tab, using columns A, B, C, and D.”

Want more? Open the sections below.

How to use

The easiest way: copy the message below and paste it into Claude, ChatGPT, Cursor or any AI. It reads the skill and follows the instructions.

Skill link

https://github.com/googleworkspace/cli/blob/main/skills/recipe-create-events-from-sheet/SKILL.md

Ready-to-paste message

Use this skill to help me: https://github.com/googleworkspace/cli/blob/main/skills/recipe-create-events-from-sheet/SKILL.md Read the SKILL.md file at that link and follow its instructions for my task.
How it works

The tool first reads the data from your Google Sheet. Then, for each row containing event information, it creates a new event in your Google Calendar with the provided details.

Installation

Easiest way: copy the skill link and paste it into Claude, ChatGPT or Cursor asking it to follow the instructions.

In the terminal (Claude Code, Codex, Cursor), in your project folder:

npx skills add googleworkspace/cli --skill recipe-create-events-from-sheet

Or download just the file:

curl -L https://raw.githubusercontent.com/googleworkspace/cli/main/skills/recipe-create-events-from-sheet/SKILL.md -o SKILL.md
Technical content (original SKILL.md)

Original text by the author, straight from GitHub.

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
FAQ

Do I need to have Google Sheets and Calendar?

Yes, you need access to Google Sheets for the spreadsheet and Google Calendar for the tool to create events.

What information does the spreadsheet need?

The spreadsheet needs columns with the event name, start date and time, end date and time, and attendee emails.

Can I add more details to the events?

The tool uses the information you already have in the spreadsheet. If you want to add more details, you'll need to include them in the spreadsheet columns before using the tool.

Details

Original description by the author

Read event data from a Google Sheets spreadsheet and create Google Calendar entries for each row.

repo: googleworkspace/cli

Popularity

GitHub stars
32k
Ranking position
#6313
License
Apache-2.0
Updated
10/6/2026

Is this skill useful?

0

Sign in to vote.

Comments

  • …

More skills from this repository

Similar skills