Skills Productivity Sheet To Calendar Events

Sheet To Calendar Events

v20260401
recipe-create-events-from-sheet
Automates reading event rows from Google Sheets and inserting matching Google Calendar entries via gws commands, keeping schedules synced from a single spreadsheet.
Get Skill
264 downloads
Overview

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.

Steps

  1. Read event data: gws sheets +read --spreadsheet SHEET_ID --range "Events!A2:D"
  2. 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
Info
Category Productivity
Name recipe-create-events-from-sheet
Version v20260401
Size 892B
Updated At 2026-04-08
Language