Weekly time-allocation report from Google Calendar every Friday at 5pm

I want a weekly time-allocation report that shows where my hours actually went, delivered every Friday at 5pm America/New_York. Trigger this on a cron schedule.

When the workflow runs, call Google Calendar List Events for the past seven days on my primary calendar. Pull the start time, end time, title, attendees, color, and description for each event. Skip all-day events and any event I declined.

For every remaining event, categorize it into one of these buckets: Customer meetings, Internal sync, Recruiting, 1:1s, Focus time, Personal. Use a combination of signals: attendee email domains (external domains that are not mine count as Customer), title keywords (interview or candidate maps to Recruiting, 1:1 or one on one maps to 1:1s, focus or block or deep work maps to Focus time), and event color when present. If a meeting is ambiguous, use your judgement and pick the closest bucket.

For each bucket compute total hours (sum of durations) and meeting count. Also identify the three longest meetings of the entire week across all buckets, with title, duration, and bucket.

Then call Google Sheets Append Values on the Time Tracking tab of my time tracking spreadsheet. Append one row per bucket with these columns: date (the Friday the report covers, ISO format), bucket name, hours (one decimal), meeting count. Include all six buckets even if hours are zero, so the data accumulates cleanly over time.

Before posting the summary, call Google Sheets Get Values on the Time Tracking tab to read the prior weeks of data. Compute week-over-week deltas per bucket (this week's hours minus last week's hours) and identify the bucket with the largest absolute change.

Finally, call Slack Send a Message to post a short narrative summary to my personal Slack channel. The message should include: a one-line headline with total tracked hours, a clean bucket breakdown (bucket: hours, meeting count, delta vs last week with arrow), the three longest meetings of the week, and a one-line observation that calls out where I spent more or less time than usual based on the largest delta. Keep the tone direct and skimmable.