(5/5)

mails2notion V2

Automated workflow: mails2notion V2. This workflow integrates 15 different services: filter, httpRequest, stickyNote, airtable, code. It contains 42 nodes and follows best practices for error handling and security.

Integrations Used (3)

Gmail

Airtable

HTTP Request

Workflow Structure (25 nodes)

100%

Gmail Trigger

Set

Globals

Filter

Filter for unprocessed mails

Set

Extract Route ID

Airtable

Get Route by ID

Filter

Active Routes Only

No Op

OpenAI Chat Model1

No Op

Generate Actionable Task

No Op

Calculator1

No Op

Structured Output Parser1

No Op

OpenAI Chat Model

No Op

Get Summary & Meta Data

No Op

Calculator

No Op

Structured Output Parser

Code

Format Notion Page Blocks

Http Request

Create Notion Page

Airtable

Deactivate Route

Gmail

Send notification about deactivated route

Gmail

Add Label "Processed"

Gmail

Add Label "Error"

Manual Trigger

When clicking ‘Test workflow’

Gmail

Get all labels

Filter

Required labels

No Op

No Operation, do nothing

Gmail

Send notification about missing route

Node Types:

default

logic

transform

action

http

trigger

code

Requires credentials

Prerequisites

Required Credentials (3)

Airtable Token

Used by: Deactivate Route, Get Route by ID

Docs

Gmail

Used by: Add Label "Processed", Add Label "Error" +4 more

Docs

OpenAI

Used by: OpenAI Chat Model, OpenAI Chat Model1

Docs

Multiple services required

This workflow needs 3 different credentials. Make sure you have accounts for all services before importing.

Complexity

Advanced

Expert level. Custom code, complex logic, many integrations.

Setup time: ~50 min

Score: 70/100

Custom Code

7 Integrations

When to Use This Workflow

Automated Reporting

Automatically collect and organize data into spreadsheets for analysis.

Spend less time on data entry and more time on insights.

Email Automation

Automate email responses, forwarding, or organization based on rules.

Handle routine email tasks automatically and focus on what matters.

Real-time Response

React instantly when events happen - new orders, form submissions, or API calls.

Zero delay between trigger and action for time-sensitive workflows.

workflow.json

{
  "id": "30r9acI1XVIIwAMi",
  "meta": {
    "instanceId": "workflow-e9306c07",
    "versionId": "1.0.0",
    "createdAt": "2025-09-29T07:07:42.879934",
    "updatedAt": "2025-09-29T07:07:42.879950",
    "owner": "n8n-user",
    "license": "MIT",
    "category": "automation",
    "status": "active",
    "priority": "high",
    "environment": "production"
  },
  "name": "mails2notion V2",
  "tags": [
    "automation",
    "n8n",
    "production-ready",
    "excellent",
...