AI Agent: Turn Emails into Structured Notion Tasks

Overview

Unlock your inbox productivity with this AI Agent. It acts as an intelligent bridge between your Gmail inbox and Notion workspace. By sending or forwarding an email to a unique alias (e.g., your.email+routeID@gmail.com), you trigger this agent to perform its magic. It uses the routeID to look up specific routing rules in Airtable, ensuring the right email goes to the right Notion database with the right permissions.

This agent has two core AI abilities powered by OpenAI's GPT-4o:

1. Task Generation: It analyzes the email content to create a concise, actionable task title and a detailed description, including bullet points for key details.
2. Summarization & Metadata Extraction: It generates a comprehensive summary of the email and accurately extracts the original sender, subject, and date, preserving context.

The result is a beautifully formatted, structured, and intelligent new page in Notion, created seconds after an email is received, no manual copy-pasting required.

Key Features & Benefits

• Intelligent Task Creation: Leverages OpenAI's GPT-4o to transform unstructured email text into clear, actionable tasks.
• Dynamic Routing: Use Airtable to manage multiple destinations. Simply create a new row in Airtable to route different email aliases to different Notion databases.
• Automated Notion Formatting: Automatically structures the AI-generated content into a clean Notion page with headings, paragraphs, and lists.
• Robust Error Handling: If a Notion page fails to be created, the agent deactivates the route in Airtable and sends an email notification back to the sender.
• Duplicate Prevention: Automatically labels processed emails in Gmail to ensure they are only handled once.

• An n8n instance (Cloud or self-hosted).
• OpenAI API Key (GPT-4o is recommended for best results).
• Airtable account with a Personal Access Token.
• Notion account with an Integration Token.
• Gmail account credentials configured in n8n (OAuth2 recommended).

1. Import the workflow into your n8n instance.
2. Create two new labels in your Gmail account: Processed and Error.
3. Follow the in-workflow setup notes (using the temporary manual trigger) to run the 'Get all labels' node. Find the IDs for your new labels and paste them into the 'Globals' node.
4. Set up an Airtable base with a table for your routes. It must have columns for the Notion Integration Token, the NotionDatabase URL, and a checkbox field named Active. The Record ID from this table will be used in your email alias.
5. Configure the 'Get Route by ID' node with your Airtable credentials, Base, and Table.
6. Configure the two 'OpenAI Chat Model' nodes with your OpenAI API Key.
7. Configure all 'Gmail' nodes with your n8n Gmail credentials.
8. Disable the manual setup path and activate the workflow. To test, send an email to your.email+AirtableRecordID@gmail.com.