Overview
Manually compiling weekly schedules wastes time and risks missing key events. This workflow automates fetching your Google Calendar events for the next 7 days, generates a clear daily summary with highlights, converts it to email-ready HTML, and sends it straight to your inbox—eliminating tedious prep and boosting readiness.
The Impact
- Eliminate manual schedule reviews. Automatically generate weekly summaries from your calendar data.
- Highlight priority events. Important meetings and deadlines are clearly flagged in the summary.
- Ensure timezone accuracy. Event times adapt to your specified timezone and locale.
- Streamline communication. Send polished email summaries directly via Gmail credentials.
Who This Is For
- Executives who need quick weekly overviews to focus on priorities.
- Administrative Assistants automating schedule briefings for leadership.
- Project Managers coordinating team calendars and stakeholder updates.
- Busy Professionals wanting consolidated daily plans to optimize time.
How It Works
- Calculate Date Range
- Determine the current time and the next 7 days in the user’s timezone, generating ISO timestamps and readable dates.
- Retrieve Calendar Events
- Fetch all events from the specified Google Calendar within the calculated date range using authorized credentials.
- Simplify Events Data
- Filter event details to essentials: title, description, start/end times, and location, reducing complexity for processing.
- Generate Weekly Summary
- Use a large language model to create a Markdown email summary, grouping events by day, marking important items, and adding weekly insights.
- Convert and Send Email
- Transform the Markdown summary to safe HTML and send it via Gmail to the specified recipient with a clear subject line.
What You'll Need
Before using this template, make sure you have:
- Google Calendar credentials authorized to read the user's calendar events.Gmail credentials authorized to send emails on behalf of the user.User parameters: IANA timezone identifier (e.g., "Australia/Sydney"), locale code (e.g., "en-US"), full name, home city (optional), calendar ID, and recipient email.
How to Use
- Step 1. Configure Credentials
- Step 2. Fill User Parameters
- Step 3. Run the Workflow
- Step 4. Review the Email
- Step 5. Confirm Execution
Set up Google Calendar and Gmail credentials with appropriate permissions.
Provide the user's timezone, locale, full name, home city (optional), calendar ID, and the recipient's email address.
Trigger the workflow to fetch events, generate the summary, convert to HTML, and send the email automatically.
Check the inbox of the specified recipient for the weekly summary email with the correct date range subject line.
Verify the workflow logs and email delivery status to ensure successful completion.
