n8nflow.net logo

Weekly OKR Alignment Report with Gmail, Google Calendar, Notion, and GPT-4.1

by Mark Maβ€’Updated: Last update 23 days agoβ€’Source: n8n.io

Getting Started

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 Weekly Plan: pulls and analyzes a photo of your weekly plan (e.g., taken from a paper planner/notebook) using GPT-4o
  • 🎯 Notion OKRs: fetches quarterly OKRs and formats them for summary

It sends all the data to GPT-4.1, which generates a smart weekly report β€” including progress check, misalignments, overdue follow-ups, and next steps β€” then emails it to you as a Weekly OKR Report.


Set up steps

  • 🧠 Add your Gmail, Google Calendar, Notion, and OpenAI credentials
  • πŸ“… The Notion Weekly Plan should have a date property and an image field that holds a photo of your planner/notebook page
  • 🎯 The Notion OKR database should include objective , key result , and status fields
  • πŸ” Schedule is preset to every Saturday at 20:30 HK time (cron 0 30 20 * * 6). Also set the workflow timezone in n8n and, if self-hosting, the server/container TZ (e.g., TZ=Asia/Hong_Kong) to ensure correct triggering
  • πŸ’¬ You can modify the AI prompts inside the LLM nodes for more customized outputs