recipe-create-events-from-sheet

Read Google Sheets rows and create Google Calendar events per row.

8|1|Updated Mar 5, 2026
One-click install
npx skills add https://github.com/niclasmartinsson-sys/google-workspace-cli --skill recipe-create-events-from-sheet-niclasmartinsson-sys
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: recipe-create-events-from-sheet
Source: https://github.com/niclasmartinsson-sys/google-workspace-cli/tree/main/skills/recipe-create-events-from-sheet
Command: npx skills add https://github.com/niclasmartinsson-sys/google-workspace-cli --skill recipe-create-events-from-sheet-niclasmartinsson-sys

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Read event data from a Google Sheets spreadsheet and automatically create corresponding Google Calendar entries, saving time and reducing manual data entry.

Core Features & Use Cases

  • Reads sheet rows and maps columns to event fields (title, start time, end time, attendees).
  • Creates a calendar event for each row with the mapped fields.
  • Supports simple validation and error reporting for malformed rows.

Quick Start

Load the skills gws-sheets and gws-calendar, then run the recipe to convert your sheet data into calendar events.

Frequently Asked Questions about recipe-create-events-from-sheet

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I create Google Calendar events from Google Sheets data?

You can create Google Calendar events from Google Sheets by loading this workflow alongside the gws-sheets and gws-calendar skills. It automatically reads each spreadsheet row, maps columns to event fields like title and time, and creates corresponding calendar entries.

Can I map Google Sheets columns to specific Google Calendar event fields like attendees?

Yes, mapping Google Sheets columns to Google Calendar event fields is supported natively. The workflow maps your specified columns to event properties such as title, start time, end time, and attendees for each row processed within the sheet's defined range.

What do I need to automate Google Calendar event creation from a spreadsheet?

To automate Google Calendar event creation from a spreadsheet, you need Google account access to Google Sheets and Calendar, plus the gws-sheets and gws-calendar skills loaded. This environment allows the recipe to execute end-to-end.

How does the workflow handle malformed rows or invalid event data in Google Sheets?

The workflow handles malformed rows in Google Sheets by providing simple validation and error reporting during row processing. It identifies invalid event data before attempting to create the Google Calendar entry, ensuring accurate data mapping.

Does this automation process every row in my Google Sheets spreadsheet?

Yes, this automation processes every row in your Google Sheets spreadsheet by iterating per-row within the defined sheet range. It maps each row's data to calendar event fields and creates a distinct Google Calendar entry for each one.