Weekly Time-Spent Report from Google Calendar
This automation analyzes your primary Google Calendar to generate a weekly report summarizing how your time was spent. It categorizes time into customer meetings, internal meetings, and independent work, then delivers a concise summary to a Slack channel of your choice.
This automation helps you understand and visualize your weekly time allocation. Here's how it works:
- It connects to your Google Calendar and retrieves all events from the past week (or a custom number of days).
- It intelligently categorizes each meeting as either "Internal" or "Customer" by analyzing the email domains of the attendees. You define which domains are considered internal.
- Based on your specified business hours, it calculates the total time spent in meetings and estimates the remaining time as "Independent Work".
- Finally, it compiles these totals into a clean, easy-to-read summary and sends it as a message to your designated Slack channel, giving you a clear overview of your week.
Usage Ideas
- Productivity Analysis: Get a weekly snapshot of your meeting load to find more time for deep work.
- Freelancer & Consultant Billing: Quickly estimate billable (customer-facing) vs. non-billable (internal) hours for a given week.
- Team Management: Run the automation for a team calendar to understand collective time allocation and meeting overhead.
- Project Tracking: If you use keywords in meeting titles for different projects, you can adapt the logic to report on time spent per project.
Customization Ideas
This template is a great starting point and can be easily tailored to your specific needs. You can work with the Agent Builder Assistant to:
- Define Your Company: Specify your company's email domains to ensure meetings are categorized correctly.
- Set Your Schedule: Adjust your daily business hours and choose whether to include weekends in the analysis.
- Choose Your Destination: Send the report to any Slack channel you belong to.
- Customize the Report: Change the text, emojis, and overall format of the report message posted in Slack.
- Refine Categorization: Modify the rules for how meetings are classified. For example, you could categorize them based on keywords in the meeting title instead of just attendee domains.
- Change Services: While it's set up for Google Calendar and Slack, you could adapt it to send the report via email or analyze a different calendar.