Weekly Journal & Task Summarization from Notion using GPT - n8n Workflow

Personal productivity enthusiasts who maintain daily journals and task lists in Notion.
Users looking for powerful n8n templates to leverage AI for data processing and personalized reporting.
Developers and power users who want a custom n8n workflow that combines database querying, code logic, and LLMs.
Anyone needing a weekly automated digest of their personal or work activities.

Maintaining a daily journal and tracking completed tasks are excellent habits, but manually reviewing and synthesizing this data weekly can be time-consuming. This highly effective n8n workflow solves this problem by completely automating the weekly review process. Utilizing a scheduled n8n trigger, the workflow connects to Notion, extracts all relevant journal entries and completed tasks from the past week, and then utilizes an AI model (specifically GPT-4.1 in this case) to synthesize the potentially vast amount of raw text into a single, cohesive summary. The resulting summary is simultaneously saved back into Notion for archival and published to a designated Discord channel for immediate review. Additionally, the n8n workflow provides a motivational summary of completed tasks, adding a fun, metric-driven component to your weekly review. This is an excellent example of how n8n can transform manual review processes into zero-touch automations.

This automation is initiated by an internal n8n trigger, specifically the Schedule Trigger, set to run every seven days. The workflow then splits into two distinct, parallel paths:

1. Weekly Journal Summarization (AI Path)

1. Data Retrieval: The n8n trigger initiates the Get Daily Journals n8n node, which queries a specified Notion database for all pages marked as 'Journal' that were edited within the 'past week'.


2. Content Extraction: For each retrieved journal entry, the Get many child blocks n8n node fetches the detailed content blocks.


3. Aggregation: The Aggregate n8n node combines all content from all daily entries into a single data item.


4. Data Preparation: The Combined Summary for LLM Code n8n node takes this aggregated text and cleans it up, preparing a single, large text blob ready for the language model.


5. AI Processing: The Generate Summary OpenAI n8n node receives the weekly journal text. It uses the powerful gpt-4.1 model and a custom system prompt to create a concise, thematic summary.


6. Distribution & Storage: The final AI-generated summary is sent immediately to Discord via the Send Summary n8n node. Concurrently, the same summary is stored back in the Notion database using the Save Back to Notion n8n node, tagged with a 'Weekly' type.

2. Weekly Task Summarization (Metrics Path)

1. Task Query: The Get Tasks n8n node runs in parallel, filtering a separate Notion task database for all items where the 'Completed Date' property falls within the 'past week'.


2. Metric Generation: The To Dos Totals Code n8n node counts the total number of tasks returned. It then generates a congratulatory message, including a fun emoji based on the task count threshold (e.g., achieving over 40 tasks earns a '✨🤩✨').


3. Reporting: The To Do Summary Discord n8n node immediately posts this motivational task metric message to the dedicated Discord channel. This seamless n8n workflow provides a complete weekly snapshot.

To deploy this comprehensive n8n workflow, follow these steps:

1. Import the n8n template: Copy the provided JSON and import it into your n8n instance using the 'New' button and selecting 'Import from JSON'.


2. Notion Credentials: You will need to set up a Notion API credential. Replace the existing credential references in the Get Daily Journals, Get Tasks, and Save Back to Notion n8n nodes with your new credential.


3. Notion Database Configuration: In the Get Daily Journals and Save Back to Notion n8n nodes, update the Database ID to point to your main Notes/Journal database. Ensure your database structure includes a Type select property with 'Journal' and 'Weekly' options.


4. Tasks Database Configuration: In the Get Tasks n8n node, update the Database ID to point to your Task tracking database. This database must have a Completed Date property.


5. OpenAI Credentials: Set up your OpenAI credential and link it to the Generate Summary n8n node. Ensure you have access to the model specified (e.g., GPT-4).


6. Discord Webhooks: Configure two separate Discord webhook credentials (one for the summary, one for the tasks) and link them to the Send Summary and To Do Summary n8n nodes.


7. Activate: Once all connections are set up, activate the n8n workflow to enable the weekly schedule trigger.

This n8n workflow relies on a precise configuration of several specialized n8n nodes:

Schedule Trigger (n8n trigger): The core activation point. Configured to run automatically every 7 days at 16:00, ensuring a consistent weekly review cadence.
Notion Node (Get Daily Journals/Get Tasks): Essential data access n8n node. Used to retrieve filtered data sets (journals tagged 'Journal' and tasks completed 'past_week'). Requires careful configuration of database IDs and filters.
Notion Node (Save Back to Notion): Responsible for writing the final, AI-generated summary back into the Notion database, complete with a dated title and 'Weekly' type property.
Code Node (Combined Summary for LLM): A custom n8n node used to iterate over and concatenate multiple journal entries into a single string for efficient processing by the language model.
Code Node (To Dos Totals): Calculates task metrics by counting input items and generates a dynamic, emoji-rich summary message. This demonstrates powerful customization within an n8n workflow.
OpenAI Node (Generate Summary): The key AI integration n8n node. Uses the gpt-4.1 model with a custom prompt to analyze the aggregated text and produce a concise summary.

• Discord Node (Send Summary/To Do Summary): The notification n8n node, configured with specific webhooks to push the AI-generated report and the task totals to a private channel.