Skip to main content

Manage Notion tasks and reports from chat with Gemini and Gmail

Workflow preview

Workflow preview
100%
Manage Notion tasks and reports from chat with Gemini and Gmail preview
Open on n8n.io

1. Workflow Overview

Chat with a Gemini powered operations assistant to create and update Notion tasks, send emails via Gmail, and pull live project summaries — all from a single chat interface. Daily and weekly status...

Best for

  • Project Management automation workflows
  • AI Chatbot automation workflows
  • advanced n8n builders looking for reusable templates

Tools used

@n8n/n8n-nodes-langchain.chattrigger, n8n-nodes-base.executeworkflowtrigger, @n8n/n8n-nodes-langchain.googlegemini, n8n-nodes-base.code, @n8n/n8n-nodes-langchain.lmchatgooglegemini, @n8n/n8n-nodes-langchain.toolworkflow, n8n-nodes-base.notiontool, @n8n/n8n-nodes-langchain.agent

Source and attribution

This workflow is cataloged by N8N Workflows and links back to its original n8n.io source page by Minibox Digital.

Original n8n.io source

1.1 Workflow description

Title
Manage Notion tasks and reports from chat with Gemini and Gmail
Workflow name
Manage Notion tasks and reports from chat with Gemini and Gmail

Chat with a Gemini-powered operations assistant to create and update Notion tasks, send emails via Gmail, and pull live project summaries — all from a single chat interface. Daily and weekly status reports also fire automatically on a schedule.

Who's it for Operations managers, project leads, and small teams who manage work in Notion and want a single conversational interface to handle task creation, updates, and reporting — without switching between tools.

How it works A chat trigger receives a plain-English message and passes it to Gemini, which classifies the intent into one of five actions: create a Notion task, update an existing task, send a Gmail, generate an on-demand report, or fetch the latest task ID. The message is routed to the matching AI agent, which calls the correct sub-workflow or tool and replies in chat. Two scheduled flows run independently — a daily status report every morning and a weekly progress digest every Friday — both pulling live data from your Notion Workstreams database and summarising it with Gemini.

How to set up

  1. Add your Google Gemini API credential in n8n and assign it to all Gemini nodes
  2. Add your Notion credential in n8n and connect it to your Workstreams database
  3. Add your Gmail OAuth2 credential in n8n
  4. Replace the placeholder database ID in every Notion node with your own
  5. After importing, open Call Sub-Create Workflow and Call Sub-Update Workflow and update the workflow ID to match your imported workflow

Requirements

  • n8n (cloud or self-hosted)
  • Google Gemini API key
  • Notion account with a Workstreams database
  • Gmail account with OAuth2 access

How to customize Add new intent labels to the Route by Intent node and wire them to your own agents to extend MiniBox with new capabilities. Swap the Notion field names in the Sub-Create and Sub-Update sections to match your own database schema.

1.2 Logical Blocks

This catalog entry is organized from the workflow JSON. The node-level section below shows the executable blocks available for review before importing the template.

2. Block-by-Block Analysis

Block 1 - When chat message received

Type / Role
@n8n/n8n-nodes-langchain.chatTrigger - chatTrigger
Config choices
Version 1.3

Block 2 - When Executed by Another Workflow

Type / Role
n8n-nodes-base.executeWorkflowTrigger - executeWorkflowTrigger
Config choices
Version 1.1

Block 3 - Gemini — Classify Intent

Type / Role
@n8n/n8n-nodes-langchain.googleGemini - googleGemini
Config choices
Version 1

Block 4 - Parse Intent from Response

Type / Role
n8n-nodes-base.code - code
Config choices
Version 2

Block 5 - Gemini — Task Creator

Type / Role
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - lmChatGoogleGemini
Config choices
Version 1

Block 6 - Call Sub-Create Workflow

Type / Role
@n8n/n8n-nodes-langchain.toolWorkflow - toolWorkflow
Config choices
Version 2.2

Block 7 - Gemini — Report Generator

Type / Role
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - lmChatGoogleGemini
Config choices
Version 1

Block 8 - Gemini — Email Composer

Type / Role
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - lmChatGoogleGemini
Config choices
Version 1

Block 9 - Read Notion DB — Report

Type / Role
n8n-nodes-base.notionTool - notionTool
Config choices
Version 2.2

Block 10 - Gemini — Notion Updater

Type / Role
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - lmChatGoogleGemini
Config choices
Version 1

Block 11 - Call Sub-Update Workflow

Type / Role
@n8n/n8n-nodes-langchain.toolWorkflow - toolWorkflow
Config choices
Version 2.2

Block 12 - Notion Updater Agent

Type / Role
@n8n/n8n-nodes-langchain.agent - agent
Config choices
Version 2.2

Block 13 - Report Generator Agent

Type / Role
@n8n/n8n-nodes-langchain.agent - agent
Config choices
Version 2.2

Block 14 - Email Composer Agent

Type / Role
@n8n/n8n-nodes-langchain.agent - agent
Config choices
Version 2.2

Block 15 - Task Creator Agent

Type / Role
@n8n/n8n-nodes-langchain.agent - agent
Config choices
Version 2.2

Block 16 - Fetch All Notion Tasks

Type / Role
n8n-nodes-base.notion - notion
Config choices
Version 2.2

Block 17 - Extract Latest TID

Type / Role
n8n-nodes-base.code - code
Config choices
Version 2

Block 18 - Read Notion DB — Updater

Type / Role
n8n-nodes-base.notionTool - notionTool
Config choices
Version 2.2

Block 19 - Get Current Date

Type / Role
n8n-nodes-base.dateTimeTool - dateTimeTool
Config choices
Version 2

Block 20 - Route by Intent

Type / Role
n8n-nodes-base.switch - switch
Config choices
Version 3.3

Block 21 - Send Gmail Message

Type / Role
n8n-nodes-base.gmailTool - gmailTool
Config choices
Version 2.1

Block 22 - Chatbot Section

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 23 - Build Notion Payload

Type / Role
n8n-nodes-base.set - set
Config choices
Version 3.4

Block 24 - Clear Date Field

Type / Role
n8n-nodes-base.set - set
Config choices
Version 3.4

Showing the first 24 of 45 workflow blocks. Download the JSON for the full node graph.

3. Summary Table

Workflow Manage Notion tasks and reports from chat with Gemini and Gmail
Complexity advanced
Nodes 45
Categories Project Management, AI Chatbot
Author Minibox Digital
Published 27 Apr 2026

4. Reproducing the Workflow from Scratch

  1. 1. Download the workflow JSON

    Use the JSON export at /data/workflows/15343/15343.json as the source template for this automation.

  2. 2. Import the template into n8n

    Open n8n, import the downloaded JSON, and review each node before activating the workflow.

  3. 3. Configure credentials and variables

    Replace placeholder credentials, API keys, webhook URLs, account IDs, and environment-specific values with your own settings.

  4. 4. Test with sample data

    Run the workflow manually or in a staging workspace, inspect node output, and confirm downstream systems receive the expected data.

  5. 5. Activate and monitor

    Enable the workflow only after testing, then monitor executions, errors, and rate limits during the first production runs.

5. General Notes & Resources

Review imported nodes carefully before activation. This catalog entry is intended to help you inspect the workflow structure, understand required services, and find related templates faster.

Node names, credentials, schedules, webhook paths, and external service limits may need adjustment for your workspace.

Frequently asked questions

What does Manage Notion tasks and reports from chat with Gemini and Gmail do?

Chat with a Gemini powered operations assistant to create and update Notion tasks, send emails via Gmail, and pull live project summaries — all from a single chat interface. Daily and weekly status...

What do I need before importing this workflow?

Review the workflow JSON, configure any required credentials in n8n, and test the automation in a safe workspace before using it in production.

Can I customize this workflow?

Yes. Use the block-by-block analysis and the downloadable JSON to inspect each node, then adjust credentials, prompts, schedules, filters, or destinations for your Project Management, AI Chatbot use case.