Weekly OKR alignment report with Gmail, Google Calendar, Notion, and GPT-4.1
Ready for 3.0What 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).
- Get many messages (Gmail): get many
- Get many events (Google Calendar): get many
- Get weekly plan database (Notion): get many (database page)
- Get quarterly okr database (Notion): get many (database page)
- Gmail Filter (Code): runs custom JavaScript code
- Edit Fields (Edit Fields (Set)): sets 4 fields: summary, time, attendees…
- Filter: keeps only the items that match a condition
- Filter: keeps only the items that match a condition
- Edit Fields (Edit Fields (Set)): sets 4 fields: from_display, subject, date…
- Calendar Code (Code): runs custom JavaScript code
…plus 10 more steps. See the full node list below.
Services it uses
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)
- Gmail
n8n-nodes-base.gmail - Edit Fields (Set)
n8n-nodes-base.set - Google Calendar
n8n-nodes-base.googleCalendar - OpenAI
@n8n/n8n-nodes-langchain.openAi - HTTP Request
n8n-nodes-base.httpRequest - Filter
n8n-nodes-base.filter - Code
n8n-nodes-base.code - Merge
n8n-nodes-base.merge - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Notion
n8n-nodes-base.notion
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…