Methodologygeneric
calendar-automation
Google Calendar and Outlook automation - scheduling optimization, meeting workflows, time blocking, and Slack/Sheets integration
claude-office-skills/skills
Install
Use with your agent
Install the calendar-automation skill, then use it as build context. Run: npx skills add https://github.com/claude-office-skills/skills --skill calendar-automation. Then read the installed skill.md and follow its guidance to build or refactor my project.
Calendar Automation
Automate Google Calendar and Outlook workflows for meeting management, time blocking, daily digests, and cross-platform synchronization. Based on n8n workflow templates.
Overview
This skill covers:
- Meeting scheduling automation
- Time blocking strategies
- Daily calendar digests to Slack
- Meeting prep reminders
- Calendar analytics
Core Workflows
1. Daily Calendar Digest to Slack
workflow: "Morning Calendar Briefing"
schedule: "6:00 AM daily"
steps:
1. get_today_events:
calendar: primary
time_min: today_start
time_max: today_end
2. categorize_events:
categories:
meetings: has_attendees == true
focus_time: title contains "Focus" OR "Deep Work"
one_on_ones: title contains "1:1" OR "1-on-1"
interviews: title contains "Interview"
3. calculate_stats:
total_meetings: count(meetings)
total_hours: sum(duration)
free_time: 8 - total_hours
back_to_back: count(gap < 15min)
4. format_message:
template: |
βοΈ *Good morning! Here's your day:*
π
*{date}*
*Schedule Overview:*
β’ {total_meetings} meetings ({total_hours}h)
β’ {free_time}h of free time
β’ {back_to_back} back-to-back slots β οΈ
*Today's Events:*
{event_list}
π‘ *Tip:* {daily_tip}
5. send_to_slack:
channel: "#daily-schedule" or DM
6. log_to_sheets:
spreadsheet: "Calendar Analytics"
data: [date, meetings, hours, categories]
Event List Format:
β’ 9:00 AM - Team Standup (15m) π Zoom
β’ 10:00 AM - 1:1 with Sarah (30m) π₯
β’ 11:00 AM - Focus Time (2h) π§
β’ 2:00 PM - Client Call (1h) π€ Google Meet
β’ 4:00 PM - Interview - PM Role (45m) π―
2. Meeting Prep Automation
workflow: "Meeting Preparation"
trigger:
type: calendar_event
time: 1_hour_before_meeting
filter: has_attendees AND duration >= 30min
steps:
1. get_meeting_details:
extract: [title, attendees, description, meeting_link]
2. research_attendees:
for_each: attendee
actions:
- linkedin_lookup: get_title_company
- crm_lookup: get_past_interactions
- email_search: recent_threads
3. generate_prep_doc:
template: |
# Meeting Prep: {title}
**Time:** {start_time}
**Duration:** {duration}
**Link:** {meeting_link}
## Attendees
{attendee_profiles}
## Context
- Last interaction: {last_meeting_date}
- Open items: {open_tasks}
- Recent emails: {email_summary}
## Suggested Agenda
{ai_suggested_agenda}
## Talking Points
{ai_talking_points}
4. send_reminder:
slack_dm:
message: |
β° Meeting in 1 hour: *{title}*
π [Prep Doc]({prep_doc_link})
π [Join Meeting]({meeting_link})
Quick context: {one_line_summary}
3. Smart Time Blocking
workflow: "Auto Time Blocking"
schedule: "Sunday 8pm" # Plan for next week
steps:
1. analyze_calendar:
range: next_7_days
identify:
- existing_meetings
- recurring_meetings
- available_slots
2. get_priorities:
source: [todoist, asana, notion]
filter: due_this_week AND high_priority
3. allocate_focus_time:
rules:
- morning_block: 9-11am (deep work)
- afternoon_block: 2-4pm (collaborative)
- minimum_gap: 15min between meetings
- max_meetings_per_day: 5
4. create_blocks:
types:
deep_work:
duration: 2h
frequency: daily
preferred_time: 9-11am
color: blue
admin_time:
duration: 1h
frequency: daily
preferred_time: 4-5pm
color: gray
buffer:
duration: 15min
after: external_meetings
color: yellow
5. notify:
slack: "β
Weekly time blocks created. {x} hours of focus time protected."
4. Calendly β Calendar + CRM
workflow: "Calendly Booking Handler"
trigger:
type: calendly
event: booking_created
steps:
1. get_booking_details:
extract: [invitee, event_type, scheduled_time, answers]
2. enrich_contact:
clearbit: lookup_by_email
linkedin: get_profile
3. create_calendar_event:
google_calendar:
title: "{event_type} with {invitee_name}"
time: scheduled_time
description: |
**Booked via Calendly**
Name: {invitee_name}
Email: {invitee_email}
Company: {company}
**Pre-meeting questions:**
{calendly_answers}
attendees: [invitee_email, owner_email]
reminders: [1_day, 1_hour, 15_min]
4. update_crm:
hubspot:
create_or_update_contact:
email: invitee_email
properties:
last_meeting_booked: scheduled_time
meeting_type: event_type
create_engagement:
type: MEETING
timestamp: scheduled_time
5. send_confirmation:
email:
to: invitee_email
template: meeting_confirmation
include: [calendar_invite, prep_questions]
6. notify_slack:
channel: "#meetings"
message: "π
New booking: {event_type} with {invitee_name} on {date}"
5. Calendar Analytics
analytics_workflow:
name: "Weekly Calendar Report"
schedule: "Friday 5pm"
metrics:
time_distribution:
- meetings_total_hours
- focus_time_hours
- admin_time_hours
- 1on1_time_hours
meeting_quality:
- avg_meeting_length
- back_to_back_count
- meetings_with_agenda
- external_vs_internal
productivity:
- longest_focus_block
- fragmentation_score
- after_hours_meetings
output:
format: markdown
destinations: [slack, google_sheets]
report_template: |
# π Weekly Calendar Analytics
## Time Distribution
| Category | Hours | % of Week |
|----------|-------|-----------|
| Meetings | {meetings_hours} | {meetings_pct}% |
| Focus Time | {focus_hours} | {focus_pct}% |
| Admin | {admin_hours} | {admin_pct}% |
| Available | {available_hours} | {available_pct}% |
## Meeting Insights
- Total meetings: {total_meetings}
- Average length: {avg_length} min
- Back-to-back: {b2b_count} ({b2b_pct}%)
- With agenda: {agenda_pct}%
## Productivity Score
π― **{productivity_score}/100**
- Longest focus block: {longest_focus}
- Meeting fragmentation: {fragmentation}
- After-hours: {after_hours_count}
## Recommendations
{ai_recommendations}
Time Blocking Templates
Maker Schedule (Individual Contributor)
βββββββββββββββββββββββββββββββββββββββ
β 9:00 - 11:00 β Deep Work Block 1 β
βββββββββββββββββββββββββββββββββββββββ€
β 11:00 - 11:30 β Email/Slack β
βββββββββββββββββββββββββββββββββββββββ€
β 11:30 - 12:30 β Meetings Window β
βββββββββββββββββββββββββββββββββββββββ€
β 12:30 - 1:30 β Lunch β
βββββββββββββββββββββββββββββββββββββββ€
β 1:30 - 3:30 β Deep Work Block 2 β
βββββββββββββββββββββββββββββββββββββββ€
β 3:30 - 4:00 β Buffer/Admin β
βββββββββββββββββββββββββββββββββββββββ€
β 4:00 - 5:00 β Meetings Window β
βββββββββββββββββββββββββββββββββββββββ€
β 5:00 - 5:30 β Daily Wrap-up β
βββββββββββββββββββββββββββββββββββββββ
Manager Schedule
βββββββββββββββββββββββββββββββββββββββ
β 8:00 - 8:30 β Daily Planning β
βββββββββββββββββββββββββββββββββββββββ€
β 8:30 - 9:00 β Team Standup β
βββββββββββββββββββββββββββββββββββββββ€
β 9:00 - 12:00 β 1:1s / Meetings β
βββββββββββββββββββββββββββββββββββββββ€
β 12:00 - 1:00 β Lunch β
βββββββββββββββββββββββββββββββββββββββ€
β 1:00 - 2:00 β Focus Time β
βββββββββββββββββββββββββββββββββββββββ€
β 2:00 - 5:00 β Meetings β
βββββββββββββββββββββββββββββββββββββββ€
β 5:00 - 5:30 β Email/Wrap-up β
βββββββββββββββββββββββββββββββββββββββ
Output Example
Request: "Set up daily calendar digest for my Slack"
Output:
# Daily Calendar Digest Setup
## Workflow Configuration
```yaml
name: "Morning Calendar Briefing"
schedule: "6:00 AM weekdays"
timezone: "Asia/Shanghai"
trigger:
type: cron
expression: "0 6 * * 1-5"
actions:
1. fetch_events:
calendar: primary
date: today
2. send_slack:
channel: "@you" # or #your-channel
Sample Output
βοΈ Good morning! Here's your Thursday:
π
January 30, 2026
ββββββββββββββββββββββ
π Overview:
β’ 5 meetings (4.5h)
β’ 3.5h free time
β’ 1 back-to-back warning β οΈ
ββββββββββββββββββββββ
ποΈ Schedule:
9:00 AM β Team Standup (15m)
β π Google Meet
β
10:00 AM β 1:1 with Sarah (30m)
β π₯ Conference Room B
β
11:00 AM β π§ Focus Time (2h)
β
1:00 PM β Lunch
β
2:00 PM β Client Call - Acme (1h)
β π€ Zoom (link attached)
β
3:30 PM β Product Review (1h)
β π Agenda attached
β
5:00 PM β β
Day ends
ββββββββββββββββββββββ
π‘ Tip: You have 2h of focus time - tackle your highest priority task!
n8n Setup Instructions
- Create new workflow
- Add Schedule Trigger node (6am weekdays)
- Add Google Calendar node (Get Events)
- Add Code node (format message)
- Add Slack node (send message)
- Activate workflow
Would you like me to generate the full n8n workflow JSON?
---
*Calendar Automation Skill - Part of Claude Office Skills*