What This Workflow Does
This automation solves the common problem of meeting coordination overhead. Professionals waste significant time each week manually checking calendars, compiling meeting lists, and sending preview emails to teams. Our workflow eliminates this repetitive task by automatically generating and sending a formatted weekly meeting schedule directly from Google Calendar to Gmail.
The system pulls all upcoming meetings for the specified time period (typically the next 7 days), formats them into an easy-to-scan email template, and sends it to designated recipients at your preferred time. This ensures everyone has visibility into the week's commitments without manual calendar checks or last-minute scheduling surprises.
How It Works
1. Calendar Event Retrieval
The workflow connects to your Google Calendar account and retrieves all events within your specified date range. It can filter by calendar, event type, or other criteria you define.
2. Data Formatting
Retrieved events are processed into a clean, standardized format. The system extracts key details like meeting titles, times, participants, and locations while applying your preferred formatting rules.
3. Email Composition
The workflow generates a professional email using your template design. It can include your logo, branding colors, and standard sections like "Important Meetings" or "Action Required" based on event labels.
4. Scheduled Delivery
The completed email is sent via your Gmail account at your chosen time (typically Friday afternoon or Monday morning). Recipients receive a consistent, well-formatted preview of their upcoming week.
Pro tip: Set up separate workflows for different departments or teams with customized templates that highlight the information most relevant to each group.
Who This Is For
This automation benefits anyone who manages multiple weekly meetings, including:
- Executives and their assistants coordinating complex schedules
- Team leaders managing department meetings
- Project managers overseeing cross-functional collaborations
- Remote teams across different time zones
- Consultants managing multiple client calendars
What You'll Need
- A self-hosted n8n instance (this workflow uses community nodes)
- Google Calendar with scheduled meetings
- Gmail account for sending the preview emails
- Basic understanding of n8n workflow configuration
Quick Setup Guide
- Download the JSON template file
- Import it into your n8n instance
- Connect your Google Calendar and Gmail accounts
- Configure your preferred date range and email recipients
- Set your scheduling preferences (day/time for sending)
- Test with a small date range before going live
Key Benefits
Save 2-3 hours weekly by eliminating manual calendar checks and email composition. The automation handles this repetitive task perfectly every time.
Improve meeting attendance with consistent, professional previews that help participants plan their week effectively.
Reduce scheduling conflicts by giving everyone advance notice of important commitments and deadlines.
Maintain brand consistency with professionally formatted emails that reflect your organization's standards.
Customize for different audiences by creating multiple workflow versions tailored to executives, teams, or clients.