Weekly OKR Alignment and Performance Reporting Automation - n8n Workflow

• Executives, managers, and team leads needing automated weekly performance reviews.


• Users running OKR or project management systems in Notion.


• Professionals looking to leverage AI (GPT-4) for data synthesis and reporting.


• n8n users seeking advanced examples of multi-source data merging and processing in a single n8n workflow.

Tracking weekly progress against quarterly objectives (OKRs) can be a significant administrative burden, requiring manual compilation of emails, calendar entries, and task lists. This powerful n8n workflow eliminates that effort. It automatically extracts activity data from Gmail and Google Calendar, pulls OKR status and handwritten weekly plans (via Notion and GPT-4o vision), processes and sanitizes all inputs using several n8n node configurations, and feeds the consolidated information to an LLM. The final result is a structured, HTML-formatted report that checks alignment, highlights risks, and suggests next steps. This n8n workflow showcases advanced integration capabilities, providing highly valuable business intelligence on a reliable weekly schedule set by the n8n trigger.

The n8n workflow initiates weekly using the Schedule Trigger, set to run at a specific time (e.g., Saturday evening).

1. Parallel Data Extraction: Four main branches execute simultaneously to gather data from the past week: Gmail, Google Calendar, Notion Weekly Plan, and Notion Quarterly OKRs.


2. Data Cleaning & Structuring: Code and Set nodes standardize and filter the raw data. For instance, the Gmail branch filters out irrelevant messages, while the Calendar branch aggregates meeting details.


3. Vision Integration (Weekly Plan): The workflow filters the Notion database for the current week's plan entry. If this plan includes an image (a common practice for handwritten or quick plans), the HTTP Request n8n node downloads the file. The Analyze Image n8n node (using GPT-4o) then reads the visual data (such as an Eisenhower matrix) and converts handwritten tasks, including their completed status, into structured JSON.


4. Consolidation: Dedicated Code nodes convert each source (Emails, Calendar, Weekly Plan, OKRs) into clean, LLM-friendly text strings (emailsjoined, calendarjoined, etc.). These structured strings are then brought together using a series of Merge n8n node operations.


5. AI Analysis: The consolidated data is passed to the Message a Model n8n node (GPT-4.1). The comprehensive prompt instructs the model to compare weekly activities against the OKRs (the North Star), assess execution realism, identify email follow-ups, and generate actionable next steps.


6. Reporting: The final output, generated by the LLM in valid HTML format, is sent directly to the user via the final Gmail n8n node, completing the automated reporting cycle.

To deploy this powerful n8n workflow, follow these steps:

1. Import: Copy the provided JSON code and paste it into your n8n instance using the 'New' button and selecting 'Import from JSON'. This imports the core logic of these n8n templates.


2. Credentials Setup: You will need to configure the following credentials:

1. Notion Node Configuration: Update the database IDs within the 'Get quarterly okr database' and 'Get weekly plan database' n8n node configurations to match your specific Notion database URLs.


2. Personalization: In the 'Get many events' and 'Send a message' nodes, replace placeholder email addresses ([email protected]) with your actual email address.


3. Enable Workflow: Activate the n8n workflow. The schedule trigger is set for a weekly run.

Schedule Trigger (n8n trigger): The starting point for this automated n8n workflow. It is configured to run weekly using a specific cron expression, ensuring the report is generated reliably at the end of the work week.
Gmail (n8n node): Used twice. First, to retrieve emails from the past week. Second (final node), to send the generated HTML report. Key configuration: Retrieves all messages received after one week ago.
Get many events (Google Calendar n8n node): Fetches calendar events for the past week, critical for assessing time allocation and attendance.
Get weekly plan database & Get quarterly okr database (Notion n8n node): Connects to Notion databases. Key configuration involves specifying the unique database IDs for the relevant weekly plan and OKR structures.
Filter1 & Filter2 (Filter n8n node): These nodes ensure we only process the relevant data items. Filter1 matches the end date of the Notion weekly plan entry to today's date. Filter2 ensures the OKRs are active this week.
Analyze image (OpenAI n8n node): A core component utilizing GPT-4o for vision capabilities. Function: It takes a downloaded image file (e.g., a handwritten plan) and uses a detailed prompt to extract structured task data, including completion status, crucial for the weekly assessment.
Code Nodes (Gmail Code, Calendar Code, Weekly Code, Quarterly Code): Multiple custom Code n8n node instances are used to consolidate, clean, and format disparate data streams into standardized, dense text blocks, making them highly efficient inputs for the final LLM analysis.
Message a model1 (OpenAI n8n node): The analytical heart of the process. It receives all four structured text inputs and uses a system prompt to perform a deep alignment check and generate the final comprehensive report, outputting strict HTML.