"Read event data from a Google Sheets spreadsheet and create Google Calendar entries for each row."
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
- 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 alice@company.com --attendee bob@company.com
You Might Also Like
Related Skills
revops
When the user wants help with revenue operations, lead lifecycle management, or marketing-to-sales handoff processes. Also use when the user mentions 'RevOps,' 'revenue operations,' 'lead scoring,' 'lead routing,' 'MQL,' 'SQL,' 'pipeline stages,' 'deal desk,' 'CRM automation,' 'marketing-to-sales handoff,' 'data hygiene,' 'leads aren't getting to sales,' 'pipeline management,' 'lead qualification,' or 'when should marketing hand off to sales.' Use this for anything involving the systems and processes that connect marketing to revenue. For cold outreach emails, see cold-email. For email drip campaigns, see emails. For pricing decisions, see pricing.
coreyhaines31
recipe-block-focus-time
Create recurring focus time blocks on Google Calendar to protect deep work hours.
googleworkspacerecipe-create-task-list
Set up a new Google Tasks list with initial tasks.
googleworkspacerecipe-share-doc-and-notify
Share a Google Docs document with edit access and email collaborators the link.
googleworkspacerecipe-schedule-recurring-event
Create a recurring Google Calendar event with attendees.
googleworkspacerecipe-find-large-files
Identify large Google Drive files consuming storage quota.
googleworkspace