recipe-create-events-from-sheet

googleworkspace/cli

Bulk-create Google Calendar events from spreadsheet rows.

What is recipe-create-events-from-sheet?

This recipe reads event data from a Google Sheets spreadsheet and automatically creates corresponding Google Calendar entries. Use it to populate your calendar from a structured data source, such as importing a list of meetings, deadlines, or team events.

Read event data from specified Google Sheets range
Parse row data into calendar event details
Create Google Calendar entries with summary, start time, and end time
Add attendees to calendar events
Process multiple rows in batch

How to install recipe-create-events-from-sheet

npx skills add null --skill recipe-create-events-from-sheet

Prerequisites

gws-sheets skill installed
gws-calendar skill installed
Google Workspace account with Sheets and Calendar access
Spreadsheet with event data in columns (summary, start time, end time, attendees)

Claude Code

Cursor

Windsurf

Cline

How to use recipe-create-events-from-sheet

1.Prepare a Google Sheet with event data in columns (e.g., summary in column A, start time in B, end time in C, attendees in D)
2.Use gws sheets +read to fetch the data range from your spreadsheet
3.For each row returned, use gws calendar +insert with the corresponding values to create the calendar event
4.Specify attendee email addresses using multiple --attendee flags as needed

Use cases

Good for

Import a list of team meetings from a spreadsheet into Google Calendar
Bulk-create recurring event instances from a planning sheet
Populate a calendar with deadlines and milestones tracked in a sheet
Create calendar entries for conference sessions or event schedules stored in a spreadsheet

Who it's for

Project managers coordinating team schedules
Event organizers managing multiple calendar entries
Teams using sheets for event planning and scheduling
Anyone needing to sync spreadsheet data to Google Calendar

recipe-create-events-from-sheet FAQ

What columns should my spreadsheet have?

At minimum: event summary/title, start datetime, and end datetime. You can also include attendee email addresses in additional columns.

What datetime format does the calendar command expect?

Use ISO 8601 format: YYYY-MM-DDTHH:MM:SS (e.g., 2026-01-20T09:00:00).

Can I add multiple attendees to each event?

Yes, use multiple --attendee flags for each email address you want to invite.

Do I need to manually run this for each row?

The recipe shows the individual steps; you can automate this by looping through the sheet results and calling the calendar insert command for each row.

Full instructions (SKILL.md)

Source of truth, from googleworkspace/cli.

name: recipe-create-events-from-sheet description: "Read event data from a Google Sheets spreadsheet and create Google Calendar entries for each row." metadata: version: 0.22.5 openclaw: category: "recipe" domain: "productivity" requires: bins: - gws skills: - gws-sheets - gws-calendar

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