recipe-create-events-from-sheet
Read event data from a Google Sheets spreadsheet and create Google Calendar entries for each row.
Security Assessment
About recipe-create-events-from-sheet
The `recipe-create-events-from-sheet` skill enables users to automatically generate Google Calendar events based on data stored in a Google Sheets spreadsheet. It addresses the common challenge of manually transferring event details from a spreadsheet into a calendar, saving time and reducing errors. By connecting Google Sheets and Google Calendar, this skill streamlines the workflow for teams, event planners, and individuals who frequently manage schedules in bulk. It ensures that all event information is accurately reflected in the calendar, including start and end times as well as attendees, directly from structured spreadsheet data.
This skill’s main capabilities include reading event data from a specified Google Sheets range and creating corresponding calendar events with detailed attributes such as event summary, start and end times, and attendee emails. It leverages existing skills (`gws-sheets` and `gws-calendar`) to interface with Google services securely and efficiently. Users can specify the spreadsheet ID and data range for input, allowing flexible integration with any pre-existing Sheets document. Events are created programmatically, supporting batch processing and consistent formatting across multiple entries.
Target users include project managers, team leads, HR personnel, and anyone responsible for scheduling recurring meetings or large sets of events. It is particularly useful in collaborative environments where event data is maintained in shared spreadsheets. Typical use cases include generating weekly team stand-ups, onboarding schedules, training sessions, and other recurring organizational events. By automating this process, users can minimize administrative overhead and focus on higher-level planning and coordination tasks.
FAQ
How do I use this skill to create calendar events from my spreadsheet?
First, ensure that both `gws-sheets` and `gws-calendar` skills are loaded. Then specify the spreadsheet ID and data range to read events from, and the skill will create corresponding Google Calendar entries for each row.
Which spreadsheet format or structure is required for this skill?
The spreadsheet should have event data organized in rows with columns including event summary, start time, end time, and attendees. The skill reads a specified range, such as `Events!A2:D`.
Can this skill handle multiple attendees for each event?
Yes, the skill supports multiple attendees by including each attendee's email address when creating the calendar event.
Are there any dependencies or prerequisites to use this skill?
Yes, you must have the `gws-sheets` and `gws-calendar` skills loaded, as these are required to read spreadsheet data and create calendar events.
Is this skill compatible with all Google Calendar accounts?
It is compatible with Google Calendar accounts accessible through the `gws-calendar` skill. Access permissions and account authentication may be required.
Install recipe-create-events-from-sheet
Quick Setup:
- Copy the skill folder to
.claude/skills/ - Claude will automatically detect and use the skill
Repository
googleworkspace/cli