recipe-create-events-from-sheet

What This Skill Does

The recipe-create-events-from-sheet skill is a powerful automation tool designed to bridge the gap between static spreadsheet data and dynamic scheduling. By leveraging the Google Workspace suite, this skill reads structured event information from a specified Google Sheet and automatically generates corresponding entries in your Google Calendar. Instead of manually inputting meeting details, attendees, and time slots, this skill processes entire datasets in a single execution flow. It utilizes the gws-sheets skill to fetch data from defined ranges and the gws-calendar skill to handle event creation, effectively automating your scheduling workflow.

Installation

To install this skill, use the following command in your OpenClaw terminal: clawhub install openclaw/skills/skills/googleworkspace-bot/recipe-create-events-from-sheet

Note: Before running, ensure you have authenticated your Google account via the gws-sheets and gws-calendar modules. You will need the Spreadsheet ID of your target sheet to proceed.

Use Cases

This skill is ideal for professionals and teams who maintain event schedules in spreadsheets. Examples include:

• Event Planning: Organizing workshops or seminars by maintaining a master attendee list in a sheet and pushing it to the calendar.
• Project Management: Syncing project milestones and team stand-up meetings from a tracking sheet to the company-wide calendar.
• Academic Scheduling: Teachers or administrators managing class rotations or guest speaker sessions.

Example Prompts

1. "OpenClaw, read the events from my 'Upcoming Q1 Events' spreadsheet and create calendar entries for everything scheduled for next week."
2. "Use the data in my 'Team Meetings' sheet to populate my Google Calendar with the stand-up sessions for the rest of the month."
3. "Sync the event details from sheet ID 1abc12345 to my work calendar, ensuring all attendees listed in the spreadsheet receive an invite."

Tips & Limitations

• Data Structure: Ensure your Google Sheet is formatted correctly with headers (e.g., Summary, Start Time, Duration, Attendees) to allow the skill to map data points accurately.
• Rate Limits: Google Calendar has API request limits. Avoid using this skill on massive datasets (hundreds of rows) in a single request to prevent triggering rate limits.
• Prerequisites: This skill is a recipe; it will not function unless both the gws-sheets and gws-calendar skills are successfully installed and configured in your environment.