Recipe Create Events From Sheet
googleworkspace/cliThis skill enables users to automate the creation of Google Calendar events by extracting event details from a Google Sheets spreadsheet. It supports reading data from sheets and programmatically adding corresponding calendar entries with specified details like time, attendees, and summaries. This is ideal for productivity-focused individuals and teams seeking to streamline scheduling processes via scripting or automation.
Create Google Calendar Events from a Sheet
PREREQUISITE: Load the following skills to execute this recipe:
gws-sheets,gws-calendarRead 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
GitHub Owner
Owner: googleworkspace
GitHub Links
- Website: https://developers.google.com/workspace
- Twitter: https://twitter.com/workspacedevs
SKILL.md
name: recipe-create-events-from-sheet version: 1.0.0 description: "Read event data from a Google Sheets spreadsheet and create Google Calendar entries for each row." metadata: 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-calendarRead 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