skills.rest
oresttokovenko
oresttokovenkoCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

recipe-create-events-from-sheet

Creates Google Calendar events from rows in a Google Sheets spreadsheet.

Updated Nov 9, 2023
Search Tags:#automation#productivity#google calendar#google sheets#recipe#gws#event creation
One-click install
npx skills add https://github.com/oresttokovenko/dot-files --skill recipe-create-events-from-sheet-oresttokovenko
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: recipe-create-events-from-sheet
Source: https://github.com/oresttokovenko/dot-files/tree/main/chezmoi/dot_agents/skills/recipe-create-events-from-sheet
Command: npx skills add https://github.com/oresttokovenko/dot-files --skill recipe-create-events-from-sheet-oresttokovenko

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve? Manually copying event details from a spreadsheet into a calendar is repetitive and error-prone. This recipe automates reading event rows from Google Sheets and inserting each one as a Google Calendar entry. ## Core Features & Use Cases - Sheet-to-Calendar Automation: Reads event data from a Google Sheets range and creates a calendar event per row. - Attendee Support: Adds attendees to each created calendar event via the gws CLI. - Use Case: A team lead maintains a schedule of meetings in a Google Sheet and wants every row turned into a Google Calendar invite with attendees, without manual entry. ## Quick Start Read the events from my Google Sheet and create a Google Calendar event for each row with the listed attendees.

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 a Google Sheet?▼

Read the event rows with gws sheets +read using the spreadsheet ID and range, then call gws calendar +insert for each row with summary, start, end, and attendee flags. This recipe automates that two-step loop.

How do I add attendees when creating a Google Calendar event from the command line?▼

Pass one --attendee flag per email address to gws calendar +insert, for example --attendee [email protected] --attendee [email protected]. Each attendee is added to the created event.

What tools are required to sync Google Sheets data to Google Calendar?▼

This recipe requires the gws CLI binary and two prerequisite skills: gws-sheets for reading spreadsheet ranges and gws-calendar for inserting events. All three must be available before running the recipe.

What spreadsheet format does the sheet-to-calendar recipe expect?▼

It reads a range such as Events!A2:D from the spreadsheet, where each row contains the event data used to build the calendar entry. The sheet ID and range are passed as parameters to the read command.

Why is the sheet-to-calendar recipe not creating events?▼

The most common cause is missing prerequisites: the gws binary must be installed and both gws-sheets and gws-calendar skills must be loaded. Also verify the spreadsheet ID and range point to rows containing valid event data.

Related Skills

Explore More Personal & Entrepreneur Skills→
cellarwoodcellarwood

recipe-create-feedback-form

Create Google Forms and email the responderUri to recipients.

Official
Basic
vikingokftvikingokft

persona-event-coordinator

Plan and manage events with scheduling, invitations, and logistics.

Official
Intermediate
cellarwoodcellarwood

recipe-create-events-from-sheet

Create Google Calendar events from Google Sheets spreadsheet rows.

Official
Intermediate
dimagidimagi
3

shutdown

Append structured evening shutdown and weekly close-out entries to journal files.

Official
Intermediate