Templates / Weekly OKR alignment report with Gmail, Google Calendar, Notion, and GPT-4.1

Weekly OKR alignment report with Gmail, Google Calendar, Notion, and GPT-4.1

Ready for 3.0

by Mark Ma · 439 views · created 2025-09-07 · Personal Productivity, AI Chatbot

Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.

What this workflow does

This AI workflow has 21 nodes and runs on a schedule (cron 0 30 20 * * 6). Along the way it connects Gmail, Google Calendar, OpenAI and Notion.

How it runs

Trigger: On a schedule (cron 0 30 20 * * 6).

  1. Get many messages (Gmail): get many
  2. Get many events (Google Calendar): get many
  3. Get weekly plan database (Notion): get many (database page)
  4. Get quarterly okr database (Notion): get many (database page)
  5. Gmail Filter (Code): runs custom JavaScript code
  6. Edit Fields (Edit Fields (Set)): sets 4 fields: summary, time, attendees…
  7. Filter: keeps only the items that match a condition
  8. Filter: keeps only the items that match a condition
  9. Edit Fields (Edit Fields (Set)): sets 4 fields: from_display, subject, date…
  10. Calendar Code (Code): runs custom JavaScript code

…plus 10 more steps. See the full node list below.

Services it uses

GmailGoogle CalendarOpenAINotion

Before you upgrade to n8n 3.0

Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.

Nodes used (10)

From the author

How it works This workflow is your personal CEO Brain. Every Saturday night, it automatically collects the past week’s activity across: - 📩 Gmail: filters out spam, promos, receipts, etc. - 📅 Google Calendar: grabs past week and upcoming month - 🗒️ Notion…

Excerpt from Mark Ma's description on n8n.io.

View the original on n8n.io → Check your own copy

Get the weekly “what broke” email

New templates, newly broken ones, and n8n release changes. One short email a week.

Form not loading? Subscribe here.