Create Google Calendar events from Sheets with AI
Turn confirmed rows in a schedule into separate events, with the time and attendees checked for each row.
To create Google Calendar events from Sheets with AI, point recipe-create-events-from-sheet at the range containing the agreed schedule. The agent reads the selected cells and creates an event for each entry. A training programme with different presenters and session lengths is a better fit for this approach than treating every date as one identical meeting.
Decide how your time columns should be interpreted before creating anything. The Calendar helper passes on the timestamps it receives. Supply an explicit time offset for each start and end, then inspect an initial event in the calendar before asking the agent to create the rest.
What it does
- Read only the rows containing confirmed sessions
- Map a row's title to a calendar event
- Set a distinct beginning and end for each session
- Include the guests associated with a particular row
- Check a first booking before processing the remaining rows
Install and use
- Install the recipe, gws and its Sheets and Calendar companions. Connect an account that can read the schedule and write to the target calendar.
- Ask “Read the confirmed rows for the induction programme. Show me the title, attendees and times with offsets for each session before creating it.”
- Inspect one resulting event. If a previous attempt stopped partway through, identify the rows that still need a booking.
FAQ
Source
Made by Google Workspace CLI contributors. Original skill: recipe-create-events-from-sheet, published on GitHub under the Apache-2.0 licence.
View on GitHub