Gemini-Powered Chatbot: Streamline Notion & Gmail Tasks

Transform your project management with this AI-powered chatbot that connects Notion, Gmail, and Google Gemini into one intelligent conversational interface. Skip the app-switching and manage your entire workflow through natural language commands.

What this workflow does

This Gemini-powered automation creates a smart operations assistant that handles five key actions through plain-English chat commands. The workflow receives your message, uses Gemini AI to classify your intent, then routes it to specialized agents that can create Notion tasks, update existing tasks, send Gmail messages, generate on-demand project reports, or fetch the latest task IDs from your database.

Beyond manual interactions, the system runs two automated reporting flows: daily status reports every morning and comprehensive weekly progress digests every Friday. Both pull live data from your Notion Workstreams database and use Gemini to create intelligent summaries of your project status.

Use cases

• Operations managers can quickly create and update project tasks without opening Notion
• Project leads can send status emails to stakeholders directly from chat
• Small teams can get instant project summaries and reports on-demand
• Remote teams can automate daily standups with scheduled status reports
• Busy professionals can manage their Notion workspace through quick chat commands

Technical details

Built with essential n8n nodes including If, Set, Code, Notion, Switch, and Date Time components. The workflow requires Google Gemini API credentials, Notion database access, and Gmail OAuth2 authentication. Setup involves connecting your Workstreams database, updating database IDs across Notion nodes, and configuring sub-workflow connections.

Perfect for n8n users seeking to streamline Notion and Gmail operations through AI-powered automation. This workflow eliminates context-switching while maintaining full control over your project data and communication workflows.