Recipe Create Events From Sheet

by googleworkspacea3768d0e82adNo license31K starsListed Oct 8, 2026Updated Oct 8, 2026Repository updated yesterday

Read event data from a Google Sheets spreadsheet and create Google Calendar entries for each row.

AI-generated overview

Reads event rows from a Google Sheets spreadsheet and creates a Google Calendar entry for each row.

What it does: This recipe reads event data from a Google Sheets range and creates a Google Calendar event for each row. It relies on the gws command-line tool and the gws-sheets and gws-calendar skills, using a sheets read command followed by calendar insert commands with summary, start, end and attendee values. It ships no scripts; it is an instruction-only recipe.
When to use it: Use it when event details already live in a Google Sheets spreadsheet and need to be turned into individual Google Calendar entries. It suits bulk scheduling from a tabular list of events, times and attendees.
Requirements: The gws command-line tool must be available, along with the gws-sheets and gws-calendar skills. It needs access to Google Sheets and Google Calendar, including a spreadsheet ID and calendar permissions. No scripts are included.

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.

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 [email protected] --attendee [email protected]

License: No license

Content belongs to its original authors. SourceWeft indexes it from a public repository.